Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Uniform UPDATE queries | Dennis | 10:11 |
| Re: Uniform UPDATE queries | Rob Sargent | 15:10 |
| Re: Uniform UPDATE queries | Tom Lane | 16:24 |
| plpgsql : adding record variable to table | thomas veymont | 17:41 |
| plpgsql : adding record variable to table | thomas veymont | 17:55 |
| Re: plpgsql : adding record variable to table | Pavel Stehule | 18:03 |
| Thread | Author | Time |
|---|---|---|
| Re: plpgsql : adding record variable to table | thomas veymont | 09:43 |
| Re: plpgsql : adding record variable to table | Pavel Stehule | 10:08 |
| Re: Uniform UPDATE queries | Dennis | 10:55 |
| Re: plpgsql : adding record variable to table | thomas veymont | 11:56 |
| Re: plpgsql : adding record variable to table | Pavel Stehule | 11:58 |
| Re: Uniform UPDATE queries | Rob Sargent | 18:32 |
| Thread | Author | Time |
|---|---|---|
| getting the OS user name | John Fabiani | 14:28 |
| Re: getting the OS user name | Andreas Kretschmer | 14:52 |
| Re: getting the OS user name | John Fabiani | 14:57 |
| Thread | Author | Time |
|---|---|---|
| Re: getting the OS user name | Jasen Betts | 09:48 |
| Simple way to get missing number | Emi Lu | 14:15 |
| Re: Simple way to get missing number | hubert depesz lubaczewski | 14:31 |
| Re: Simple way to get missing number | Andreas Kretschmer | 14:36 |
| Re: Simple way to get missing number | Alban Hertroys | 14:41 |
| Re: Simple way to get missing number | Emi Lu | 15:21 |
| Re: Simple way to get missing number | Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) | 15:29 |
| Re: [SQL] Simple way to get missing number | Steve Crawford | 15:42 |
| Re: Simple way to get missing number | Andreas Kretschmer | 16:06 |
| Re: [SQL] Simple way to get missing number | Emi Lu | 18:10 |
| How to group by similarity? | Andreas | 18:39 |
| Re: [SQL] Simple way to get missing number | Steve Crawford | 18:56 |
| generic crosstab ? | Andreas | 20:01 |
| Re: generic crosstab ? | Samuel Gendler | 20:08 |
| Re: generic crosstab ? | Andreas | 21:34 |
| Re: generic crosstab ? | David Johnston | 21:42 |
| Re: generic crosstab ? | Joe Conway | 22:04 |
| Re: generic crosstab ? | Andreas | 22:37 |
| Thread | Author | Time |
|---|---|---|
| Re: generic crosstab ? | Pavel Stehule | 03:46 |
| Re: How to group by similarity? | Trinath Somanchi | 03:46 |
| Re: generic crosstab ? | Samuel Gendler | 05:07 |
| Regarding report generated by the pgFouine | Venkateswara Rao Dokku | 05:55 |
| How can this INSERT fail? | Peter Harris | 11:45 |
| Re: How can this INSERT fail? | Abbas | 12:29 |
| Re: How can this INSERT fail? | Peter Harris | 13:01 |
| Re: How can this INSERT fail? | Greg Sabino Mullane | 17:26 |
| Thread | Author | Time |
|---|---|---|
| Running mean filtering using Window Functions? | Andreas Gaab | 09:22 |
| Thread | Author | Time |
|---|---|---|
| pg_dump: aborting because of server version mismatch | Mitesh Shah | 19:55 |
| pg_dump: aborting because of server version mismatch | Mitesh Shah | 19:58 |
| pg_dump: aborting because of server version mismatch | Mitesh Shah | 20:23 |
| Re: pg_dump: aborting because of server version mismatch | Albin, Lloyd P | 21:01 |
| Re: [BUGS] pg_dump: aborting because of server version mismatch | Kevin Grittner | 21:53 |
| Re: [seapug] Re: [BUGS] pg_dump: aborting because of server version mismatchT | Robert Bernier | 22:27 |
| Thread | Author | Time |
|---|---|---|
| Re: [sfpug] pg_dump: aborting because of server version mismatch | Christophe Pettus | 03:27 |
| Thread | Author | Time |
|---|---|---|
| How change col name during query to use it in where clause | Marcel Ruff | 10:25 |
| Re: How change col name during query to use it in where clause | Andreas Kretschmer | 12:40 |
| Re: How change col name during query to use it in where clause | Oliveiros d'Azevedo Cristina | 12:43 |
| Re: How change col name during query to use it in where clause | Thomas Kellerer | 13:05 |
| Thread | Author | Time |
|---|---|---|
| Finding Max Value in a Row | Carlos Mennens | 19:03 |
| Re: Finding Max Value in a Row | Viktor Bojović | 19:17 |
| Re: Finding Max Value in a Row | Wes James | 19:17 |
| Re: Finding Max Value in a Row | David Johnston | 19:20 |
| Re: Finding Max Value in a Row | Thomas Kellerer | 19:24 |
| Re: Finding Max Value in a Row | Carlos Mennens | 19:30 |
| Re: [SQL] pg_dump: aborting because of server version mismatch | Adrian Klaver | 19:39 |
| Re: Finding Max Value in a Row | Adrian Klaver | 19:43 |
| Re: Finding Max Value in a Row | Thomas Kellerer | 19:44 |
| Re: Finding Max Value in a Row | Carlos Mennens | 19:50 |
| Re: Finding Max Value in a Row | Carlos Mennens | 19:53 |
| Re: Finding Max Value in a Row | Thomas Kellerer | 20:00 |
| Re: Finding Max Value in a Row | Thomas Kellerer | 20:05 |
| Re: Finding Max Value in a Row | Viktor Bojović | 20:42 |
| Re: Finding Max Value in a Row | Jasen Betts | 21:59 |
| Thread | Author | Time |
|---|---|---|
| syncing - between databases | John Fabiani | 14:28 |
| Thread | Author | Time |
|---|---|---|
| Re: syncing - between databases | Steven Crandell | 03:53 |
| Re: syncing - between databases | John Fabiani | 20:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Finding Max Value in a Row | Carlos Mennens | 02:38 |
| Re: Finding Max Value in a Row | Tom Lane | 03:11 |
| Re: syncing - between databases | Steven Crandell | 05:32 |
| Re: Finding Max Value in a Row | Samuel Gendler | 05:45 |
| Re: syncing - between databases | Trinath Somanchi | 11:52 |
| Re: syncing - between databases | Devrim GÜNDÜZ | 11:53 |
| Re: syncing - between databases | Trinath Somanchi | 11:55 |
| Re: syncing - between databases | Devrim GÜNDÜZ | 12:04 |
| order by different on mac vs linux | Wes James | 22:42 |
| Re: order by different on mac vs linux | Tom Lane | 23:00 |
| Thread | Author | Time |
|---|---|---|
| SELECT 1st field | Jan Bakuwel | 06:01 |
| Re: SELECT 1st field | msi77 | 06:25 |
| Re: SELECT 1st field | Misa Simic | 08:06 |
| Re: Finding Max Value in a Row | Dmitriy Igrishin | 11:00 |
| Re: SELECT 1st field | Tom Lane | 11:01 |
| Re: SELECT 1st field | Misa Simic | 12:21 |
| Re: order by different on mac vs linux | Wes James | 14:20 |
| Re: order by different on mac vs linux | Wes James | 15:39 |
| Re: order by different on mac vs linux | Wes James | 16:06 |
| Re: order by different on mac vs linux | Scott Marlowe | 16:16 |
| Re: order by different on mac vs linux | Wes James | 16:28 |
| Re: SELECT 1st field | Jan Bakuwel | 23:30 |
| Thread | Author | Time |
|---|---|---|
| Re: order by different on mac vs linux | Wes James | 22:46 |
| Re: order by different on mac vs linux | Samuel Gendler | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Re: order by different on mac vs linux | Wes James | 01:58 |
| Re: order by different on mac vs linux | Scott Marlowe | 02:24 |
| Thread | Author | Time |
|---|---|---|
| Need help in grouping records | Andreas | 19:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Need help in grouping records | Jasen Betts | 03:04 |
| Re: Need help in grouping records | Andreas | 09:08 |
| master/detail | Jan Bakuwel | 23:17 |
| Thread | Author | Time |
|---|---|---|
| Re: master/detail | Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) | 03:10 |
| Re: master/detail | Andreas Kretschmer | 04:34 |
| Re: master/detail | Mario Dankoor | 11:57 |
| Select every first/last record of a partition? | Andreas | 16:04 |
| Re: Select every first/last record of a partition? | Seth Gordon | 21:17 |
| Thread | Author | Time |
|---|---|---|
| Re: master/detail | Jan Bakuwel | 07:28 |
| Understanding Binary Data Type | Carlos Mennens | 17:13 |
| Thread | Author | Time |
|---|---|---|
| sub query and AS | Ferruccio Zamuner | 09:24 |
| left outer join only select newest record | Gary Stainburn | 09:27 |
| Re: left outer join only select newest record | Oliveiros d'Azevedo Cristina | 09:37 |
| Re: left outer join only select newest record | Pavel Stehule | 09:46 |
| Re: left outer join only select newest record | Gary Stainburn | 09:47 |
| Re: left outer join only select newest record | Thomas Kellerer | 10:22 |
| Re: left outer join only select newest record | Oliveiros d'Azevedo Cristina | 10:29 |
| Re: left outer join only select newest record | Gary Stainburn | 10:33 |
| Re: left outer join only select newest record | Oliveiros d'Azevedo Cristina | 10:41 |
| Re: sub query and AS | Lee Hachadoorian | 19:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Understanding Binary Data Type | Jasen Betts | 06:09 |
| Re: sub query and AS | Samuel Gendler | 07:07 |
| Re: left outer join only select newest record | Pavel Stehule | 08:17 |
| Re: left outer join only select newest record | Gary Stainburn | 08:21 |
| Re: left outer join only select newest record | Oliveiros d'Azevedo Cristina | 08:27 |
| Flatten table using timestamp and source | Elrich Marx | 09:01 |
| Re: Flatten table using timestamp and source | Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) | 11:59 |
| Re: Flatten table using timestamp and source | Elrich Marx | 12:10 |
| Re: Understanding Binary Data Type | F. BROUARD / SQLpro | 16:36 |
| Inherited table identification possible | George Woodring | 18:01 |
| Re: Inherited table identification possible | Jonathan S. Katz | 18:09 |
| Re: Inherited table identification possible | Stephen Belcher | 18:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Flatten table using timestamp and source | Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) | 05:50 |
| Job control in sql | Svenne Krap | 08:28 |
| Select row cells as new columns | danycxxx | 09:03 |
| Re: Select row cells as new columns | Jan Lentfer | 12:41 |
| Re: Job control in sql | Jan Lentfer | 12:52 |
| Re: Select row cells as new columns | danycxxx | 12:57 |
| Re: Inherited table identification possible | George Woodring | 13:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Flatten table using timestamp and source | Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) | 02:56 |
| Re: Flatten table using timestamp and source | Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) | 05:43 |
| Thread | Author | Time |
|---|---|---|
| Re: order by different on mac vs linux | Wes James | 03:37 |
| Re: order by different on mac vs linux | Wes James | 03:47 |
| Re: order by different on mac vs linux | Jasen Betts | 05:41 |
| Thread | Author | Time |
|---|---|---|
| possible bug in psql | chester c young | 03:11 |
| Re: possible bug in psql | Tom Lane | 03:34 |
| Re: Job control in sql | Ireneusz Pluta | 10:01 |
| Re: Job control in sql | Ireneusz Pluta | 10:32 |
| Re: possible bug in psql | Jasen Betts | 11:48 |
| Re: Job control in sql | Svenne Krap | 15:19 |
| Thread | Author | Time |
|---|---|---|
| Re: possible bug in psql | Craig Ringer | 01:13 |
| Re: possible bug in psql | chester c young | 03:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Select row cells as new columns | lewbloch | 16:55 |
| Re: Job control in sql | lewbloch | 16:56 |
| Re: Job control in sql | lewbloch | 16:58 |
| Re: order by different on mac vs linux | Wes James | 17:46 |
| Re: order by different on mac vs linux | Peter Eisentraut | 19:52 |
| Thread | Author | Time |
|---|---|---|
| Lowest 2 items per | Relyea, Mike | 14:34 |
| Re: Lowest 2 items per | Oliveiros d'Azevedo Cristina | 14:56 |
| Re: Lowest 2 items per | David Johnston | 15:13 |
| Re: Lowest 2 items per | Oliveiros d'Azevedo Cristina | 15:20 |
| Re: Lowest 2 items per | Relyea, Mike | 15:44 |
| Re: Lowest 2 items per | Relyea, Mike | 16:17 |
| Re: Lowest 2 items per | Oliveiros d'Azevedo Cristina | 16:28 |
| Re: Lowest 2 items per | Relyea, Mike | 16:35 |
| Re: Lowest 2 items per | Oliveiros d'Azevedo Cristina | 16:58 |
| Re: Lowest 2 items per | Mario Dankoor | 18:31 |
| Re: Lowest 2 items per | Relyea, Mike | 19:55 |
| Re: Lowest 2 items per | Relyea, Mike | 20:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Lowest 2 items per | msi77 | 13:56 |
| Re: Lowest 2 items per | Oliveiros | 15:00 |
| Re: Lowest 2 items per | msi77 | 16:32 |
| Thread | Author | Time |
|---|---|---|
| How to use hstore | Jan Eskilsson | 12:08 |
| Thread | Author | Time |
|---|---|---|
| Re: How to use hstore | Sergey Konoplev | 06:05 |
| Re: How to use hstore | Jan Eskilsson | 06:14 |
| creating a new trigger for a table on a slave host | rverghese | 18:00 |
| Thread | Author | Time |
|---|---|---|
| defaults in a function | John Fabiani | 15:08 |
| Re: defaults in a function | David Johnston | 15:27 |
| Thread | Author | Time |
|---|---|---|
| using ordinal_position | John Fabiani | 23:17 |
| Re: using ordinal_position | David Johnston | 23:32 |
| Thread | Author | Time |
|---|---|---|
| Re: using ordinal_position | Igor Neyman | 13:53 |
| Re: using ordinal_position | John Fabiani | 15:10 |
| Re: using ordinal_position | Igor Neyman | 15:14 |
| Thread | Author | Time |
|---|---|---|
| Partitioned Tables | Wayne Cuddy | 00:05 |
| how to use schema with data type | John Fabiani | 00:46 |
| Re: Partitioned Tables | Craig Ringer | 02:37 |
| Re: how to use schema with data type | Craig Ringer | 02:39 |
| Thread | Author | Time |
|---|---|---|
| Insane behaviour in 8.3.3 | Achilleas Mantzios | 08:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Insane behaviour in 8.3.3 | Adrian Klaver | 02:18 |
| Re: Insane behaviour in 8.3.3 | Richard Huxton | 06:34 |
| Re: Insane behaviour in 8.3.3 | Robert Edwards | 07:23 |
| Re: Insane behaviour in 8.3.3 | Achilleas Mantzios | 07:25 |
| Re: Insane behaviour in 8.3.3 | Scott Marlowe | 07:28 |
| Re: Insane behaviour in 8.3.3 | Achilleas Mantzios | 08:24 |
| Re: Insane behaviour in 8.3.3 | Samuel Gendler | 09:28 |
| Re: Insane behaviour in 8.3.3 | Samuel Gendler | 09:29 |
| Re: Insane behaviour in 8.3.3 | Achilleas Mantzios | 10:01 |
| Re: Insane behaviour in 8.3.3 | Achilleas Mantzios | 10:06 |
| Re: Insane behaviour in 8.3.3 | Scott Marlowe | 15:03 |
| Re: Insane behaviour in 8.3.3 | Achilleas Mantzios | 15:32 |
| Re: Insane behaviour in 8.3.3 | Richard Huxton | 15:41 |
| Re: Insane behaviour in 8.3.3 | Scott Marlowe | 16:59 |