Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: SQL report | wkipjohn | 00:08 |
| Re: SELECT max(time) group by problem | nha | 00:46 |
| Re: SQL report | wkipjohn | 03:55 |
| Re: Show CAS, USD first; the left ordered by currency name | Harald Fuchs | 11:37 |
| Re: Show CAS, USD first; the left ordered by currency name | bricklen | 13:27 |
| Re: Show CAS, USD first; the left ordered by currency name | Emi Lu | 14:05 |
| on error resume next | Jasmin Dizdarevic | 15:24 |
| Re: SQL report | Rob Sargent | 15:50 |
| Re: on error resume next | Andreas Wenk | 18:12 |
| Re: on error resume next | Jasmin Dizdarevic | 18:52 |
| How fetch multiple rows into one text-field? | Andreas | 20:09 |
| Re: How fetch multiple rows into one text-field? | Joshua Tolley | 23:29 |
| Thread | Author | Time |
|---|---|---|
| Activity count problem | dino | 09:02 |
| Problems when copy data from dump file | Klas Stockhem | 11:00 |
| Re: Tweak sql result set... ? | Axe | 11:13 |
| Problems when copy data from dump file | Klas Stockhem | 12:08 |
| Create table command fails with permission denied | Venkateswara Rao Bondada | 12:08 |
| Re: Create table command fails with permission denied | Rob Sargent | 22:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Problems when copy data from dump file | Richard Huxton | 08:09 |
| Re: Create table command fails with permission denied | Venkateswara Rao Bondada | 08:11 |
| Re: Problems when copy data from dump file | Richard Huxton | 13:26 |
| Re: Create table command fails with permission denied | Rob Sargent | 16:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Create table command fails with permission denied | Tom Lane | 01:16 |
| Re: Problems when copy data from dump file | Klas Stockhem | 09:56 |
| question about pgagent | Jan Verheyden | 13:54 |
| Re: Create table command fails with permission denied | Venkateswara Rao Bondada | 17:05 |
| Re: LOG: unexpected EOF on client connection | Bernd Nawothnig | 18:40 |
| two records per row from query | John | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: LOG: unexpected EOF on client connection | Tom Lane | 02:19 |
| Re: two records per row from query | A. Kretschmer | 05:21 |
| Re: Problems when copy data from dump file | Richard Huxton | 07:36 |
| Re: Problems when copy data from dump file | Klas Stockhem | 08:39 |
| Re: Problems when copy data from dump file | Richard Huxton | 08:42 |
| trigger problem | Jan Verheyden | 09:09 |
| Problems when copy data from dump file | Klas Stockhem | 10:00 |
| Re: two records per row from query | Leo Mannhart | 13:42 |
| Re: two records per row from query | John | 13:48 |
| FW: trigger problem | Jan Verheyden | 13:56 |
| Re: two records per row from query | A. Kretschmer | 14:21 |
| Re: two records per row from query | John | 15:46 |
| Thread | Author | Time |
|---|---|---|
| Re: two records per row from query | Leo Mannhart | 09:50 |
| Re: two records per row from query | John | 13:28 |
| Thread | Author | Time |
|---|---|---|
| Re: mail alert | Rob Sargent | 01:38 |
| Re: Month/year between two dates | ramasubramanian | 03:59 |
| Re: mail alert | ramasubramanian | 04:01 |
| Re: mail alert | Shoaib Mir | 06:15 |
| Re: mail alert | Jan Verheyden | 07:29 |
| Re: Updating a specific number of rows in pl/pgsql | Xharon | 07:34 |
| Re: mail alert | Jan Verheyden | 13:27 |
| Re: mail alert | Rob Sargent | 14:01 |
| Re: mail alert | Jan Verheyden | 14:44 |
| mysql code questions | Ray Stell | 18:19 |
| Re: mysql code questions | Thomas Kellerer | 18:52 |
| Re: mysql code questions | Greg Stark | 19:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Month/year between two dates | Jorge Godoy | 00:58 |
| simple? query | Jan Verheyden | 11:36 |
| Re: mail alert | Jasen Betts | 12:08 |
| Re: mail alert | Jasen Betts | 12:16 |
| Re: simple? query | Relyea, Mike | 20:46 |
| Re: mail alert | Alvaro Herrera | 21:54 |
| Re: mail alert | Tim Landscheidt | 22:24 |
| Re: mail alert | Alvaro Herrera | 22:36 |
| Re: mail alert | Adrian Klaver | 23:30 |
| Thread | Author | Time |
|---|---|---|
| Re: simple? query | Jasen Betts | 08:58 |
| Field or record level encryption / decryption | Hengky Lie | 09:20 |
| Re: simple? query | Relyea, Mike | 12:58 |
| Re: Field or record level encryption / decryption | Joshua Tolley | 13:24 |
| Re: simple? query | Relyea, Mike | 14:21 |
| Re: simple? query | Tim Landscheidt | 14:53 |
| Re: mail alert | Christopher Browne | 15:18 |
| Re: Field or record level encryption / decryption | Christopher Browne | 15:21 |
| Re: Field or record level encryption / decryption | Hengky Lie | 16:07 |
| Re: Field or record level encryption / decryption | Joshua Tolley | 22:28 |
| Thread | Author | Time |
|---|---|---|
| Multiple simultaneous queries on single connection | Yeb Havinga | 12:49 |
| Thread | Author | Time |
|---|---|---|
| FW: simple? query | Jan Verheyden | 07:04 |
| operator contains in older Pgsql | W. Kinastowski | 07:47 |
| Re: operator contains in older Pgsql | Jasen Betts | 09:44 |
| Re: operator contains in older Pgsql | W. Kinastowski | 10:16 |
| Re: operator contains in older Pgsql | Jasen Betts | 11:18 |
| SQL Query Performance - what gives? 📎 | Karl Denninger | 19:45 |
| Re: SQL Query Performance - what gives? | Kevin Grittner | 20:23 |
| Re: SQL Query Performance - what gives? 📎 | Karl Denninger | 20:58 |
| Updating one table with data from another | drew | 21:02 |
| Re: SQL Query Performance - what gives? | Kevin Grittner | 21:59 |
| Re: SQL Query Performance - what gives? 📎 | Karl Denninger | 23:03 |
| Re: FW: simple? query | Tim Landscheidt | 23:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Multiple simultaneous queries on single connection | Craig Ringer | 01:35 |
| Re: [SQL] SQL Query Performance - what gives? | Tom Lane | 02:02 |
| Re: [SQL] SQL Query Performance - what gives? 📎 | Karl Denninger | 02:47 |
| Re: [SQL] SQL Query Performance - what gives? | Pierre Frédéric Caillaud | 06:27 |
| Ask To Optimize Looping | Otniel Michael | 09:22 |
| Ask About SQL | Otniel Michael | 10:17 |
| Re: SQL Query Performance - what gives? | Ivan Voras | 10:19 |
| Re: Ask About SQL | A. Kretschmer | 10:46 |
| Re: Ask About SQL | Joshua Tolley | 14:00 |
| Re: Multiple simultaneous queries on single connection | Yeb Havinga | 15:15 |
| Re: Ask To Optimize Looping | Marc Mamin | 15:46 |
| Call Procedure From Trigger Function | Doug Pisarek | 21:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Call Procedure From Trigger Function | Scott Marlowe | 04:01 |
| Re: Call Procedure From Trigger Function | ramasubramanian | 04:29 |
| Re: Updating one table with data from another | Jasen Betts | 10:51 |
| Advice returning data as an array | George Woodring | 12:07 |
| using case to select 'which version to use' | Gerardo Herzig | 15:17 |
| Re: using case to select 'which version to use' | Rodrigo E. De León Plicet | 16:33 |
| Rewrite without correlated subqueries | bricklen | 20:32 |
| Re: Rewrite without correlated subqueries 📎 | Mark Fenbers | 20:40 |
| Re: Rewrite without correlated subqueries | bricklen | 21:16 |
| Re: Rewrite without correlated subqueries | Scott Marlowe | 21:59 |
| Re: Rewrite without correlated subqueries | bricklen | 22:03 |
| Thread | Author | Time |
|---|---|---|
| Rewrite multiple joins... | tripplowe | 03:17 |
| Re: Rewrite multiple joins... | Rob Sargent | 15:15 |
| Re: using case to select 'which version to use' | Gerardo Herzig | 18:13 |
| multiple substitution in a single replace call? | Gerardo Herzig | 20:16 |
| Thread | Author | Time |
|---|---|---|
| Re: multiple substitution in a single replace call? | Jasen Betts | 11:45 |
| Thread | Author | Time |
|---|---|---|
| Question about encoding | Denis BUCHER | 16:42 |
| Re: Question about encoding | Peter Eisentraut | 22:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Question about encoding | Denis BUCHER | 20:16 |
| Thread | Author | Time |
|---|---|---|
| Selecting values from comma separated string | Nacef LABIDI | 13:19 |
| Re: Selecting values from comma separated string | A. Kretschmer | 13:30 |
| Re: Selecting values from comma separated string | Pavel Stehule | 13:32 |
| Re: Selecting values from comma separated string | Pavel Stehule | 13:33 |
| Re: Selecting values from comma separated string | Tom Lane | 14:05 |
| Re: Selecting values from comma separated string | Nacef LABIDI | 14:13 |
| Re: Selecting values from comma separated string | Pavel Stehule | 14:58 |
| Re: Advice returning data as an array | Erik Jones | 18:20 |
| Thread | Author | Time |
|---|---|---|
| Howto automatically define collumn names for a function result. | Andreas | 11:08 |
| Re: Howto automatically define collumn names for a function result. | Jorge Godoy | 11:25 |
| WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable | rawi | 11:59 |
| resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable | rawi | 14:16 |
| Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable | Tom Lane | 15:18 |
| Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable | Rob Sargent | 15:27 |
| Data audit trail techniques in postgresql | Nathaniel Smith | 16:28 |
| Re: Data audit trail techniques in postgresql | Alvaro Herrera | 17:36 |
| Re: [SQL] Data audit trail techniques in postgresql | Rob Sargent | 18:31 |
| Re: [SQL] Data audit trail techniques in postgresql | Alvaro Herrera | 19:32 |
| Re: [SQL] Data audit trail techniques in postgresql | Rob Sargent | 20:30 |
| Thread | Author | Time |
|---|---|---|
| hopeless, SQL not resolved yet | rawi | 13:52 |
| Re: Data audit trail techniques in postgresql | Nathaniel Smith | 14:39 |
| recursively isolate pedigrees, based only on person_id, mother_id and father_id | rawi | 15:10 |
| Re: recursively isolate pedigrees, based only on person_id, mother_id and father_id | Rob Sargent | 16:19 |
| Thread | Author | Time |
|---|---|---|
| NEED HELP COPY TO DYNAMIC OUTPUT FILE | Yogi Rizkiadi | 22:02 |
| Thread | Author | Time |
|---|---|---|
| Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE | Pavel Stehule | 06:51 |
| Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE | Tom Lane | 15:53 |
| Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE | Pavel Stehule | 15:56 |
| Searching for byte values within a bytea field | db1981 | 19:15 |
| Thread | Author | Time |
|---|---|---|
| Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE | Yogi Dwianandono Rizkiadi | 05:47 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL Function: how to know the number of the returned results of the Query | bilal ghayyad | 00:53 |
| Re: PostgreSQL Function: how to know the number of the returned results of the Query | Harun Bolat | 05:31 |
| Re: PostgreSQL Function: how to know the number of the returned results of the Query | Pavel Stehule | 05:35 |
| Plpgsql: Assign regular expression match to variable | Leif B. Kristensen | 12:01 |
| Re: Plpgsql: Assign regular expression match to variable | Ian Barwick | 12:36 |
| Re: Plpgsql: Assign regular expression match to variable | Leif B. Kristensen | 12:56 |
| Odd sort behaviour | Rob Sargent | 21:01 |
| Re: Odd sort behaviour | Scott Marlowe | 21:38 |
| Re: Odd sort behaviour | Rob Sargent | 22:31 |
| Re: Odd sort behaviour | Greg Stark | 23:04 |
| Re: Odd sort behaviour | Rob Sargent | 23:22 |
| Thread | Author | Time |
|---|---|---|
| How to create Function which retruns username and password | venkat | 08:05 |
| Re: How to create Function which retruns username and password | A. Kretschmer | 08:33 |
| Min and max element of an array column | Gianvito Pio | 10:58 |
| Re: Min and max element of an array column | A. Kretschmer | 11:26 |
| Question | aymen marouani | 14:17 |
| Question | aymen marouani | 14:28 |
| Re: Question | Rob Sargent | 15:19 |
| Re: Question | Ross J. Reedstrom | 15:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Odd sort behaviour | Lew | 00:50 |
| Re: Question | A. Kretschmer | 06:32 |
| Thread | Author | Time |
|---|---|---|
| LIMIT 1; The Integer part only | bilal ghayyad | 00:49 |
| Re: LIMIT 1; The Integer part only | Steve Crawford | 01:02 |
| Re: LIMIT 1; The Integer part only | Christophe Pettus | 01:28 |
| Adding ENUM Type | Simon Bateman | 05:36 |
| Thread | Author | Time |
|---|---|---|
| Substring | bilal ghayyad | 00:45 |
| Re: Substring | Raj Mathur | 02:32 |
| How to simulate (run) the function | bilal ghayyad | 02:43 |
| Re: How to simulate (run) the function | Scott Marlowe | 02:51 |
| Re: Substring | Frank Bax | 04:10 |
| Re: Substring | Raj Mathur | 04:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Substring | Fernando Hevia | 18:36 |
| Postgresql PostGIS installation on Widows Server 2003 | venkat | 19:53 |