Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Problem with inserting data produced by the function (when the function is performed). | Bear | 08:30 |
| Thread | Author | Time |
|---|---|---|
| Fill array with series | Lee Hachadoorian | 19:47 |
| Re: Fill array with series | Pavel Stehule | 20:02 |
| ignore case in where clause | Edward W. Rouse | 20:26 |
| Re: ignore case in where clause | Guillaume Lelarge | 20:38 |
| Re: ignore case in where clause | Edward W. Rouse | 21:05 |
| Thread | Author | Time |
|---|---|---|
| Can I read the data without commit | John Fabiani | 21:33 |
| Re: Can I read the data without commit | Jonathan S. Katz | 21:40 |
| Re: Can I read the data without commit | Rob Sargent | 21:46 |
| Re: Can I read the data without commit | John Fabiani | 21:49 |
| Re: Can I read the data without commit | Rob Sargent | 22:00 |
| Re: Can I read the data without commit | John Fabiani | 22:11 |
| Re: Can I read the data without commit | Tim Landscheidt | 22:25 |
| Thread | Author | Time |
|---|---|---|
| how to concatenate in PostgreSQL | Rehan Saleem | 11:43 |
| Re: how to concatenate in PostgreSQL | Andreas Kretschmer | 11:57 |
| Re: how to concatenate in PostgreSQL | Allan Kamau | 13:42 |
| Thread | Author | Time |
|---|---|---|
| MS-SQL to PostgreSql | Rehan Saleem | 07:49 |
| Postgresql function with temporary tables | Rehan Saleem | 10:01 |
| Re: MS-SQL to PostgreSql | Robins Tharakan | 10:03 |
| Re: how to concatenate in PostgreSQL | Robins Tharakan | 10:15 |
| Re: MS-SQL to PostgreSql | Robins Tharakan | 10:25 |
| Re: how to concatenate in PostgreSQL | Steve Crawford | 16:08 |
| Thread | Author | Time |
|---|---|---|
| Re: how to concatenate in PostgreSQL | Steve Crawford | 16:12 |
| Thread | Author | Time |
|---|---|---|
| Wrong output from union | Gary Stainburn | 14:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Wrong output from union | David Johnston | 01:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Wrong output from union | Gary Stainburn | 09:11 |
| Thread | Author | Time |
|---|---|---|
| How to write cursors | La Chi | 07:44 |
| Cursor Error | La Chi | 09:23 |
| Re: Wrong output from union | Jasen Betts | 10:49 |
| Duplicate information in parent and child tables | JORGE MALDONADO | 22:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Duplicate information in parent and child tables | msi77 | 04:16 |
| how to write cursors | La Chi | 07:30 |
| Re: how to write cursors | Pavel Stehule | 07:36 |
| Thread | Author | Time |
|---|---|---|
| bad plan 📎 | Julien Cigar | 11:38 |
| Re: bad plan | Mario Dankoor | 12:03 |
| Re: bad plan 📎 | Julien Cigar | 12:08 |
| Re: bad plan | Mario Dankoor | 12:32 |
| Re: bad plan 📎 | Julien Cigar | 12:43 |
| Re: bad plan 📎 | Julien Cigar | 14:29 |
| Thread | Author | Time |
|---|---|---|
| syntax of joins | Andreas | 18:58 |
| Re: syntax of joins | Pavel Stehule | 19:23 |
| Re: syntax of joins | Rob Sargent | 19:28 |
| Re: syntax of joins | Pavel Stehule | 19:46 |
| Re: syntax of joins | Rob Sargent | 20:14 |
| Thread | Author | Time |
|---|---|---|
| How to html-decode a html-encoded field | JORGE MALDONADO | 15:59 |
| Re: How to html-decode a html-encoded field | Pavel Stehule | 16:01 |
| Thread | Author | Time |
|---|---|---|
| Re: sintax error | kevalshah | 11:57 |
| Re: sintax error | Tom Lane | 14:29 |
| Re: Pregunta acerca de la función COPY de POSTGRES | yeison garcia | 17:42 |
| UPDATE Multiple Records At Once? | Carlos Mennens | 17:50 |
| Re: UPDATE Multiple Records At Once? | lewbloch | 19:20 |
| Re: Re: Pregunta acerca de la función COPY de POSTGRES | Edward Ross | 20:43 |
| Re: UPDATE Multiple Records At Once? | Thomas Kellerer | 20:55 |
| ERROR: operator does not exist: integer = integer[] | cesar_cast | 21:01 |
| Thread | Author | Time |
|---|---|---|
| Re: How to html-decode a html-encoded field | Jasen Betts | 12:26 |
| Thread | Author | Time |
|---|---|---|
| Re: ERROR: operator does not exist: integer = integer[] | Pavel Stehule | 14:30 |
| 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 |