Discussion for users on SQL related matters.
| 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 |