Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Setting boolean column based on cumulative integer value | Richard Broersma Jr | 14:48 |
| Re: [SQL] Grants | Adrian Klaver | 15:42 |
| calling elog possibly causing problem in DirectFunctionCall1 | Rajesh Kumar Mallah | 16:40 |
| Re: Autovaccum | Shane Ambler | 17:06 |
| Re: calling elog possibly causing problem in DirectFunctionCall1 | Tom Lane | 17:47 |
| Re: calling elog possibly causing problem in DirectFunctionCall1 | Rajesh Kumar Mallah | 17:59 |
| Re: calling elog possibly causing problem in DirectFunctionCall1 | Rajesh Kumar Mallah | 18:58 |
| Problem inserting composite type values | Chris Dunworth | 19:15 |
| Re: Problem inserting composite type values | Stephan Szabo | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] Case Preservation disregarding case | Ken Johanson | 04:57 |
| Re: [HACKERS] Case Preservation disregarding case | Tom Lane | 05:55 |
| Re: [HACKERS] Case Preservation disregarding case | Ken Johanson | 07:32 |
| hi any one can help me | Penchalaiah P. | 10:33 |
| Re: hi any one can help me | Jeff Lu | 15:46 |
| Re: hi any one can help me | Aaron Bono | 15:54 |
| Re: [HACKERS] Case Preservation disregarding case | Ken Johanson | 16:00 |
| Re: [HACKERS] Case Preservation disregarding case | Bruce Momjian | 16:57 |
| Query for block updates | Amit Shah | 22:19 |
| Re: Query for block updates | Tom Lane | 22:22 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_xlog on separate drive | Markus Schaber | 10:56 |
| Re: pg_xlog on separate drive | Travis Whitton | 14:04 |
| Using Control Flow Functions in a SELECT Statement | Ashish Ahlawat | 16:21 |
| Re: Using Control Flow Functions in a SELECT Statement | Richard Broersma Jr | 16:30 |
| Re: Using Control Flow Functions in a SELECT Statement | Bricklen Anderson | 16:32 |
| Re: Using Control Flow Functions in a SELECT Statement | Ashish Ahlawat | 16:42 |
| Re: Using Control Flow Functions in a SELECT Statement | Richard Broersma Jr | 16:48 |
| Re: [SQL] Grants | Ezequias Rodrigues da Rocha | 17:08 |
| Thread | Author | Time |
|---|---|---|
| Re: I don't want receive more emails | Richard Broersma Jr | 01:02 |
| Re: [HACKERS] Case Preservation disregarding case | Ken Johanson | 04:28 |
| Proper way of iterating over the column names in a trigger function. | Rajesh Kumar Mallah | 12:30 |
| Count field in query | lucas | 12:32 |
| Re: Proper way of iterating over the column names in a trigger function. | Tom Lane | 15:02 |
| Query is fast and function is slow | Richard Ray | 15:44 |
| Re: Proper way of iterating over the column names in a trigger function. [ SOLVED] | Rajesh Kumar Mallah | 17:39 |
| INSERT DELETE RETURNING | Phillip Smith | 23:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Query is fast and function is slow | Thomas Pundt | 09:53 |
| Re: Query is fast and function is slow | Richard Ray | 14:53 |
| Re: Query is fast and function is slow | Thomas Pundt | 15:41 |
| Re: Query is fast and function is slow | Tom Lane | 16:40 |
| Re: Query is fast and function is slow | Richard Ray | 17:10 |
| could not find pathkey item to sort | Phillip Smith | 22:16 |
| Re: Query is fast and function is slow | Tom Lane | 22:59 |
| Re: could not find pathkey item to sort | Tom Lane | 23:42 |
| Thread | Author | Time |
|---|---|---|
| Problem with SQL stored procedure | sid tow | 11:27 |
| Re: Problem with SQL stored procedure | Shoaib Mir | 11:39 |
| Re: [HACKERS] Case Preservation disregarding case | Aaron Bono | 14:09 |
| Thread | Author | Time |
|---|---|---|
| subquery abnormal behavior | Shoaib Mir | 06:48 |
| Re: subquery abnormal behavior | Rajesh Kumar Mallah | 06:51 |
| Re: subquery abnormal behavior | Shoaib Mir | 06:57 |
| Re: subquery abnormal behavior | Michael Glaesemann | 07:03 |
| Re: subquery abnormal behavior | Shoaib Mir | 07:24 |
| Re: subquery abnormal behavior | Aaron Bono | 15:42 |
| Thread | Author | Time |
|---|---|---|
| Finding gaps in scheduled events | Marcin Stępnicki | 09:08 |
| TPCH Benchmark query result invalid | Cronje Fourie | 14:09 |
| Re: TPCH Benchmark query result invalid | Richard Huxton | 15:05 |
| Re: TPCH Benchmark query result invalid | Tom Lane | 16:23 |
| Re: Finding gaps in scheduled events | Richard Huxton | 20:13 |
| Re: Finding gaps in scheduled events | Erik Jones | 22:14 |
| Re: Finding gaps in scheduled events | Alvaro Herrera | 22:23 |
| Re: Finding gaps in scheduled events | Erik Jones | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: TPCH Benchmark query result invalid | Michael Glaesemann | 05:13 |
| Re: TPCH Benchmark query result invalid | Cronje Fourie | 05:53 |
| join and sort on 'best match' | Dirk Griffioen | 09:26 |
| Re: join and sort on 'best match' | Ragnar | 10:29 |
| Thread | Author | Time |
|---|---|---|
| Rule for multiple entries | William Scott Jordan | 02:04 |
| Re: Rule for multiple entries | Jim Buttafuoco | 02:53 |
| join a lot of columns of two tables | ivan marchesini | 11:01 |
| Re: join a lot of columns of two tables | Peter Childs | 11:09 |
| Re: join a lot of columns of two tables | Ragnar | 12:10 |
| Re: join and sort on 'best match' | Ashish Ahlawat | 13:10 |
| Re: join and sort on 'best match' | Markus Schaber | 15:36 |
| Thread | Author | Time |
|---|---|---|
| fetching & Merging BLOB | Ashish Ahlawat | 11:14 |
| Thread | Author | Time |
|---|---|---|
| Requirement for PostgreSQL Database Developer | Mark | 15:19 |
| SELECT with WHERE clause by column number | Carlos Santos | 17:17 |
| Re: SELECT with WHERE clause by column number | Richard Huxton | 17:25 |
| Re: SELECT with WHERE clause by column number | Aaron Bono | 17:36 |
| Res: SELECT with WHERE clause by column number | Carlos Santos | 18:36 |
| Re: SELECT with WHERE clause by column number | Ragnar | 21:56 |
| Thread | Author | Time |
|---|---|---|
| Query a select that returns all the fields of an specific value of primary key without knownig the name of the single column's primary key? | Carlos Santos | 14:01 |
| Re: Autovaccum | Markus Schaber | 14:23 |
| Re: null values in non-nullable column | Markus Schaber | 14:57 |
| Re: Query a select that returns.... | Achilleas Mantzios | 15:05 |
| Re: null values in non-nullable column | George Pavlov | 18:59 |
| Re: null values in non-nullable column | Richard Huxton | 19:33 |
| Desc table | Suma.Bommagani | 19:34 |
| Re: Desc table | Richard Huxton | 19:53 |
| Help with quotes in plpgsql | Richard Ray | 20:09 |
| Re: Help with quotes in plpgsql | Hector Villarreal | 20:17 |
| Re: Help with quotes in plpgsql | Jim Buttafuoco | 20:20 |
| Re: Help with quotes in plpgsql | Milen A. Radev | 20:22 |
| Re: Help with quotes in plpgsql | Richard Ray | 21:02 |
| Re: Help with quotes in plpgsql | Richard Ray | 21:02 |
| Re: Help with quotes in plpgsql | Milen A. Radev | 22:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Help with quotes in plpgsql | Hector Villarreal | 00:00 |
| Re: Help with quotes in plpgsql | Tom Lane | 00:27 |
| Fetching BLOBs | Ashish Ahlawat | 03:25 |
| Re: Fetching BLOBs | Richard Huxton | 06:59 |
| Re: Fetching BLOBs | Ragnar | 08:48 |
| join/group/count query. | Gary Stainburn | 10:12 |
| Re: join/group/count query. | Ragnar | 11:09 |
| Re: Help with quotes in plpgsql | Richard Ray | 14:10 |
| Re: Help with quotes in plpgsql | Richard Huxton | 14:26 |
| Re: join/group/count query. | Erik Jones | 15:46 |
| Re: join/group/count query. | Gary Stainburn | 16:20 |
| Re: join/group/count query. | Erik Jones | 16:32 |
| Re: join/group/count query. | Hector Villarreal | 18:06 |
| Thread | Author | Time |
|---|---|---|
| NEED URGENT HELP.... | Sandip G | 07:41 |
| Re: join/group/count query. | Gary Stainburn | 09:46 |
| Thread | Author | Time |
|---|---|---|
| Changing character set when the damage is done | Alexis Paul Bertolini | 23:12 |
| Re: Changing character set when the damage is done | Ragnar | 23:52 |
| Thread | Author | Time |
|---|---|---|
| I would like to alter the COPY command | Mason | 03:08 |
| Fwd: I would like to alter the COPY command | Mason | 03:08 |
| Re: Changing character set when the damage is done | Alexis Paul Bertolini | 16:05 |
| Re: Changing character set when the damage is done | Michael Fuhr | 16:57 |
| Re: Changing character set when the damage is done | Alexis Paul Bertolini | 17:44 |
| Re: Changing character set when the damage is done | Michael Fuhr | 19:12 |
| Thread | Author | Time |
|---|---|---|
| Re: [GENERAL] NEED URGENT HELP.... | Harpreet Dhaliwal | 17:32 |
| Related tables to a view | Jan Meyland Andersen | 21:52 |
| Re: NEED URGENT HELP.... | Guy Rouillier | 23:45 |
| Re: NEED URGENT HELP.... | Henrique P Machado | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Related tables to a view | Michael Fuhr | 04:10 |
| Re: Related tables to a view | Jan Andersen | 10:54 |
| Re: NEED URGENT HELP.... | Martijn van Oosterhout | 11:53 |
| Re: NEED URGENT HELP.... | Gurjeet Singh | 15:09 |
| Re: Related tables to a view | Jan Meyland Andersen | 20:10 |
| Re: Related tables to a view | Jim Buttafuoco | 20:27 |
| Thread | Author | Time |
|---|---|---|
| Re: NEED URGENT HELP.... | Iannsp | 00:28 |
| domains and serial | BillR | 03:10 |
| Re: Related tables to a view | Jan Meyland Andersen | 15:58 |
| Unable to drop table, error mentions "reltriggers" | Kashmira Patel (kupatel) | 19:52 |
| Re: Unable to drop table, error mentions "reltriggers" | Shoaib Mir | 20:09 |
| Thread | Author | Time |
|---|---|---|
| help with version checking | Arnau | 17:30 |
| Re: help with version checking | Daniel CAUNE | 17:45 |
| Re: help with version checking | Arnau | 17:50 |
| Re: help with version checking | Tom Lane | 17:56 |
| Re: help with version checking | Arnau | 18:14 |
| Re: help with version checking | Arnau | 18:20 |
| Re: help with version checking | Chris Dunworth | 18:32 |
| Thread | Author | Time |
|---|---|---|
| Help in altering the column lenght | roopa perumalraja | 01:05 |
| Re: help with version checking | Karsten Hilbert | 11:59 |
| Re: help with version checking | Arnau | 14:08 |
| How to reduce a database | Mario Behring | 15:09 |
| Re: help with version checking | Chris Dunworth | 17:17 |
| Re: How to reduce a database | Ragnar | 17:18 |
| Re: Fwd: I would like to alter the COPY command | Andrew Dunstan | 17:43 |
| Thread | Author | Time |
|---|---|---|
| Re: domains and serial | Bruce Momjian | 02:09 |
| or function | A. R. Van Hook | 17:43 |
| Re: or function | chester c young | 18:10 |
| Re: or function | Tom Lane | 18:11 |