Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: counting related rows | James Cloos | 09:57 |
| Thread | Author | Time |
|---|---|---|
| How to collect text-fields from multiple rows ? | Andreas | 03:23 |
| Re: How to collect text-fields from multiple rows ? | Thomas Kellerer | 07:23 |
| SIMILAR TO | Rommel the iCeMAn | 14:26 |
| Re: SIMILAR TO | Tom Lane | 14:30 |
| Re: SIMILAR TO | Rommel the iCeMAn | 16:23 |
| Thread | Author | Time |
|---|---|---|
| insert into table from list or array ? | Andreas | 18:00 |
| Re: insert into table from list or array ? | Viktor Bojović | 18:12 |
| Re: insert into table from list or array ? | Pavel Stehule | 18:14 |
| Re: insert into table from list or array ? | Andreas | 23:05 |
| Thread | Author | Time |
|---|---|---|
| Need help on update. | Nicholas I | 07:43 |
| Re: Need help on update. | Richard Huxton | 08:10 |
| Re: Need help on update. | Nicholas I | 08:19 |
| Thread | Author | Time |
|---|---|---|
| insert record in remote database | Maruti Nandan | 11:41 |
| Thread | Author | Time |
|---|---|---|
| Re: insert record in remote database | Osvaldo Kussama | 22:07 |
| Thread | Author | Time |
|---|---|---|
| Re: insert record in remote database | Osvaldo Kussama | 12:52 |
| Thread | Author | Time |
|---|---|---|
| How to search for a part of a number | Andreas | 00:48 |
| Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause | Axel Rau | 10:14 |
| Re: How to search for a part of a number | Harald Fuchs | 13:13 |
| Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause [re-post] | Axel Rau | 16:07 |
| Re: Using PL/pgSQL text argument in 'IN (INT, INT, ...)' clause [re-post] | Richard Broersma | 16:17 |
| Re: Using PL/pgSQL text argument in 'IN (INT, INT, ...)' clause [re-post] | Sergey Konoplev | 16:17 |
| Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause [re-post] | Axel Rau | 19:01 |
| Thread | Author | Time |
|---|---|---|
| How to update multiple rows | venkat | 07:07 |
| Re: How to update multiple rows | Alban Hertroys | 08:02 |
| Re: How to update multiple rows | venkat | 09:14 |
| Re: How to update multiple rows | Dann Corbit | 09:27 |
| Thread | Author | Time |
|---|---|---|
| Different plan for one query problem | Tatarnikov Alexander | 01:50 |
| Thread | Author | Time |
|---|---|---|
| How to Convert Integer to Serial | venkat | 04:48 |
| Re: How to Convert Integer to Serial | venkat | 04:58 |
| Re: [SQL] How to Convert Integer to Serial | Shoaib Mir | 05:00 |
| Re: [SQL] How to Convert Integer to Serial | Shoaib Mir | 05:01 |
| Re: [SQL] How to Convert Integer to Serial | venkat | 05:02 |
| Re: How to Convert Integer to Serial | John R Pierce | 05:09 |
| Re: [SQL] How to Convert Integer to Serial | Shoaib Mir | 05:10 |
| Re: [SQL] How to Convert Integer to Serial | venkat | 05:29 |
| Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause | Dmitriy Igrishin | 17:07 |
| Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause | Dmitriy Igrishin | 17:11 |
| Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable | Will Furnass | 19:31 |
| Thread | Author | Time |
|---|---|---|
| large xml database | Viktor Bojović | 21:49 |
| Re: large xml database | Andreas Joseph Krogh | 22:06 |
| Re: large xml database | Rob Sargent | 22:42 |
| Thread | Author | Time |
|---|---|---|
| Re: large xml database | James Cloos | 00:26 |
| Re: large xml database | Lutz Steinborn | 06:08 |
| A more efficient way? | James Cloos | 06:59 |
| Re: A more efficient way? | Tom Lane | 14:10 |
| Re: large xml database | Viktor Bojović | 19:36 |
| Re: large xml database | Viktor Bojović | 19:53 |
| Re: large xml database | Rob Sargent | 20:42 |
| Re: large xml database 📎 | Viktor Bojović | 21:16 |
| Re: large xml database | Rob Sargent | 21:26 |
| Re: large xml database 📎 | Viktor Bojović | 22:52 |
| Re: large xml database | Rob Sargent | 23:07 |
| Thread | Author | Time |
|---|---|---|
| Sorting router interfaces | Brian Sherwood | 12:15 |
| Re: Sorting router interfaces | Filip Rembiałkowski | 21:37 |
| Thread | Author | Time |
|---|---|---|
| Re: Sorting router interfaces | Andreas | 00:23 |
| problem with rules | Uwe Bartels | 07:54 |
| Thread | Author | Time |
|---|---|---|
| I'm stuck - I just can't get this small FUNCT to run! | Ralph Smith | 00:00 |
| Re: I'm stuck - I just can't get this small FUNCT to run! | bricklen | 00:09 |
| Re: I'm stuck - I just can't get this small FUNCT to run! | Tom Lane | 03:50 |
| Trailing spaces - is there an easier way? | Dean Gibson (DB Administrator) | 19:03 |
| Re: Trailing spaces - is there an easier way? | Pavel Stehule | 19:42 |
| Re: Trailing spaces - is there an easier way? | Kenneth Marshall | 19:47 |
| Re: I'm stuck - I just can't get this small FUNCT to run! | Ralph Smith | 20:07 |
| Thread | Author | Time |
|---|---|---|
| Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable | Will Furnass | 10:18 |
| Thread | Author | Time |
|---|---|---|
| unexpected ORDER BY | Andreas | 16:00 |
| Re: unexpected ORDER BY | Tom Lane | 16:10 |
| Thread | Author | Time |
|---|---|---|
| "slow lock" log in addition to log_min_duration_statement ? | Bryce Nesbitt | 20:28 |
| Thread | Author | Time |
|---|---|---|
| Overlapping Ranges- Query Alternative | Ozer, Pam | 19:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Overlapping Ranges- Query Alternative | Andreas Gaab | 08:23 |
| Re: Overlapping Ranges- Query Alternative | Marc Mamin | 08:57 |
| Re: "slow lock" log in addition to log_min_duration_statement ? | Joshua Tolley | 15:50 |
| Re: Overlapping Ranges- Query Alternative | Ozer, Pam | 16:36 |
| psql -f COPY from STDIN | Tarlika Elisabeth Schmitz | 22:03 |
| Re: psql -f COPY from STDIN | Adrian Klaver | 23:17 |
| Thread | Author | Time |
|---|---|---|
| Re: psql -f COPY from STDIN | Tom Lane | 03:22 |
| Re: psql -f COPY from STDIN | Tarlika Elisabeth Schmitz | 12:01 |
| Re: psql -f COPY from STDIN | Tom Lane | 14:54 |
| Re: psql -f COPY from STDIN | Tarlika Elisabeth Schmitz | 15:04 |
| Need help with plpgsql function. | berelith | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Need help with plpgsql function. | Pavel Stehule | 07:15 |
| Re: Need help with plpgsql function. | Adrian Klaver | 18:37 |
| Re: Need help with plpgsql function. | Pavel Stehule | 18:41 |
| 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 |