Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Help on a complex query (avg data for day of the week) | Matthew Smith | 00:59 |
| Re: Help on a complex query (avg data for day of the week) | Michael Fuhr | 02:37 |
| lo function changed in PostgreSQL 8.1.1 (ask again) | Premsun Choltanwanich | 02:44 |
| Re: Help on a complex query (avg data for day of the week) | Matthew Smith | 02:59 |
| Re: Does VACUUM reorder tables on clustered indices | Bruce Momjian | 04:07 |
| Re: Querying date_time for date only ? | Bruce Momjian | 16:01 |
| Re: How to increase row deletion efficiency? 📎 | Alexander Stanier | 17:13 |
| Re: Does VACUUM reorder tables on clustered indices | Andrew Sullivan | 18:59 |
| Thread | Author | Time |
|---|---|---|
| Merry Xmas and a Happy New Year | Achilleus Mantzios | 14:16 |
| The Information Schema vs the PG Catalog | Ken Winter | 18:24 |
| Re: Merry Xmas and a Happy New Year | Terry Lee Tucker | 19:13 |
| Thread | Author | Time |
|---|---|---|
| Re: The Information Schema vs the PG Catalog | George Pavlov | 17:11 |
| order and order line item | David Garamond | 17:52 |
| constraint and ordered value | David Garamond | 17:52 |
| Re: The Information Schema vs the PG Catalog | Ken Winter | 19:32 |
| "large" IN/NOT IN subqueries result in query returning wrong data | George Pavlov | 19:41 |
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | Tom Lane | 19:44 |
| Re: "large" IN/NOT IN subqueries result in query returning | John McCawley | 19:53 |
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | George Pavlov | 20:36 |
| Thread | Author | Time |
|---|---|---|
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | elein | 00:12 |
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | Tom Lane | 00:25 |
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | elein | 00:35 |
| Cursors and recursion | Don Croata | 14:29 |
| instead of trigger in pg | J Crypter | 15:28 |
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | Greg Stark | 15:47 |
| Re: Cursors and recursion | Tom Lane | 15:48 |
| Re: instead of trigger in pg | Jaime Casanova | 16:03 |
| Re: Cursors and recursion | Michael Fuhr | 17:03 |
| Re: Cursors and recursion | Don Croata | 19:37 |
| DISTINCT with NULLs and INT fields | George Pavlov | 19:57 |
| Re: DISTINCT with NULLs and INT fields | Tom Lane | 20:19 |
| Re: DISTINCT with NULLs and INT fields | George Pavlov | 20:37 |
| Re: DISTINCT with NULLs and INT fields | Tom Lane | 20:46 |
| Re: DISTINCT with NULLs and INT fields | George Pavlov | 21:04 |
| Re: DISTINCT with NULLs and INT fields | Alvaro Herrera | 21:24 |
| Help with simple query | Collin Peters | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Help with simple query | Frank Bax | 00:41 |
| Re: Help with simple query | Tom Lane | 00:43 |
| Re: Help with simple query | PFC | 01:31 |
| Re: Help with simple query | George Pavlov | 01:47 |
| Re: DISTINCT with NULLs and INT fields | George Pavlov | 02:00 |
| Re: Cursors and recursion | Michael Fuhr | 02:48 |
| Re: DISTINCT with NULLs and INT fields | Tom Lane | 03:03 |
| Re: constraint and ordered value | Bruno Wolff III | 07:16 |
| Re: constraint and ordered value | Daryl Richter | 12:15 |
| Problem with simple update query | Simon Gardner | 15:11 |
| Arrays in PL/pgSQL routines? | Ken Winter | 17:46 |
| Re: constraint and ordered value | David Garamond | 17:48 |
| Re: Arrays in PL/pgSQL routines? | Bricklen Anderson | 17:52 |
| Re: Arrays in PL/pgSQL routines? | Michael Fuhr | 18:21 |
| Re: Arrays in PL/pgSQL routines? | Ken Winter | 18:23 |
| Re: Arrays in PL/pgSQL routines? | Tom Lane | 18:42 |
| Re: Arrays in PL/pgSQL routines? | Michael Fuhr | 18:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Does VACUUM reorder tables on clustered indices | Bruce Momjian | 03:00 |
| Re: Does VACUUM reorder tables on clustered indices | Tom Lane | 03:14 |
| Re: Does VACUUM reorder tables on clustered indices | Bruce Momjian | 03:25 |
| Thread | Author | Time |
|---|---|---|
| plpgsql triggers in rules | chester c young | 18:19 |
| session variables in 8.0 | chester c young | 18:21 |
| exceptions in rules | chester c young | 18:22 |
| Thread | Author | Time |
|---|---|---|
| avg() with floating-point types | George Pavlov | 00:40 |
| Re: avg() with floating-point types | Tom Lane | 01:25 |
| Re: avg() with floating-point types | Michael Fuhr | 01:27 |
| PostgreSQL and uuid/guid | Mario Splivalo | 13:26 |
| delete from a using b in postgres 8.1. | Peter Childs | 13:28 |
| Thread | Author | Time |
|---|---|---|
| Re: delete from a using b in postgres 8.1. | Jaime Casanova | 19:18 |
| getting a query column to return 0 if nothing matches | Dan Tenenbaum | 22:15 |
| Thread | Author | Time |
|---|---|---|
| Loading lots of data in a SQL command | frank church | 01:32 |
| Re: getting a query column to return 0 if nothing matches | Michael Fuhr | 02:42 |
| Re: Loading lots of data in a SQL command | Richard Huxton | 09:21 |
| Regular Expression Matching problem... | Mario Splivalo | 14:08 |
| Re: Regular Expression Matching problem... | A. Kretschmer | 14:50 |
| Re: Regular Expression Matching problem... | Michael Fuhr | 17:00 |
| JOIN question with multiple records | Scott, Casey | 19:54 |
| Thread | Author | Time |
|---|---|---|
| FOREIGN KEYs ... I think ... | Marc G. Fournier | 01:49 |
| Re: FOREIGN KEYs ... I think ... | Tom Lane | 01:54 |
| Re: FOREIGN KEYs ... I think ... | Marc G. Fournier | 03:12 |
| Re: FOREIGN KEYs ... I think ... | Jim Johannsen | 03:31 |
| Re: FOREIGN KEYs ... I think ... | nospam | 03:58 |
| Re: JOIN question with multiple records | Richard Huxton | 08:40 |
| Re: FOREIGN KEYs ... I think ... | Leif B. Kristensen | 11:39 |
| Thread | Author | Time |
|---|---|---|
| Re: FOREIGN KEYs ... I think ... | Marc G. Fournier | 01:23 |
| Re: PostgreSQL and uuid/guid | george young | 02:38 |
| INSERT waiting under heavy load | alex-lists-pgsql | 18:42 |
| Re: INSERT waiting under heavy load | alex-lists-pgsql | 20:16 |
| Re: INSERT waiting under heavy load | Tom Lane | 20:52 |
| Re: INSERT waiting under heavy load | Tom Lane | 21:49 |
| Thread | Author | Time |
|---|---|---|
| how to transform list to table and evaluate an expression on it? | Tomas Vondra | 16:03 |
| Re: how to transform list to table and evaluate an | Frank Bax | 20:47 |
| Thread | Author | Time |
|---|---|---|
| Re: INSERT waiting under heavy load | Andrew Sullivan | 18:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Regular Expression Matching problem... | Mario Splivalo | 01:22 |
| system view corrupted, i get "unexpected right parenthesis" for many system tables. | David Ford | 19:33 |
| Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. | Tom Lane | 20:23 |
| Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. | David Ford | 21:01 |
| Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. | Tom Lane | 21:37 |
| Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. | David Ford | 23:03 |
| Thread | Author | Time |
|---|---|---|
| Regexp group matching - extracting second group element? | Mario Splivalo | 14:18 |
| Thread | Author | Time |
|---|---|---|
| Unable to identify an ordering operator '<' for type 'smallint[]' | Mauricio Fernandez A. | 17:55 |
| Re: Unable to identify an ordering operator '<' for type 'smallint[]' | Jaime Casanova | 18:14 |
| Re: Unable to identify an ordering operator '<' for type 'smallint[]' | Tom Lane | 18:24 |
| psql client: technique for applying default values to :variables? | Jeff Boes | 18:48 |
| Re: Unable to identify an ordering operator '<' for type 'smallint[]' | Mauricio Fernandez A. | 20:07 |
| foreign keys with on delete cascade and triggers | Dirk Jagdmann | 22:56 |
| Re: psql client: technique for applying default values to :variables? | Tony Wasson | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: foreign keys with on delete cascade and triggers | Tom Lane | 03:02 |
| error code invalid_input_syntax | Rainer Leo | 08:43 |
| Re: foreign keys with on delete cascade and triggers | Dirk Jagdmann | 11:49 |
| Re: foreign keys with on delete cascade and triggers | Tom Lane | 15:46 |
| Re: error code invalid_input_syntax | Tom Lane | 16:05 |
| Re: plpgsql triggers in rules | Markus Schaber | 17:01 |
| Re: exceptions in rules | Markus Schaber | 17:04 |
| Thread | Author | Time |
|---|---|---|
| info is a reserved word? | John DeSoi | 01:14 |
| Re: info is a reserved word? | Michael Fuhr | 01:29 |
| Re: info is a reserved word? | Tom Lane | 04:21 |
| Re: info is a reserved word? | Michael Fuhr | 04:57 |
| Re: [SQL] info is a reserved word? | Tom Lane | 05:10 |
| ORDER BY does not work as expected with multiple joins | Adam Rosi-Kessel | 14:32 |
| Re: ORDER BY does not work as expected with multiple joins | Tom Lane | 14:56 |
| Re: ORDER BY does not work as expected with multiple joins | Adam Rosi-Kessel | 15:14 |
| Re: ORDER BY does not work as expected with multiple joins | Michael Glaesemann | 15:19 |
| Re: ORDER BY does not work as expected with multiple joins | Adam Rosi-Kessel | 15:22 |
| Re: ORDER BY does not work as expected with multiple joins | Michael Glaesemann | 15:45 |
| Re: ORDER BY does not work as expected with multiple joins | Tom Lane | 15:56 |
| Re: ORDER BY does not work as expected with multiple joins | Michael Glaesemann | 16:07 |
| Re: ORDER BY does not work as expected with multiple joins | Jaime Casanova | 16:20 |
| Thread | Author | Time |
|---|---|---|
| Another orderby problem | Alan Chandler | 13:02 |
| Re: Another orderby problem | A. Kretschmer | 13:09 |
| Re: Another orderby problem | D'Arcy J.M. Cain | 13:13 |
| Re: Another orderby problem | Alan Chandler | 14:28 |
| Re: psql client: technique for applying default values to :variables? 📎 | Jeff Boes | 14:54 |
| Re: psql client: technique for applying default values to :variables? | Michael Glaesemann | 22:38 |
| Thread | Author | Time |
|---|---|---|
| select and as doubt | Alexandre Gonçalves Jacarandá | 03:55 |
| Re: select and as doubt | Tom Lane | 04:28 |
| Trigger for Large Object Modification | Andreas Roth | 10:12 |
| Re: select and as doubt | Alexandre Gonçalves Jacarandá | 14:59 |
| What does "merge-joinable join conditions" mean ???? | Dean Gibson (DB Administrator) | 20:25 |
| Re: What does "merge-joinable join conditions" mean ???? | Michael Fuhr | 21:54 |
| Re: What does "merge-joinable join conditions" mean ???? | Tom Lane | 21:58 |
| Re: What does "merge-joinable join conditions" mean ???? | Tom Lane | 22:19 |
| Re: What does "merge-joinable join conditions" mean ???? | Dean Gibson (DB Administrator) | 22:28 |
| Re: What does "merge-joinable join conditions" mean ???? | Tom Lane | 23:21 |
| Re: What does "merge-joinable join conditions" mean ???? | Dean Gibson (DB Administrator) | 23:31 |
| Re: What does "merge-joinable join conditions" mean ???? | Dean Gibson (DB Administrator) | 23:47 |
| Thread | Author | Time |
|---|---|---|
| Re: What does "merge-joinable join conditions" mean ???? | Tom Lane | 00:10 |
| Executing plpgsql scripts using psql, is that possible? | Daniel CAUNE | 10:35 |
| Re: Executing plpgsql scripts using psql, is that possible? | John DeSoi | 13:50 |
| Re: psql client: technique for applying default values to :variables? | Jeff Boes | 15:33 |
| For update | Ottó Havasvölgyi | 16:59 |
| Re: psql client: technique for applying default values to :variables? | Andreas Seltenreich | 17:02 |
| Re: For update | Alvaro Herrera | 17:05 |
| Re: For update | Michael Fuhr | 17:29 |
| best way for constants in the database | chester c young | 18:49 |
| Re: best way for constants in the database | Owen Jacobson | 18:53 |
| Re: For update | Ottó Havasvölgyi | 21:33 |
| Re: For update | Alvaro Herrera | 21:37 |
| Re: For update | Ottó Havasvölgyi | 22:15 |
| Re: For update | Ottó Havasvölgyi | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Executing plpgsql scripts using psql, is that possible? | Daniel CAUNE | 01:55 |
| Re: Executing plpgsql scripts using psql, is that possible? | Adrian Klaver | 02:35 |
| Re: Executing plpgsql scripts using psql, is that possible? | John DeSoi | 02:54 |
| Re: Executing plpgsql scripts using psql, is that possible? | Daniel CAUNE | 03:10 |
| Re: Characters that needs escape characters when inserting to database | Michael Glaesemann | 07:20 |
| Re: Characters that needs escape characters when inserting to database | Michael Fuhr | 17:56 |
| non-equi self-join optimization | George Pavlov | 20:57 |
| Characters that needs escape characters when inserting to database | Christian Paul B. Cosinas | 22:21 |
| Thread | Author | Time |
|---|---|---|
| Error calling self-made plpgsql function "function XYZ(bigint) does not exist" | Juris | 12:39 |
| Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" | Michael Glaesemann | 12:48 |
| Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" | Juris | 13:06 |
| indexing for left join | T E Schmitz | 15:41 |
| Re: indexing for left join | Richard Huxton | 15:52 |
| Re: indexing for left join | Rod Taylor | 15:57 |
| Re: indexing for left join | T E Schmitz | 16:42 |
| Re: indexing for left join | T E Schmitz | 16:42 |
| Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" | Leif B. Kristensen | 16:45 |
| Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" | Michael Glaesemann | 22:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" | Juris | 06:52 |
| Re: Error calling self-made plpgsql function "function XYZ(bigint) | Markus Schaber | 10:56 |
| Thread | Author | Time |
|---|---|---|
| Re: indexing for left join | Zulq Alam | 13:51 |
| Thread | Author | Time |
|---|---|---|
| How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? | Jesper K. Pedersen | 20:13 |
| Re: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? | Tom Lane | 20:46 |
| Re: How to implement Microsoft Access boolean (YESNO) | Jesper K. Pedersen | 21:13 |
| Thread | Author | Time |
|---|---|---|
| DBMirror.pl performance change 📎 | Achilleus Mantzios | 10:57 |