Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: SQL Developer accessing PostgreSQL 📎 | Jose Alarcon | 07:01 |
| Re: SQL Developer accessing PostgreSQL | Thomas Kellerer | 08:12 |
| Re: Week to date function | Jasen Betts | 11:44 |
| Re: Capacity planning. | Bruce Momjian | 14:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Capacity planning. | Brad Nicholson | 13:12 |
| Thread | Author | Time |
|---|---|---|
| count function alternative in postgres | junaidmalik14 | 12:58 |
| Thread | Author | Time |
|---|---|---|
| INSERT INTO...RETURNING vs SELECT | Cliff Wells | 22:12 |
| Thread | Author | Time |
|---|---|---|
| INSERT INTO...RETURNING vs SELECT | Cliff Wells | 04:48 |
| Re: INSERT INTO...RETURNING vs SELECT | Andreas Kretschmer | 07:10 |
| Re: INSERT INTO...RETURNING vs SELECT | Cliff Wells | 15:40 |
| Thread | Author | Time |
|---|---|---|
| Table Design for Hierarchical Data | Lee Hachadoorian | 17:33 |
| Re: count function alternative in postgres | Thomas Kellerer | 17:39 |
| Re: count function alternative in postgres | Ben Morrow | 18:47 |
| Re: Table Design for Hierarchical Data | Michael Glaesemann | 22:04 |
| Re: Table Design for Hierarchical Data | Richard Broersma | 22:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Table Design for Hierarchical Data | Steve Crawford | 00:23 |
| Re: Table Design for Hierarchical Data | silly sad | 05:41 |
| Re: Table Design for Hierarchical Data | silly sad | 05:43 |
| Re: Table Design for Hierarchical Data | Scott Marlowe | 06:17 |
| Re: Table Design for Hierarchical Data | Achilleas Mantzios | 07:00 |
| Re: Table Design for Hierarchical Data | silly sad | 07:53 |
| Re: Table Design for Hierarchical Data | Yeb Havinga | 08:06 |
| Re: Table Design for Hierarchical Data | Sergey Konoplev | 08:26 |
| Re: Table Design for Hierarchical Data | Achilleas Mantzios | 08:28 |
| Re: Table Design for Hierarchical Data | Achilleas Mantzios | 08:34 |
| Re: Table Design for Hierarchical Data | Achilleas Mantzios | 08:39 |
| Re: Table Design for Hierarchical Data | Lee Hachadoorian | 18:27 |
| Re: Table Design for Hierarchical Data | Yeb Havinga | 20:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Table Design for Hierarchical Data | Achilleas Mantzios | 06:56 |
| Re: Table Design for Hierarchical Data | Yeb Havinga | 07:40 |
| Problem with function returning a result set | Thomas Kellerer | 08:54 |
| Re: Problem with function returning a result set | Tom Lane | 08:59 |
| Re: Problem with function returning a result set | Pavel Stehule | 09:01 |
| Re: Problem with function returning a result set | Thomas Kellerer | 09:29 |
| Re: Table Design for Hierarchical Data | Rob Sargent | 14:59 |
| Howto get a group_number like row_number for groups | Andreas | 19:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Howto get a group_number like row_number for groups | Jaime Casanova | 03:41 |
| Cascading sum in tree with CTE? | Svenne Krap | 07:17 |
| Re: Cascading sum in tree with CTE? | silly sad | 09:12 |
| Re: Cascading sum in tree with CTE? | Harald Fuchs | 10:51 |
| understanding select into | John | 17:18 |
| Re: understanding select into | Plugge, Joe R. | 17:31 |
| Re: understanding select into | Pavel Stehule | 17:32 |
| Re: understanding select into | John | 17:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Table Design for Hierarchical Data | Achilleas Mantzios | 08:14 |
| Re: Howto get a group_number like row_number for groups | msi77 | 14:19 |
| Re: Table Design for Hierarchical Data | Rob Sargent | 14:57 |
| Re: Table Design for Hierarchical Data | Leif Biberg Kristensen | 15:30 |
| Re: Table Design for Hierarchical Data | Yeb Havinga | 15:37 |
| Re: Table Design for Hierarchical Data | Leif Biberg Kristensen | 15:56 |
| Thread | Author | Time |
|---|---|---|
| Getting the initdb parameter values | Satish Burnwal (sburnwal) | 11:50 |
| Re: [ADMIN] Getting the initdb parameter values | Iñigo Martinez Lasala | 12:56 |
| Re: [ADMIN] Getting the initdb parameter values | Satish Burnwal (sburnwal) | 13:01 |
| Re: Getting the initdb parameter values | Kevin Grittner | 13:54 |
| Re: Getting the initdb parameter values | Greg Smith | 17:13 |
| Re: [ADMIN] Getting the initdb parameter values | Rob Sargent | 17:57 |
| Re: Getting the initdb parameter values | Julio Leyva | 18:01 |
| Thread | Author | Time |
|---|---|---|
| How to max() make null as biggest value? | Feixiong Li | 04:33 |
| Problem with insert related to different schemas | Gonzalo Aguilar Delgado | 08:23 |
| Using CASE in plpgsql causes 'ERROR: cache lookup failed' | Mario Splivalo | 09:48 |
| graphing time series data | Louis-David Mitterrand | 14:54 |
| Re: graphing time series data | Richard Broersma | 15:46 |
| Re: graphing time series data | Louis-David Mitterrand | 15:49 |
| Re: graphing time series data | Pavel Stehule | 16:06 |
| Re: graphing time series data | Louis-David Mitterrand | 16:11 |
| Re: graphing time series data | Pavel Stehule | 16:14 |
| Re: Using CASE in plpgsql causes 'ERROR: cache lookup failed' | Tom Lane | 23:11 |
| Thread | Author | Time |
|---|---|---|
| CHECK constraints with plpgsql functions - check 'fires' BEFORE data modification? | Mario Splivalo | 09:49 |
| Re: CHECK constraints with plpgsql functions - check 'fires' BEFORE data modification? | Jasen Betts | 10:49 |
| Re: Re: CHECK constraints with plpgsql functions - check 'fires' BEFORE data modification? | Mario Splivalo | 11:33 |
| Re: Re: CHECK constraints with plpgsql functions - check 'fires' BEFORE data modification? | Tom Lane | 14:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: CHECK constraints with plpgsql functions - check 'fires' BEFORE data modification? | Mario Splivalo | 07:02 |
| creating a versioning system for sets? | Steve Lefevre | 14:51 |
| Re: How to max() make null as biggest value? | Pavel Stehule | 15:17 |
| Re: How to max() make null as biggest value? | Oliveiros | 15:30 |
| Re: Problem with insert related to different schemas | Scott Marlowe | 16:04 |
| Re: Problem with insert related to different schemas | Gonzalo Aguilar Delgado | 16:32 |
| Re: Problem with insert related to different schemas | Scott Marlowe | 16:34 |
| Re: How to max() make null as biggest value? | Tim Landscheidt | 16:47 |
| Re: Problem with insert related to different schemas | Tom Lane | 17:01 |
| Re: Problem with insert related to different schemas | Gonzalo Aguilar Delgado | 17:01 |
| Re: How to max() make null as biggest value? | Pavel Stehule | 17:02 |
| Thread | Author | Time |
|---|---|---|
| Re: How to max() make null as biggest value? | silly sad | 07:43 |
| LEFT OUTER JOIN issue | Thomas BOURIMECH | 09:06 |
| LEFT OUTER JOIN issue | Thomas BOURIMECH | 12:29 |
| Re: LEFT OUTER JOIN issue | Oliveiros | 12:53 |
| Re: Problem with insert related to different schemas | Gonzalo Aguilar Delgado | 13:25 |
| Re: Problem with insert related to different schemas | Scott Marlowe | 13:31 |
| Re: LEFT OUTER JOIN issue | Oliveiros | 13:42 |
| Re: Problem with insert related to different schemas | Tom Lane | 15:23 |
| Re: LEFT OUTER JOIN issue | Harald Fuchs | 16:33 |
| Re: Problem with insert related to different schemas | Gonzalo Aguilar Delgado | 17:36 |
| Thread | Author | Time |
|---|---|---|
| Re: LEFT OUTER JOIN issue | Jayadevan M | 03:41 |
| Re: LEFT OUTER JOIN issue [SOLVED] | Thomas BOURIMECH | 07:54 |
| Re: LEFT OUTER JOIN issue | Lennin Caro | 19:14 |
| Re: LEFT OUTER JOIN issue | Arne Stölck | 23:02 |
| Thread | Author | Time |
|---|---|---|
| Inconsistent Nested Set Moves | Amiri Barksdale | 00:52 |
| Re: count function alternative in postgres | junaidmalik14 | 10:44 |
| Re: count function alternative in postgres | junaidmalik14 | 10:45 |
| Thread | Author | Time |
|---|---|---|
| How to find broken UTF-8 characters ? | Andreas | 00:12 |
| Re: [SPAM]-D] How to find broken UTF-8 characters ? | silly sad | 10:12 |
| Re: [SPAM]-D] How to find broken UTF-8 characters ? | Andreas | 12:41 |
| Re: [SPAM]-D] Re: [SPAM]-D] How to find broken UTF-8 characters ? | silly sad | 12:55 |
| Thread | Author | Time |
|---|---|---|
| regexp_replace and search/replace values stored in table | Leif Biberg Kristensen | 11:43 |
| Re: regexp_replace and search/replace values stored in table | Tim Landscheidt | 13:04 |
| Re: regexp_replace and search/replace values stored in table | Leif Biberg Kristensen | 13:10 |
| Re: regexp_replace and search/replace values stored in table | Leif Biberg Kristensen | 13:32 |
| Re: regexp_replace and search/replace values stored in table | Leif Biberg Kristensen | 14:18 |
| Thread | Author | Time |
|---|---|---|
| Inserting Multiple Random Rows | Gary Chambers | 16:22 |
| Re: Inserting Multiple Random Rows | Tom Lane | 17:05 |
| Re: Inserting Multiple Random Rows | Justin Graf | 17:07 |
| Re: Inserting Multiple Random Rows | Gary Chambers | 17:48 |
| Re: Inserting Multiple Random Rows | Justin Graf | 19:03 |
| Re: Inserting Multiple Random Rows | Gary Chambers | 19:19 |
| Re: Inserting Multiple Random Rows | Gary Chambers | 20:04 |
| Thread | Author | Time |
|---|---|---|
| Re: [SPAM]-D] How to find broken UTF-8 characters ? | Andreas | 02:34 |
| problem converting strings to timestamps with time zone | Edward Ross | 03:27 |
| Re: problem converting strings to timestamps with time zone | Tom Lane | 03:39 |
| Re: problem converting strings to timestamps with time zone | Edward Ross | 07:59 |
| Re: [SPAM]-D] How to find broken UTF-8 characters ? | Justin Graf | 13:05 |
| Tsearch not searching 'Y' | sandeep prakash dhumale | 13:13 |
| Re: [SQL] Tsearch not searching 'Y' | Kenneth Marshall | 13:56 |
| Re: Tsearch not searching 'Y' | Tom Lane | 14:01 |
| Re: Re: [GENERAL] [SQL] Tsearch not searching 'Y' | sandeep prakash dhumale | 14:14 |
| Re: [SQL] Tsearch not searching 'Y' | John Gage | 17:48 |
| Thread | Author | Time |
|---|---|---|
| Re: problem converting strings to timestamps with time zone | DM | 00:06 |
| Re: [SPAM]-D] How to find broken UTF-8 characters ? | Jasen Betts | 10:21 |
| Re: [SPAM]-D] How to find broken UTF-8 characters ? | Jasen Betts | 10:34 |
| LIMIT problem | silly sad | 12:50 |
| Re: LIMIT problem | Nilesh Govindarajan | 12:57 |
| Re: LIMIT problem | Jasen Betts | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: LIMIT problem | silly sad | 08:55 |
| Re: LIMIT problem | silly sad | 09:05 |
| Re: regexp_replace and search/replace values stored in table | Leif Biberg Kristensen | 17:29 |
| Thread | Author | Time |
|---|---|---|
| Re: regexp_replace and search/replace values stored in table | Sofer, Yuval | 07:25 |
| Thread | Author | Time |
|---|---|---|
| Prevent Domain Compare | Kaveh Mousavi Zamani | 02:12 |
| [GENERAL] Schema design / joins | E H | 04:52 |
| WAL-files restore and nextval('PK') | Andreas Gaab | 11:16 |
| Re: WAL-files restore and nextval('PK') | Tom Lane | 13:33 |
| Re: WAL-files restore and nextval('PK') | Alvaro Herrera | 15:28 |
| Thread | Author | Time |
|---|---|---|
| Re: [GENERAL] Schema design / joins | silly sad | 12:05 |
| Foreign key constraint referencing a parent table | David Weilers | 13:49 |
| Thread | Author | Time |
|---|---|---|
| help | Nicholas I | 03:05 |
| How to get localized to_char(DATE) output | Thomas Kellerer | 22:26 |
| Re: How to get localized to_char(DATE) output | Tom Lane | 22:51 |
| Thread | Author | Time |
|---|---|---|
| Re: How to get localized to_char(DATE) output | Thomas Kellerer | 06:42 |
| Re: How to get localized to_char(DATE) output | Jasen Betts | 09:57 |
| Re: How to get localized to_char(DATE) output | Thomas Kellerer | 10:46 |
| Re: How to get localized to_char(DATE) output | Tom Lane | 14:22 |
| Re: How to get localized to_char(DATE) output | Thomas Kellerer | 14:37 |
| Need a help in regexp | Nicholas I | 14:48 |
| Fwd: Need a help in regexp | Nicholas I | 14:53 |
| Re: Need a help in regexp | A. Kretschmer | 15:04 |
| Re: Need a help in regexp | Leif Biberg Kristensen | 15:37 |
| Column Specific Update Trigger Routine | Plugge, Joe R. | 20:12 |
| Re: Column Specific Update Trigger Routine | Plugge, Joe R. | 20:51 |
| Re: Column Specific Update Trigger Routine | Justin Graf | 20:59 |
| Re: Column Specific Update Trigger Routine | Plugge, Joe R. | 21:02 |
| Re: Column Specific Update Trigger Routine | Tom Lane | 21:13 |
| Thread | Author | Time |
|---|---|---|
| Re: help | Filip Rembiałkowski | 15:24 |
| Celko take on EAV | Richard Broersma | 16:33 |
| Re: Celko take on EAV | Justin Graf | 18:43 |
| Thread | Author | Time |
|---|---|---|
| [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Torsten Zühlsdorff | 09:35 |
| Invalid message format Exception | Gnanakumar | 14:19 |
| advice on query joining 10 tables | Gerardo Herzig | 18:40 |
| Re: advice on query joining 10 tables | Tom Lane | 20:11 |
| Re: advice on query joining 10 tables | Scott Marlowe | 20:37 |
| Re: advice on query joining 10 tables | Gerardo Herzig | 20:38 |
| Re: advice on query joining 10 tables | Scott Marlowe | 21:35 |
| Thread | Author | Time |
|---|---|---|
| [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Torsten Zühlsdorff | 12:31 |
| [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Torsten Zühlsdorff | 12:36 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Tom Lane | 14:23 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Torsten Zühlsdorff | 14:26 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Stuart | 22:06 |
| Thread | Author | Time |
|---|---|---|
| best paging strategies for large datasets? | Louis-David Mitterrand | 05:41 |
| Re: best paging strategies for large datasets? | Pavel Stehule | 05:45 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | silly sad | 06:00 |
| Invalid message format Exception | Gnanakumar | 10:34 |
| Re: Invalid message format Exception | Rob Sargent | 14:51 |
| Re: best paging strategies for large datasets? | Justin Graf | 15:59 |
| Re: best paging strategies for large datasets? | Justin Graf | 16:26 |
| Greetings folks, dumb question maybe? | Josh | 17:32 |
| Re: Greetings folks, dumb question maybe? | Josh | 17:57 |
| Re: Greetings folks, dumb question maybe? | Richard Broersma | 21:04 |
| Re: Greetings folks, dumb question maybe? | Little, Douglas | 21:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Invalid message format Exception | Gnanakumar | 07:04 |
| Re: best paging strategies for large datasets? | silly sad | 07:36 |
| Re: best paging strategies for large datasets? | Louis-David Mitterrand | 07:43 |
| Re: best paging strategies for large datasets? | Louis-David Mitterrand | 07:47 |
| Re: best paging strategies for large datasets? | silly sad | 08:41 |
| Re: Greetings folks, dumb question maybe? | Jasen Betts | 10:09 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Jasen Betts | 10:51 |
| Re: Greetings folks, dumb question maybe? | Joshua Tolley | 12:37 |
| Re: best paging strategies for large datasets? | Justin Graf | 13:28 |
| Re: best paging strategies for large datasets? | Justin Graf | 13:57 |
| Re: Invalid message format Exception | Rob Sargent | 15:18 |
| Thread | Author | Time |
|---|---|---|
| Postgresql database | Trinath Somanchi | 08:42 |
| Re: Postgresql database | silly sad | 09:14 |
| Re: Postgresql database | Trinath Somanchi | 09:28 |
| Re: Postgresql database | Leif Biberg Kristensen | 09:51 |