Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Drop all indexes of a table w/o knowing the index names | Giulio Orsero | 14:40 |
| Re: tricky GROUP BY / JOIN question | T E Schmitz | 14:46 |
| upper/lower for german characters | Andrei Bintintan | 14:58 |
| Re: A transaction in transaction? Possible? | Theodore Petrosky | 15:24 |
| Re: Drop all indexes of a table w/o knowing the index names | Achilleus Mantzios | 15:30 |
| Loading text data/binary data !! | Goutam Paruchuri | 15:34 |
| Re: A transaction in transaction? Possible? | Bricklen | 16:20 |
| Re: Simple SQL Question | Franco Bruno Borghesi | 16:53 |
| Re: [SQL] upper/lower for german characters | Markus Schaber | 17:59 |
| Re: Drop all indexes of a table w/o knowing the index names | Giulio Orsero | 19:55 |
| select using regexp does not use indexscan | carex | 20:02 |
| Aggregate like AVG() with Money Data Type | andre.toscano | 20:40 |
| Comparing two (largish) tables on different servers | Gregory S. Williamson | 22:41 |
| Thread | Author | Time |
|---|---|---|
| Re: A transaction in transaction? Possible? | Gaetano Mendola | 08:10 |
| Re: A transaction in transaction? Possible? | Gaetano Mendola | 08:23 |
| Re: Unicode problem inserting records - Invalid UNICODE character | David B | 19:29 |
| Re: A transaction in transaction? Possible? | Stefan Weiss | 19:31 |
| Thread | Author | Time |
|---|---|---|
| Cascade updates wait until the end of the transaction? | Thomas Berg | 03:15 |
| Re: Unicode problem inserting records - Invalid UNICODE character 📎 | Richard Huxton | 08:18 |
| Re: Unicode problem inserting records - Invalid UNICODE | Markus Schaber | 09:57 |
| TEXT::CIDR/INET::CIDR output confusion | Alexander M. Pravking | 21:31 |
| Thread | Author | Time |
|---|---|---|
| anounce | Kenneth Gonsalves | 06:48 |
| postgreSQL 8beta | beyaNet | 14:35 |
| Re: select using regexp does not use indexscan | Stephan Szabo | 21:39 |
| Re: postgreSQL 8beta | Karsten Hilbert | 22:48 |
| Thread | Author | Time |
|---|---|---|
| Re: select using regexp does not use indexscan | Tom Lane | 00:02 |
| Re: UPDATE/INSERT on multiple co-dependent tables | Karsten Hilbert | 08:47 |
| View and subselect related questions | Jakub Kaniewski | 13:13 |
| Re: postgreSQL 8beta | Theodore Petrosky | 13:50 |
| Thread | Author | Time |
|---|---|---|
| Re: select using regexp does not use indexscan | carex | 17:12 |
| Thread | Author | Time |
|---|---|---|
| Re: tree structure photo gallery date quiery | Gary Stainburn | 00:35 |
| Re: tree structure photo gallery date quiery | Mike Rylander | 02:15 |
| Re: tree structure photo gallery date quiery | Oleg Bartunov | 08:04 |
| Re: tree structure photo gallery date quiery | Oleg Bartunov | 09:45 |
| Re: tree structure photo gallery date quiery | Achilleus Mantzios | 10:00 |
| session_id | Riccardo G. Facchini | 13:13 |
| Re: session_id | Richard Huxton | 13:49 |
| Re: session_id | Riccardo G. Facchini | 14:25 |
| Re: session_id | Riccardo G. Facchini | 14:27 |
| Re: session_id | Achilleus Mantzios | 14:33 |
| Re: session_id | Richard Huxton | 14:44 |
| Re: Counting Distinct Records | Stephan Szabo | 14:52 |
| Re: session_id | Riccardo G. Facchini | 15:04 |
| Re: session_id | Michael Fuhr | 15:19 |
| Re: session_id | Richard Huxton | 15:24 |
| Re: Counting Distinct Records | Thomas F.O'Connell | 19:27 |
| Thread | Author | Time |
|---|---|---|
| Usenet Discussion Proposal | Harry Smith | 03:01 |
| How to make lo_import and lo_export to use file on client local machine? | Premsun Choltanwanich | 10:45 |
| Re: session_id | Riccardo G. Facchini | 12:38 |
| missing... at end of sql expression | Justine.Cleary | 19:28 |
| Comparing Dates | Nick Peters | 21:01 |
| Re: Comparing Dates | Ian Barwick | 21:10 |
| Re: Comparing Dates | Thomas F.O'Connell | 21:15 |
| Re: Comparing Dates | Nick Peters | 21:34 |
| Thread | Author | Time |
|---|---|---|
| Re: NULLS and string concatenation | terry | 00:16 |
| Re: get sequence value of insert command | Erik Thiele | 09:24 |
| Re: Move table between schemas | Markus Schaber | 10:44 |
| How to get the max on a char column? | Rodrigo Carvalhaes | 14:53 |
| Re: How to get the max on a char column? | Rodrigo Carvalhaes | 15:54 |
| User defined types | Reza Shanbehbazari Mirzaei | 16:35 |
| Re: Move table between schemas | Tom Lane | 16:36 |
| Re: How to get the max on a char column? | Jeff Eckermann | 17:13 |
| Re: JOIN not being calculated correctly | Scott Pederick | 21:37 |
| Re: JOIN not being calculated correctly | Tom Lane | 21:51 |
| Thread | Author | Time |
|---|---|---|
| Functions return a select in a table, which data type I must use? (Brazilian User) | André Toscano | 23:07 |
| Thread | Author | Time |
|---|---|---|
| Re: missing... at end of sql expression | Tom Lane | 01:03 |
| Re: missing... at end of sql expression | Michael Fuhr | 01:09 |
| Re: session_id | Bruce Momjian | 04:31 |
| Doubt :- Image_Insert | sreejith s | 13:41 |
| Re: Doubt :- Image_Insert | Rod Taylor | 13:54 |
| Re: Doubt :- Image_Insert | Jerome Alet | 14:09 |
| Re: Doubt :- Image_Insert | Rod Taylor | 14:10 |
| Re: get sequence value of insert command | Passynkov, Vadim | 14:58 |
| Recursive SETOF function | Richard Rowell | 15:18 |
| Missing SELECT INTO ... DEFAULT VALUES in plpgsql for composite t ypes | Passynkov, Vadim | 16:43 |
| Re: Recursive SETOF function | Mike Rylander | 16:54 |
| Re: Recursive SETOF function | Mike Rylander | 16:56 |
| Re: Recursive SETOF function | Richard Rowell | 19:25 |
| Re: [postgres] Re: Recursive SETOF function | Mike Rylander | 19:39 |
| Re: [postgres] Re: Recursive SETOF function | Richard Rowell | 20:21 |
| Re: Recursive SETOF function | Pierre-Frédéric Caillaud | 23:19 |
| Thread | Author | Time |
|---|---|---|
| Image Insert Postgresql DB | sreejith s | 04:21 |
| Re: Image Insert Postgresql DB | Vishal Kashyap @ [SaiHertz] | 04:37 |
| Re: Image Insert Postgresql DB | Kenneth Gonsalves | 05:18 |
| Image Insert Doubt | sreejith s | 06:50 |
| Re: Image Insert Postgresql DB | Premsun Choltanwanich | 07:18 |
| Re: Image Insert Postgresql DB | Kenneth Gonsalves | 07:40 |
| Re: Image Insert Postgresql DB | Premsun Choltanwanich | 08:19 |
| Re: Image Insert Postgresql DB | Kenneth Gonsalves | 09:29 |
| Re: Image Insert Postgresql DB | Premsun Choltanwanich | 09:45 |
| PG7.4.5: query not using index on date column | Dave Steinberg | 14:28 |
| Re: Image Insert Doubt | Vishal Kashyap @ [SaiHertz] | 18:39 |
| Re: NULLS and string concatenation | Andrew Hammond | 19:16 |
| Thread | Author | Time |
|---|---|---|
| Encrypt data type LO | Alberto Pia | 16:28 |
| Explicitly rolling back transaction from within a C-Language function | Mark Dilger | 19:23 |
| Re: Explicitly rolling back transaction from within a C-Language function | Michael Fuhr | 19:53 |
| Thread | Author | Time |
|---|---|---|
| Re: User defined types | Tom Lane | 18:29 |
| HowTo change encoding type.... 📎 | Andrew M | 18:43 |
| Re: PG7.4.5: query not using index on date column | Tom Lane | 18:44 |
| Type Inheritance | Andrew Thorley | 21:47 |
| Thread | Author | Time |
|---|---|---|
| select with a function | Jaime Casanova | 06:41 |
| Re: HowTo change encoding type.... | Peter Eisentraut | 07:30 |
| tutorials for complex.sql & complex.c | Andrew Thorley | 09:56 |
| Re: tutorials for complex.sql & complex.c | Richard Huxton | 10:26 |
| Querying a list field against another list | Aarni Ruuhimäki | 14:17 |
| Re: Querying a list field against another list | Bruno Wolff III | 15:56 |
| Re: Type Inheritance | Tom Lane | 18:14 |
| Way to stop recursion? | Jonathan Knopp | 21:03 |
| Re: Way to stop recursion? | Tom Lane | 21:31 |
| Re: Way to stop recursion? | Andrew Sullivan | 21:34 |
| Re: Way to stop recursion? | Andrew Sullivan | 21:36 |
| Re: Way to stop recursion? | Jonathan Knopp | 21:53 |
| Re: Way to stop recursion? | Pierre-Frédéric Caillaud | 22:21 |
| Re: Querying a list field against another list | m | 23:04 |
| Re: Way to stop recursion? | Jonathan Knopp | 23:56 |
| Thread | Author | Time |
|---|---|---|
| how many JOINs ? | Konstantin Danilov | 11:11 |
| Re: Type Inheritance | Andrew Thorley | 14:04 |
| Re: Type Inheritance | Andrew Thorley | 15:33 |
| update/insert data | Keith Worthington | 17:55 |
| Thread | Author | Time |
|---|---|---|
| Re: [despammed] update/insert data | Kretschmer Andreas | 13:45 |