Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Scrolling cursors in PL/PgSQL | Dawid Kuroczko | 20:19 |
| Re: Scrolling cursors in PL/PgSQL | Raymond O'Donnell | 21:02 |
| Re: Scrolling cursors in PL/PgSQL | Pavel Stehule | 21:05 |
| Re: Scrolling cursors in PL/PgSQL | Tom Lane | 21:22 |
| Thread | Author | Time |
|---|---|---|
| omitting redundant join predicate | Ehab Galal | 13:14 |
| Re: omitting redundant join predicate | Tom Lane | 16:35 |
| SELECT DISTINCT ... ORDER BY UPPER(column_name) fails | Aymeric Levaux | 16:49 |
| Re: SELECT DISTINCT ... ORDER BY UPPER(column_name) fails | Tom Lane | 17:12 |
| Partitioning and Foreign Keys | Volkan YAZICI | 17:57 |
| Thread | Author | Time |
|---|---|---|
| Returning the total number of rows as a separate column when using limit | Andreas Joseph Krogh | 07:36 |
| Re: Backup Database | Asko Oja | 09:30 |
| changing encoding of a postgres database | Kenneth Gonsalves | 11:55 |
| Re: Returning the total number of rows as a separate column when using limit | Tom Lane | 14:18 |
| Re: Returning the total number of rows as a separate column when using limit | Andreas Joseph Krogh | 14:38 |
| Re: Returning the total number of rows as a separate column when using limit | Tom Lane | 15:00 |
| Re: omitting redundant join predicate | Ehab Galal | 15:15 |
| Re: Returning the total number of rows as a separate column when using limit | Gregory Stark | 15:27 |
| Re: omitting redundant join predicate | Tom Lane | 16:08 |
| Re: Returning the total number of rows as a separate column when using limit | Andreas Joseph Krogh | 16:33 |
| Re: Returning the total number of rows as a separate column when using limit | Gregory Stark | 18:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Returning the total number of rows as a separate column when using limit | Gregory Stark | 06:58 |
| Treating result of subselect as row | Ottó Havasvölgyi | 10:09 |
| Bitemporal - problem with correalated subquery? | Keith Carr | 12:51 |
| Thread | Author | Time |
|---|---|---|
| EPOCH TIMESTAMP Conversion Problem | Amitanand Chikorde | 10:37 |
| Temporal databases | Philippe Lang | 13:22 |
| Re: EPOCH TIMESTAMP Conversion Problem | Tom Lane | 15:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Partitioning and Foreign Keys | Vivek Khera | 16:45 |
| Obtaining the primary key of the record just inserted | Oliveiros Cristina | 17:56 |
| Re: Obtaining the primary key of the record just inserted | Scott Marlowe | 18:03 |
| Re: Obtaining the primary key of the record just inserted | Oliveiros Cristina | 19:10 |
| quote_nullable alternative? | Philippe Lang | 20:05 |
| Thread | Author | Time |
|---|---|---|
| Re: quote_nullable alternative? | Philippe Lang | 07:14 |
| design of tables for sparse data | Andreas | 13:39 |
| Re: Temporal databases | Keith Carr | 14:01 |
| Select in From clause | Ray Madigan | 17:21 |
| Re: Select in From clause | Alvaro Herrera | 18:35 |
| functions are returns columns | Michele Petrazzo - Unipex srl | 19:46 |
| Re: functions are returns columns | Pavel Stehule | 20:35 |
| Thread | Author | Time |
|---|---|---|
| Re: functions are returns columns | Michele Petrazzo - Unipex srl | 17:37 |
| Re: functions are returns columns | Gregory Stark | 19:36 |
| Re: functions are returns columns | Tom Lane | 19:46 |
| Re: functions are returns columns | Gregory Stark | 21:04 |
| Re: functions are returns columns | Tom Lane | 23:14 |
| Thread | Author | Time |
|---|---|---|
| general question on optimizer | chester c young | 00:23 |
| Thread | Author | Time |
|---|---|---|
| Re: Select in From clause | Bart Degryse | 08:23 |
| Re: Temporal databases | Philippe Lang | 09:07 |
| show value of backslashes in string array argument | Sabin Coanda | 09:15 |
| Re: show value of backslashes in string array argument | Sabin Coanda | 09:51 |
| Re: show value of backslashes in string array argument | Achilleas Mantzios | 09:58 |
| plpgsql language not aware of standard_conforming_strings ? | Sabin Coanda | 10:20 |
| Re: show value of backslashes in string array argument | Achilleas Mantzios | 10:20 |
| Re: plpgsql language not aware of standard_conforming_strings ? | Sabin Coanda | 11:10 |
| Re: show value of backslashes in string array argument | Tom Lane | 16:05 |
| Re: plpgsql language not aware of standard_conforming_strings ? | Sabin Coanda | 16:19 |
| Re: show value of backslashes in string array argument | Sabin Coanda | 17:12 |
| Problem with UNION-queries | Andreas Joseph Krogh | 20:27 |
| Re: design of tables for sparse data | Fernando Hevia | 21:48 |
| Thread | Author | Time |
|---|---|---|
| Re: design of tables for sparse data | Andreas | 02:10 |
| Re: design of tables for sparse data | Erik Jones | 15:33 |
| Thread | Author | Time |
|---|---|---|
| Originally created and last_mod by whom and when ? | Aarni Ruuhimäki | 11:06 |
| Re: Originally created and last_mod by whom and when ? | Richard Huxton | 11:28 |
| Re: ALL() question | Richard Huxton | 11:56 |
| Re: Originally created and last_mod by whom and when ? | Aarni Ruuhimäki | 12:39 |
| Re: ALL() question | Bart Degryse | 12:57 |
| Re: ALL() question | Richard Huxton | 13:20 |
| Re: ALL() question | Richard Huxton | 13:21 |
| Re: ALL() question | hubert depesz lubaczewski | 13:31 |
| ALL() question | Julien Cigar | 13:39 |
| Re: Temporal databases | Philippe Lang | 13:47 |
| Re: ALL() question | Julien Cigar | 14:50 |
| Re: ALL() question | Julien Cigar | 14:57 |
| Re: ALL() question | Osvaldo Rosario Kussama | 15:46 |
| Re: ALL() question | Julien Cigar | 15:50 |
| postgres bogged down beyond tolerance | Tena Sakai | 17:52 |
| Re: postgres bogged down beyond tolerance | Richard Broersma Jr | 18:35 |
| Thread | Author | Time |
|---|---|---|
| Re: postgres bogged down beyond tolerance | Gregory Stark | 09:33 |
| trap for any exception | Sabin Coanda | 13:45 |
| Re: trap for any exception | Sabin Coanda | 13:52 |
| Re: trap for any exception | Sabin Coanda | 13:54 |
| Re: trap for any exception | Stephan Szabo | 15:35 |
| Is there anything special about pg_dump's compression? | Jean-David Beyer | 16:05 |
| Re: Is there anything special about pg_dump's compression? | Andrew Sullivan | 16:11 |
| Re: trap for any exception | Stephan Szabo | 18:36 |
| Erlang & PostgreSQL native driver | Daniel Caune | 19:06 |
| Thread | Author | Time |
|---|---|---|
| Re: Is there anything special about pg_dump's compression? | Jean-David Beyer | 05:00 |
| Re: Is there anything special about pg_dump's compression? | Tom Lane | 05:29 |
| Re: trap for any exception | Bart Degryse | 07:56 |
| Re: Is there anything special about pg_dump's compression? | Jean-David Beyer | 12:54 |
| Re: Is there anything special about pg_dump's compression? | Shane Ambler | 16:40 |
| Re: Is there anything special about pg_dump's compression? | Jean-David Beyer | 20:36 |
| Thread | Author | Time |
|---|---|---|
| EXPLAIN ANALYZE inside functions | Sabin Coanda | 13:17 |
| Re: EXPLAIN ANALYZE inside functions | Sabin Coanda | 14:48 |
| Aggregate question (Sum) | Luiz K. Matsumura | 20:46 |
| Re: Aggregate question (Sum) | Rodrigo De León | 21:11 |
| Re: Aggregate question (Sum) | Luiz K. Matsumura | 23:17 |
| Thread | Author | Time |
|---|---|---|
| Run Function With First Priority | Otniel Michael | 09:21 |
| Loading 8.2 data into 8.1 | Andreas Joseph Krogh | 10:21 |
| dynmic column names inside trigger? | Louis-David Mitterrand | 16:12 |
| Re: dynmic column names inside trigger? | Tom Lane | 16:56 |
| Thread | Author | Time |
|---|---|---|
| Re: string function | Phillip Smith | 03:14 |
| Re: dynmic column names inside trigger? | Bart Degryse | 08:14 |
| PL argument max size, and doubt | Martin Marques | 13:23 |
| Re: PL argument max size, and doubt | Rodrigo De León | 15:29 |
| Re: PL argument max size, and doubt | Martin Marques | 17:46 |
| Re: PL argument max size, and doubt | Tom Lane | 18:05 |
| string function | gunartha | 18:54 |
| Thread | Author | Time |
|---|---|---|
| update on join ? | Andreas | 02:58 |
| Re: update on join ? | Frank Bax | 03:34 |
| Re: update on join ? | Richard Broersma Jr | 03:38 |
| Re: update on join ? | chester c young | 03:41 |
| Bad Schema Design or Useful Trick? | Richard Broersma Jr | 07:44 |
| How to have a unique primary key on two tables | Daniel "bodom_lx" Graziotin | 11:01 |
| Re: How to have a unique primary key on two tables | Bart Degryse | 11:11 |
| Re: How to have a unique primary key on two tables | A. Kretschmer | 11:19 |
| Re: Loading 8.2 data into 8.1 | Peter Eisentraut | 13:19 |
| Re: [SQL] Bad Schema Design or Useful Trick? | Richard Huxton | 13:46 |
| Re: How to have a unique primary key on two tables | D'Arcy J.M. Cain | 13:48 |
| Re: dynmic column names inside trigger? | Louis-David Mitterrand | 13:54 |
| Re: dynmic column names inside trigger? | Louis-David Mitterrand | 13:54 |
| Re: dynmic column names inside trigger? | Bart Degryse | 14:11 |
| Re: SQL state: 22P02 | Rodrigo De León | 16:06 |
| SQL state: 22P02 📎 | Franklin Haut | 16:24 |
| Re: PL argument max size, and doubt | Martin Marques | 21:36 |
| Thread | Author | Time |
|---|---|---|
| Re: PL argument max size, and doubt | Tom Lane | 06:40 |
| Aleatory exception | Sabin Coanda | 09:23 |
| Re: Aleatory exception | Sabin Coanda | 09:26 |
| Re: PL argument max size, and doubt | Martin Marques | 10:37 |
| Re: Aleatory exception - found cause | Sabin Coanda | 11:42 |
| Re: dynmic column names inside trigger? | Louis-David Mitterrand | 17:06 |
| Re: dynmic column names inside trigger? | Michael Glaesemann | 20:54 |
| Thread | Author | Time |
|---|---|---|
| Re: dynmic column names inside trigger? | Bart Degryse | 08:13 |
| PG trouble with index-usage in sort | Andreas Joseph Krogh | 21:08 |
| materialize | Ehab Galal | 21:17 |
| Re: materialize | Tom Lane | 21:53 |
| Thread | Author | Time |
|---|---|---|
| pg_clog (?) problem with VACUMM | Gerardo Herzig | 20:06 |
| Re: pg_clog (?) problem with VACUMM | Gregory Stark | 20:17 |
| Re: pg_clog (?) problem with VACUMM | Gerardo Herzig | 21:46 |
| Re: pg_clog (?) problem with VACUMM | Stefan Becker | 22:05 |
| Thread | Author | Time |
|---|---|---|
| Strang behaviour SELECT ... LIMIT n FOR UPDATE | Daniel Caune | 00:16 |
| NULLIF problem | Gera Mel Handumon | 02:04 |
| Re: NULLIF problem | Michael Glaesemann | 02:47 |
| Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE | Tom Lane | 04:46 |
| Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE | Bruce Momjian | 04:50 |
| obtaining column names from tables or views | John van Zantvoort | 15:13 |
| Re: obtaining column names from tables or views | Richard Huxton | 15:29 |
| Re: NULLIF problem | Erik Jones | 19:00 |
| Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE | Daniel Caune | 19:50 |
| Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE | Tom Lane | 20:33 |
| Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE | Daniel Caune | 21:28 |
| Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE | Tom Lane | 22:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE | Alvaro Herrera | 01:08 |
| Re: NULLIF problem | Gera Mel Handumon | 09:43 |
| Re: NULLIF problem | Michael Glaesemann | 12:46 |
| statement-level trigger sample out there? | Christian Kindler | 13:01 |
| Re: statement-level trigger sample out there? | Pavel Stehule | 13:48 |
| Re: statement-level trigger sample out there? | Stephen Cook | 14:16 |
| Re: statement-level trigger sample out there? | Pavel Stehule | 14:26 |
| [No subject] | Christian Kindler | 14:44 |
| Re: statement-level trigger sample out there? | Christian Kindler | 15:04 |
| Re: statement-level trigger sample out there? | Alvaro Herrera | 19:17 |
| Re: statement-level trigger sample out there? | Gerardo Herzig | 19:18 |
| Re: statement-level trigger sample out there? | Gerardo Herzig | 20:08 |
| Thread | Author | Time |
|---|---|---|
| Re: statement-level trigger sample out there? | hubert depesz lubaczewski | 09:41 |
| Using schema | Daniel Caune | 15:00 |