Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| multi table import from 1 denormalized source table | Andreas | 05:57 |
| Re: multi table import from 1 denormalized source table | Jasen Betts | 08:21 |
| Sum up network events by type, interval and network | Axel Rau | 16:29 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL array, recursion and more 📎 | Ferruccio Zamuner | 13:22 |
| Re: PostgreSQL array, recursion and more | Achilleas Mantzios | 14:53 |
| obtaining difference between minimum value and next in size | John Lister | 15:11 |
| Re: obtaining difference between minimum value and next in size | Tom Lane | 15:42 |
| Re: obtaining difference between minimum value and next in size | Andreas Kretschmer | 16:02 |
| Re: obtaining difference between minimum value and next in size | Oliveiros d'Azevedo Cristina | 16:09 |
| Re: obtaining difference between minimum value and next in size | John Lister | 22:46 |
| Thread | Author | Time |
|---|---|---|
| Re: obtaining difference between minimum value and next in size | Oliveiros d'Azevedo Cristina | 10:09 |
| Thread | Author | Time |
|---|---|---|
| force view column varchar(32) to varchar(128) | Emi Lu | 15:02 |
| Re: force view column varchar(32) to varchar(128) | Andreas Kretschmer | 16:54 |
| Re: force view column varchar(32) to varchar(128) | Richard Broersma | 17:34 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL array, recursion and more | Dmitriy Igrishin | 11:50 |
| Thread | Author | Time |
|---|---|---|
| Howto "insert or update" ? | Andreas | 03:44 |
| Re: Howto "insert or update" ? | tv | 04:11 |
| "compressing" consecutive values into one | Louis-David Mitterrand | 15:19 |
| Re: "compressing" consecutive values into one | Oliveiros d'Azevedo Cristina | 15:31 |
| Re: "compressing" consecutive values into one | Louis-David Mitterrand | 18:13 |
| Re: "compressing" consecutive values into one | bricklen | 18:19 |
| Thread | Author | Time |
|---|---|---|
| atomic multi-threaded upsert | Mikhail V. Puzanov | 20:16 |
| Re: "compressing" consecutive values into one | Louis-David Mitterrand | 20:53 |
| Re: atomic multi-threaded upsert | Tom Lane | 21:21 |
| Thread | Author | Time |
|---|---|---|
| insert from a select | John Fabiani | 00:07 |
| Re: insert from a select | Adrian Klaver | 00:25 |
| Re: atomic multi-threaded upsert | KM | 02:12 |
| How strings are sorted by LC_COLLATE specifically? | Chang Chao | 05:42 |
| Re: atomic multi-threaded upsert | MIkhail Puzanov | 06:51 |
| Re: atomic multi-threaded upsert | MIkhail Puzanov | 07:24 |
| Re: insert from a select | Carla | 11:40 |
| Re: insert from a select | Carla | 12:32 |
| Re: insert from a select | John Fabiani | 13:33 |
| Re: insert from a select | Trinath Somanchi | 15:22 |
| error null value in column" concat_id" violates not-null constraint | Ana Louro | 15:58 |
| Thread | Author | Time |
|---|---|---|
| Re: error null value in column" concat_id" violates not-null constraint | Pavel Stehule | 07:45 |
| group by hour + distinct | Michele Petrazzo - Unipex | 11:39 |
| Re: group by hour + distinct | Oliveiros d'Azevedo Cristina | 12:19 |
| Re: group by hour + distinct | Michele Petrazzo - Unipex | 12:42 |
| Re: group by hour + distinct | Oliveiros d'Azevedo Cristina | 13:15 |
| Re: group by hour + distinct | Lew | 16:07 |
| Insert row in 1.10.1 and 1.10.3 | ndias | 16:22 |
| Re: Insert row in 1.10.1 and 1.10.3 | Oliveiros d'Azevedo Cristina | 16:52 |
| Re: Insert row in 1.10.1 and 1.10.3 | ndias | 17:09 |
| Re: Insert row in 1.10.1 and 1.10.3 | Thomas Kellerer | 17:14 |
| Re: Insert row in 1.10.1 and 1.10.3 | Guillaume Lelarge | 17:25 |
| Re: Insert row in 1.10.1 and 1.10.3 | ndias | 17:28 |
| Thread | Author | Time |
|---|---|---|
| Re: atomic multi-threaded upsert | Mikhail V. Puzanov | 15:08 |
| Thread | Author | Time |
|---|---|---|
| Is there a solution for "SELECT OR INSERT" | Stefan Becker | 23:30 |
| Thread | Author | Time |
|---|---|---|
| subselect and left join not working? | Jorge Arenas | 05:38 |
| Re: subselect and left join not working? | Jasen Betts | 09:44 |
| Re: subselect and left join not working? | Tom Lane | 15:27 |
| Thread | Author | Time |
|---|---|---|
| Re: subselect and left join not working? | Jorge Arenas | 04:29 |
| Deleting entries from multiple tables | manidegr8 | 05:59 |
| Re: Deleting entries from multiple tables | Dusan Misic | 08:15 |
| Re: Deleting entries from multiple tables | Dusan Misic | 08:19 |
| Re: Deleting entries from multiple tables | Achilleas Mantzios | 08:36 |
| Re: Deleting entries from multiple tables | manidegr8 | 10:00 |
| Re: subselect and left join not working? | Carla | 13:22 |
| Re: Is there a solution for "SELECT OR INSERT" | Florian Weimer | 14:16 |
| indexing longish string | Rob Sargent | 17:42 |
| Re: indexing longish string | jose | 17:50 |
| Re: indexing longish string | Rob Sargent | 17:57 |
| Re: indexing longish string | Kenneth Marshall | 18:36 |
| Re: indexing longish string | Isaac Dover | 19:21 |
| Re: How strings are sorted by LC_COLLATE specifically? | Peter Eisentraut | 19:31 |
| Re: indexing longish string | Isaac Dover | 20:03 |
| DELETE WHERE EXISTS unexpected results | Jeff Bland | 22:16 |
| Thread | Author | Time |
|---|---|---|
| aggregation question | Samuel Gendler | 03:47 |
| OT - load a shp file | John Fabiani | 06:06 |
| Re: aggregation question | Samuel Gendler | 09:06 |
| Re: OT - load a shp file | Lee Hachadoorian | 09:13 |
| Re: DELETE WHERE EXISTS unexpected results | Carla | 13:05 |
| Re: OT - load a shp file | John Fabiani | 14:29 |
| Re: How strings are sorted by LC_COLLATE specifically? | Chang Chao | 14:31 |
| Re: DELETE WHERE EXISTS unexpected results | Jeff Bland | 15:07 |
| Thread | Author | Time |
|---|---|---|
| Re: DELETE WHERE EXISTS unexpected results | Jasen Betts | 07:47 |
| COPY with FORMAT in Postgresql 9.x | Humair Mohammed | 21:45 |
| Calculate next event date based on instance of the day of week | Dimitri | 21:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Calculate next event date based on instance of the day of week | Jayadevan M | 06:17 |
| Get the max viewd product_id for user_id | Mario Splivalo | 10:53 |
| Re: Get the max viewd product_id for user_id | Jayadevan M | 11:40 |
| Re: COPY with FORMAT in Postgresql 9.x | Tom Lane | 15:51 |
| Union Question | Shaun McCloud | 16:51 |
| Re: Union Question | Plugge, Joe R. | 16:58 |
| Re: Union Question | Shaun McCloud | 17:04 |
| Re: Union Question | Christophe Pettus | 17:08 |
| Re: Union Question | Shaun McCloud | 17:08 |
| Re: Union Question | Christophe Pettus | 17:27 |
| Re: Union Question | Shaun McCloud | 17:30 |
| A note on how to generate a list of months within some period of time. | Michał Roszka | 21:00 |
| Re: Union Question | Jasen Betts | 23:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Get the max viewd product_id for user_id | Mario Splivalo | 16:48 |
| Re: Get the max viewd product_id for user_id | Mario Splivalo | 16:57 |
| Re: Get the max viewd product_id for user_id | Mario Splivalo | 16:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Get the max viewd product_id for user_id | Jayadevan M | 02:55 |
| First aggregate with null support | Marc Mamin | 10:59 |
| The best option to insert data with primary id | - | 14:59 |
| Re: The best option to insert data with primary id | mike | 15:27 |
| Re: The best option to insert data with primary id | mike | 16:21 |
| Re: Union Question | bricklen | 19:39 |
| Thread | Author | Time |
|---|---|---|
| concatenate question | Tony Capobianco | 21:07 |
| concatenate question | Tony Capobianco | 21:37 |
| Re: concatenate question | Peter Steinheuser | 21:43 |
| Re: concatenate question | Tony Capobianco | 21:47 |
| Re: concatenate question | Dmitriy Igrishin | 21:51 |
| Re: concatenate question | Kenneth Marshall | 21:52 |
| Re: concatenate question | Richard Broersma | 21:53 |
| Re: concatenate question | Peter Steinheuser | 21:54 |
| Thread | Author | Time |
|---|---|---|
| mybatis 3 RETURNING id problem with insert. | - | 07:27 |
| conditional aggregates | Marcin Krawczyk | 12:49 |
| Re: conditional aggregates | Pavel Stehule | 13:07 |
| Re: conditional aggregates | Marcin Krawczyk | 13:19 |
| Regular Expression Match Operator escape character | Gnanakumar | 13:51 |
| Re: conditional aggregates | Marc Mamin | 14:06 |
| Re: concatenate question | Tony Capobianco | 14:08 |
| Re: conditional aggregates | Marcin Krawczyk | 14:35 |
| Thread | Author | Time |
|---|---|---|
| Re: concatenate question | Edgardo Portal | 16:16 |
| Extended query protocol and exact types matches. | Dmitriy Igrishin | 18:24 |
| Correct usage of FOR UPDATE? | Joe Carr | 19:29 |
| sqlplus reporting equivalent in postgres? | Tony Capobianco | 21:47 |
| Fwd: Extended query protocol and exact types matches. | Dmitriy Igrishin | 22:10 |
| Thread | Author | Time |
|---|---|---|
| Fwd: Extended query protocol and exact types matches. | Dmitriy Igrishin | 07:53 |
| Re: Fwd: Extended query protocol and exact types matches. | Robert Haas | 16:16 |
| Re: Fwd: Extended query protocol and exact types matches. | Dmitriy Igrishin | 16:46 |
| Re: Extended query protocol and exact types matches. | Merlin Moncure | 17:22 |
| Re: Extended query protocol and exact types matches. | Dmitriy Igrishin | 17:40 |
| Re: Fwd: Extended query protocol and exact types matches. | Robert Haas | 17:51 |
| Re: Fwd: Extended query protocol and exact types matches. | Dmitriy Igrishin | 17:58 |
| Re: Extended query protocol and exact types matches. | Merlin Moncure | 18:05 |
| Re: Extended query protocol and exact types matches. | Dmitriy Igrishin | 18:26 |
| Thread | Author | Time |
|---|---|---|
| Re: sqlplus reporting equivalent in postgres? | Igor Neyman | 01:44 |
| Re: sqlplus reporting equivalent in postgres? | Samuel Gendler | 03:23 |
| Re: sqlplus reporting equivalent in postgres? | Gary Chambers | 03:28 |
| Re: sqlplus reporting equivalent in postgres? | Samuel Gendler | 03:44 |
| Re: The best option to insert data with primary id | Jasen Betts | 10:17 |
| Re: Correct usage of FOR UPDATE? | Dmitriy Igrishin | 10:32 |
| Re: sqlplus reporting equivalent in postgres? | Thomas Kellerer | 10:50 |
| Re: concatenate question | Andreas Kretschmer | 13:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Regular Expression Match Operator escape character | Jasen Betts | 09:18 |
| constraint with check | Viktor Bojović | 23:36 |
| Thread | Author | Time |
|---|---|---|
| Aggregating by unique values | Lee Hachadoorian | 05:11 |
| Re: constraint with check | Jasen Betts | 07:12 |
| Re: Using count on a join, group by required? | emaratiyya | 07:19 |
| Re: Aggregating by unique values | Filip Rembiałkowski | 08:23 |
| Re: Using count on a join, group by required? | Trinath Somanchi | 08:53 |
| Re: Using count on a join, group by required? | Rob Sargent | 16:23 |
| Re: Aggregating by unique values 📎 | Lee Hachadoorian | 17:24 |
| Re: Using count on a join, group by required? | Rob Sargent | 18:14 |
| Thread | Author | Time |
|---|---|---|
| How to convert string to integer | venkat | 10:23 |
| Re: How to convert string to integer | Szymon Guz | 10:27 |
| Re: [SQL] How to convert string to integer | Pavel Stehule | 10:27 |
| Re: [SQL] How to convert string to integer | Viktor Bojović | 10:37 |
| Database consistency after a power shortage | Alberto | 15:12 |
| Thread | Author | Time |
|---|---|---|
| Translate Function PL/pgSQL to SQL92 | serviciotdf | 01:22 |
| Re: Database consistency after a power shortage | Scott Marlowe | 07:38 |
| Re: Database consistency after a power shortage | Samuel Gendler | 07:58 |
| Re: Translate Function PL/pgSQL to SQL92 | Filip Rembiałkowski | 11:17 |
| Re: Database consistency after a power shortage | Jean-David Beyer | 14:38 |
| UPDATE in a specific order | Luiz K. Matsumura | 14:57 |
| Re: UPDATE in a specific order | Jasen Betts | 19:58 |
| Create/update trigger auto-populate fields. | Chris Ruprecht | 20:42 |
| Thread | Author | Time |
|---|---|---|
| Full Text search differences from 8.3 to 8.4.6 | Achilleas Mantzios | 10:19 |
| Re: Translate Function PL/pgSQL to SQL92 | serviciotdf | 15:26 |
| Help with Function in plpgsql | acurtis416 | 16:58 |
| Re: UPDATE in a specific order | Luiz K. Matsumura | 19:01 |
| Thread | Author | Time |
|---|---|---|
| Table name as a variable in SELECT query | Andrey Fokin | 12:46 |
| Re: Table name as a variable in SELECT query | Andreas Kretschmer | 14:01 |
| Thread | Author | Time |
|---|---|---|
| linux. ossp-uuid | Николай Ижиков | 08:31 |
| Re: linux. ossp-uuid | Trinath Somanchi | 11:06 |
| converting type and function in postgresql ? | Amar Dhole | 11:33 |
| data import | Viktor Bojović | 11:34 |
| Re: data import | Pavel Stehule | 11:36 |
| Re: converting type and function in postgresql ? | Trinath Somanchi | 11:58 |
| Re: data import | Achilleas Mantzios | 12:04 |
| Re: data import | Chris Ruprecht | 16:18 |
| Thread | Author | Time |
|---|---|---|
| Re: linux. ossp-uuid | Basil Bourque | 02:00 |
| Thread | Author | Time |
|---|---|---|
| Issue while using PostgreSql 8.4. | Atul Kumar | 08:31 |
| Re: Issue while using PostgreSql 8.4. | Kevin Grittner | 15:23 |
| Thread | Author | Time |
|---|---|---|
| Re: data import | Viktor Bojović | 01:45 |
| Thread | Author | Time |
|---|---|---|
| create function problem | Gary Stainburn | 16:26 |
| Re: create function problem | Pavel Stehule | 17:35 |
| Re: create function problem | Adrian Klaver | 17:47 |
| Re: create function problem | Gary Stainburn | 20:16 |
| create role | Tony Capobianco | 22:14 |
| Re: create role | Adrian Klaver | 22:23 |
| Thread | Author | Time |
|---|---|---|
| Re: create role | tcapobianco | 16:22 |
| Re: create role | Adrian Klaver | 16:34 |
| Re: create role | Adrian Klaver | 17:05 |
| Thread | Author | Time |
|---|---|---|
| "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? | Bryce Nesbitt | 22:29 |
| Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? | Michael Glaesemann | 22:32 |
| Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? | Bryce Nesbitt | 22:47 |
| Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? | bricklen | 23:03 |
| Thread | Author | Time |
|---|---|---|
| foreign key question | Gary Stainburn | 09:53 |
| Re: foreign key question | Gary Stainburn | 10:40 |
| return records with more than one occurrences | Tarsis Lima | 14:18 |
| pattern matching with dates? | Good, Thomas | 19:39 |
| Re: foreign key question | Jasen Betts | 19:54 |
| Thread | Author | Time |
|---|---|---|
| explicit casts | Iuri Sampaio | 00:24 |
| Re: explicit casts | Iuri Sampaio | 01:22 |