Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: 2 tables, joins and same name... 📎 | Josh Berkus | 16:44 |
| Re: 2 tables, joins and same name... | Ross J. Reedstrom | 18:21 |
| Thread | Author | Time |
|---|---|---|
| duplicated oid | Carolyn Lu Wong | 04:41 |
| [No subject] | Joseph Syjuco | 09:02 |
| Re: | Michael Davis | 16:29 |
| GRANT ALL ON TO GROUP failure | Jari Aalto | 16:34 |
| Re: | Joe Conway | 17:05 |
| Re: | Peter Eisentraut | 17:35 |
| Re: | Stephan Szabo | 17:45 |
| More on the TO DO wishlist | Chris Ruprecht | 18:06 |
| Re: INSERT Syntax 📎 | Josh Berkus | 19:33 |
| Re: More on the TO DO wishlist 📎 | Josh Berkus | 19:39 |
| Re: More on the TO DO wishlist | Peter Eisentraut | 21:24 |
| Re: On Differing Optimizer Choices ( Again) | Tom Lane | 22:33 |
| Re: Index Scan Backward vs. Sort/Sequential Scan when using ORDER BY | Tom Lane | 23:31 |
| Thread | Author | Time |
|---|---|---|
| Re: More on the TO DO wishlist 📎 | Josh Berkus | 03:16 |
| Re: 2 tables, joins and same name... 📎 | Josh Berkus | 03:18 |
| Need help in composing PostgreSQL query | Vladimir V. Zolotych | 06:23 |
| Re: Need help in composing PostgreSQL query | Oliver Elphick | 07:53 |
| Re: GRANT ALL ON TO GROUP failure | Henshall, Stuart - WCP | 09:53 |
| Re: 2 tables, joins and same name... | Jeff Eckermann | 15:10 |
| Re: [HACKERS] getting the oid for a new tuple in a BEFORE | Bruce Momjian | 15:33 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | postgresql | 17:11 |
| BUG in 7.1.3 | Alessandro Rossi | 21:34 |
| Re: duplicated oid | Carolyn Lu Wong | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: duplicated oid | Stephan Szabo | 00:23 |
| Re: duplicated oid | Tom Lane | 00:35 |
| Re: Combine query views into one SQL string | Nils Zonneveld | 08:10 |
| Re: Combine query views into one SQL string | Maik | 08:42 |
| Re: Combine query views into one SQL string | Nils Zonneveld | 09:00 |
| Re: ERROR: DefineQueryRewrite: rule plan string too big. | Tom Lane | 14:19 |
| Re: | Haller Christoph | 15:13 |
| ERROR: DefineQueryRewrite: rule plan string too big. | Haller Christoph | 15:38 |
| Thread | Author | Time |
|---|---|---|
| optimizing queries and indexes... | Robert J. Sanford, Jr. | 03:53 |
| Thread | Author | Time |
|---|---|---|
| Re: | postgresql | 03:12 |
| Re: Combine query views into one SQL string | Tony Hunt | 07:46 |
| Re: optimizing queries and indexes... 📎 | Josh Berkus | 20:03 |
| Re: Combine query views into one SQL string | Eimas | 23:20 |
| Thread | Author | Time |
|---|---|---|
| Re: optimizing queries and indexes... | Stephan Szabo | 00:06 |
| Re: optimizing queries and indexes... 📎 | Josh Berkus | 01:05 |
| Re: optimizing queries and indexes... | Stephan Szabo | 05:01 |
| array variable in pl/pgsql | jack | 07:47 |
| row level locking? | Jeff Barrett | 15:25 |
| calling a shell script from pl/pgsql | Jeff Barrett | 16:14 |
| Re: row level locking? | Stephan Szabo | 17:18 |
| Re: calling a shell script from pl/pgsql | Stephan Szabo | 17:22 |
| Re: calling a shell script from pl/pgsql | Larry Rosenman | 17:51 |
| pl/sh (was Re: calling a shell script from pl/pgsql) | Alex Pilosov | 18:17 |
| Re: pl/sh (was Re: calling a shell script from pl/pgsql) | Stephan Szabo | 18:19 |
| Re: pl/sh (was Re: calling a shell script from pl/pgsql) | Alex Pilosov | 18:24 |
| Re: calling a shell script from pl/pgsql | clayton cottingham | 18:44 |
| Re: calling a shell script from pl/pgsql | Jeff Barrett | 19:15 |
| Re: pl/sh (was Re: calling a shell script from pl/pgsql) | Peter Eisentraut | 19:26 |
| Re: calling a shell script from pl/pgsql | Larry Rosenman | 19:49 |
| Thread | Author | Time |
|---|---|---|
| array variable in pl/pgsql | datactrl | 00:45 |
| array variable in pl/pgsql | datactrl | 00:57 |
| array variables in pl/pgsql | Jack | 01:31 |
| group by weirdness | Joseph Shraibman | 02:11 |
| Re: group by weirdness 📎 | Josh Berkus | 04:06 |
| Re: Combine query views into one SQL string | Gledatelj | 06:33 |
| Re: calling a shell script from pl/pgsql | Jan Wieck | 07:08 |
| table inheritance and foreign key troubles | Kevin Way | 08:04 |
| SQL Query | Miguel González | 08:41 |
| Re: table inheritance and foreign key troubles | Christof Glaser | 09:12 |
| Re: table inheritance and foreign key troubles | Christof Glaser | 10:49 |
| Re: table inheritance and foreign key troubles | Stephan Szabo | 10:58 |
| Re: SQL Query | Adam Lang | 12:52 |
| referencing oid impozsible ? | patrick.jacquot | 14:58 |
| Re: referencing oid impozsible ? | Stephan Szabo | 16:58 |
| Re: referencing oid impozsible ? | Josh Berkus | 17:29 |
| To query many tables. | trebischt | 18:47 |
| using LATIN1 ? | Domingo Alvarez Duarte | 20:15 |
| Thread | Author | Time |
|---|---|---|
| Re: table inheritance and foreign key troubles | Kevin Way | 01:24 |
| Re: SQL Query | Miguel González | 07:51 |
| Which SQL query makes it possible to optain the 3 greatest values of an interger list ? | Yoann | 08:41 |
| How do I extract ONE particular field, when multiple table contain the same field name? | Olle Wijk | 09:06 |
| Re: Combine query views into one SQL string | Yoann | 10:18 |
| Re: How do I extract ONE particular field, when multiple table contain | Arne Weiner | 12:54 |
| Re: How do I extract ONE particular field, when multiple table contain the same field name? | Yoann | 13:47 |
| cache lookup failed | victor | 14:05 |
| Re: cache lookup failed | Peter Eisentraut | 15:00 |
| plpgsql function case statement | Peter Schmidt | 15:46 |
| Re: ERROR: Cannot insert a duplicate key into a unique index | Josh Berkus | 16:35 |
| ERROR: Cannot insert a duplicate key into a unique index | Haller Christoph | 17:06 |
| Thread | Author | Time |
|---|---|---|
| query time | Esteban Gutierrez Abarzua | 15:44 |
| Re: query time | Peter Eisentraut | 17:18 |
| Re: group by weirdness | Joseph Shraibman | 21:31 |
| Re: group by weirdness | Joseph Shraibman | 21:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Which SQL query makes it possible to optain the 3 greatest values of an interger list ? | Wei Weng | 00:08 |
| Re: Which SQL query makes it possible to optain the 3 greatest | Patrik Kudo | 00:11 |
| How to see the definition of an existing table? | ke wang | 00:35 |
| Re: Number the lines | Lee Harr | 03:12 |
| Re: To query many tables. | Andre Schnabel | 07:47 |
| Re: Checking for table existence | Hans-Juergen Schoenig | 08:48 |
| Re: How to Get Timestamp From SECONDS? | Hans-Juergen Schoenig | 08:56 |
| Thread | Author | Time |
|---|---|---|
| Re: optimizing queries and indexes... | Tom Lane | 04:34 |
| Intentional, or bug? | Kovacs Baldvin | 14:14 |
| Correction for the previous letter: | Kovacs Baldvin | 15:00 |
| Re: Intentional, or bug? | Tod McQuillin | 15:04 |
| Re: SQL request change when upgrade from 7.0.2 to 7.1.3 | Tom Lane | 19:11 |
| Re: Intentional, or bug? | Tom Lane | 19:31 |
| Re: Intentional, or bug? | Stephan Szabo | 19:44 |
| Re: optimizing queries and indexes... 📎 | Josh Berkus | 20:36 |
| Part 2 of "Intentional, or a bug".... | Kovacs Baldvin | 22:02 |
| Re: Part 2 of "Intentional, or a bug".... | Tom Lane | 23:06 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL request change when upgrade from 7.0.2 to 7.1.3 | Richard NAGY | 07:45 |
| Re: SQL request change when upgrade from 7.0.2 to 7.1.3 | Richard NAGY | 08:15 |
| Re: SQL request change when upgrade from 7.0.2 to 7.1.3 | Richard NAGY | 08:27 |
| Re: Part 2 of "Intentional, or a bug".... | Kovacs Baldvin | 08:47 |
| functions returning 📎 | Tomasz Myrta | 08:56 |
| Re: Number the lines | Kovacs Baldvin | 12:54 |
| Re: Number the lines | Haller Christoph | 14:15 |
| Re: Checking for table existence | Stephan Szabo | 14:57 |
| Re: I could do with some guidance | Josh Berkus | 15:27 |
| Out of free buffers... HELP! | Diehl, Jeffrey | 15:36 |
| PL/PGSQL Regexe | rdear | 15:41 |
| Re: group by weirdness | Carl van Tast | 18:07 |
| Implicit v Explicit joins... | [email protected] | 18:41 |
| Stored prosedure last run | Pasha | 18:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Out of free buffers... HELP! | Josh Berkus | 00:35 |
| Re: Out of free buffers... HELP! | Tom Lane | 06:55 |
| Trigger Problem | Mohammad Faisal | 07:58 |
| Re: PL/PGSQL Regexe | rdear | 09:45 |
| Re: Registring a C function in PostgreSQL II | Haller Christoph | 10:29 |
| table restruction 📎 | David M. Richter | 10:34 |
| Re: Trigger Problem | Andreas Joseph Krogh | 10:56 |
| Re: Selecting latest value | Haller Christoph | 11:11 |
| Re: table restruct... | Kovacs Baldvin | 13:40 |
| Re: Selecting latest value | Patrik Kudo | 13:57 |
| Re: table restruct... 📎 | David M. Richter | 14:31 |
| Re: table restruct... | Stephan Szabo | 14:46 |
| Re: Selecting latest value | Stephan Szabo | 14:49 |
| Re: Selecting latest value | Tom Lane | 15:07 |
| Re: Selecting latest value | Patrik Kudo | 15:12 |