Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Question on interval | Steve Crawford | 00:38 |
| Re: Floating point type to store numbers | Lew | 05:20 |
| Regular Expression Data Type | Richard Doust | 16:03 |
| Split String Into Multiple Records | Aaron Bono | 23:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Split String Into Multiple Records | Tom Lane | 02:13 |
| Re: Split String Into Multiple Records | Aaron Bono | 02:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Windows postgres | Paul Lambert | 04:34 |
| Re: We all are looped on Internet: request +transport = invariant | Bart Degryse | 06:46 |
| Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant | Bart Degryse | 07:00 |
| Re: Retrieve month from date in SQl query | Michael Fuhr | 07:41 |
| Re: We all are looped on Internet: request + transport = invariant | Dmitry Turin | 08:20 |
| Re: We all are looped on Internet: request+transport = invariant | Bart Degryse | 10:18 |
| Re: We all are looped on Internet: request + transport = invariant | Joe | 11:57 |
| plperlu hash problem | Bart Degryse | 15:09 |
| Large journal as psql table. Good idea? Triggering. | Bryce Nesbitt | 23:12 |
| Large journal as psql table. Good idea? Triggering. | Phillip Smith | 23:27 |
| Thread | Author | Time |
|---|---|---|
| Selecting rows with "static" ordering | Steve Midgley | 00:01 |
| Re: Selecting rows with "static" ordering | Phillip Smith | 00:27 |
| Re: Selecting rows with "static" ordering | chester c young | 00:35 |
| Re: Selecting rows with "static" ordering | Aaron Bono | 00:46 |
| Re: Selecting rows with "static" ordering | Peter Childs | 04:02 |
| Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant | Dmitry Turin | 13:42 |
| Re: Selecting rows with "static" ordering | Kevin Hunter | 14:11 |
| Thread | Author | Time |
|---|---|---|
| Recursive query for Product Tree | devil live | 14:06 |
| NEW to plpythonu function? | David Flegl | 14:56 |
| Dynamic prepare possible in plpgsql? | Collin Peters | 23:58 |
| Thread | Author | Time |
|---|---|---|
| "is not distinct from" syntax error? | Collin Peters | 00:03 |
| Re: "is not distinct from" syntax error? | Tom Lane | 00:46 |
| Re: Dynamic prepare possible in plpgsql? | Tom Lane | 00:52 |
| Re: Dynamic prepare possible in plpgsql? | Collin Peters | 16:52 |
| Re: Dynamic prepare possible in plpgsql? | Jonah H. Harris | 17:16 |
| Thread | Author | Time |
|---|---|---|
| Re: We all are looped on Internet: request + transport = invariant | Dmitry Turin | 05:05 |
| Re: We all are looped on Internet: request + transport = invariant | Joe | 12:47 |
| Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant | Richard Huxton | 14:19 |
| Re: Dynamic prepare possible in plpgsql? | Collin Peters | 15:53 |
| Possible to access value in RECORD without knowing column name? | Collin Peters | 19:17 |
| Re: Possible to access value in RECORD without knowing column name? | Richard Albright | 19:26 |
| Thread | Author | Time |
|---|---|---|
| Joe Celko's method to "generate_series" not working? | Richard Broersma Jr | 00:17 |
| Re: Joe Celko's method to "generate_series" not working? | Richard Broersma Jr | 00:35 |
| Needs Function | Penchalaiah P. | 04:38 |
| Needs Function | Penchalaiah P. | 04:38 |
| Re: Dynamic prepare possible in plpgsql? | Tom Lane | 05:55 |
| Re: Needs Function | Rodrigo De León | 07:17 |
| Re: Needs Function | Aaron Bono | 14:14 |
| Re: Needs Function | Bart Degryse | 14:20 |
| Insert into VIEW using RULE. Not possible to use nextval()? | Collin Peters | 17:04 |
| Re: Insert into VIEW using RULE. Not possible to use nextval()? | Richard Broersma Jr | 17:26 |
| Re: Insert into VIEW using RULE. Not possible to use nextval()? | Collin Peters | 18:30 |
| Re: Insert into VIEW using RULE. Not possible to use nextval()? | Richard Broersma Jr | 19:26 |
| Thread | Author | Time |
|---|---|---|
| select slows from 3 seconds to 30 seconds 📎 | Gary Stainburn | 15:49 |
| Re: Insert into VIEW using RULE. Not possible to use nextval()? | Collin Peters | 21:51 |
| Re: Insert into VIEW using RULE. Not possible to use nextval()? | Richard Broersma Jr | 22:16 |
| Thread | Author | Time |
|---|---|---|
| Re: select slows from 3 seconds to 30 seconds | Tom Lane | 00:57 |
| Sequence vs. Index Scan | Aaron Bono | 21:05 |
| Re: Sequence vs. Index Scan | Andrew Sullivan | 21:30 |
| Re: Sequence vs. Index Scan | Aaron Bono | 22:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Sequence vs. Index Scan | Tom Lane | 00:22 |
| Re: Sequence vs. Index Scan | Andrew Sullivan | 00:40 |
| Re: Sequence vs. Index Scan | Aaron Bono | 03:28 |
| Re: Sequence vs. Index Scan | Aaron Bono | 04:13 |
| Re: Sequence vs. Index Scan | Aaron Bono | 04:25 |
| Re: Sequence vs. Index Scan | Jaime Casanova | 04:37 |
| ROW_NUMBER alias | Robins | 16:01 |
| Re: ROW_NUMBER alias | Stefan Becker | 18:41 |
| Re: Sequence vs. Index Scan | Aaron Bono | 18:45 |
| Re: hi | John Summerfield | 23:42 |
| Thread | Author | Time |
|---|---|---|
| Re: ROW_NUMBER alias | Robins | 02:03 |
| How to use function PointN? | Nemo Terry | 08:07 |
| syntax error in "createdb" | kannan kk | 09:01 |
| Re: syntax error in "createdb" | Joris Dobbelsteen | 09:12 |
| Re: [SQL] syntax error in "createdb" | Phillip Smith | 09:25 |
| Re: Sequence vs. Index Scan | Andrew Sullivan | 10:58 |
| Re: How to use function PointN? | Michael Fuhr | 13:13 |
| Re: Sequence vs. Index Scan | Tom Lane | 14:37 |
| Temporal Table Relations and Referential Integrity | Richard Broersma Jr | 14:59 |
| Re: Sequence vs. Index Scan | Aaron Bono | 16:40 |
| Re: Dynamic prepare possible in plpgsql? | Jim Nasby | 16:58 |
| Error: Input string was not in a correct format | Rommel the iCeMAn | 23:17 |
| Re: Error: Input string was not in a correct format | Rommel the iCeMAn | 23:37 |
| Re: Error: Input string was not in a correct format | Michael Glaesemann | 23:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Error: Input string was not in a correct format | Tom Lane | 00:11 |
| Query RE using COPY | Paul Lambert | 01:51 |
| Re: Query RE using COPY | Jonah H. Harris | 02:16 |
| Re: Query RE using COPY | Paul Lambert | 02:44 |
| Re: Query RE using COPY | Phillip Smith | 04:14 |
| Re: Query RE using COPY | Paul Lambert | 04:22 |
| Re: select slows from 3 seconds to 30 seconds | Gary Stainburn | 10:08 |
| Needs Query | Penchalaiah P. | 12:18 |
| Re: Needs Query | A. Kretschmer | 12:58 |
| Re: Query RE using COPY | Jonah H. Harris | 13:30 |
| Re: Needs Query | Reuven Abliyev | 14:00 |
| Re: Error: Input string was not in a correct format | Rommel the iCeMAn | 14:10 |
| Thread | Author | Time |
|---|---|---|
| query to select a linked list | Louis-David Mitterrand | 12:55 |
| Re: query to select a linked list | Gregory Stark | 13:24 |
| Re: query to select a linked list | Louis-David Mitterrand | 13:28 |
| Re: query to select a linked list | Aaron Bono | 13:29 |
| Re: query to select a linked list | Achilleas Mantzios | 13:31 |
| Re: query to select a linked list | Louis-David Mitterrand | 14:30 |
| Re: query to select a linked list | Louis-David Mitterrand | 14:33 |
| Re: query to select a linked list | Scott Marlowe | 18:03 |
| Re: query to select a linked list | Scott Marlowe | 18:04 |
| Re: query to select a linked list | Gregory Stark | 23:16 |
| Re: query to select a linked list | Robert Edwards | 23:49 |
| Thread | Author | Time |
|---|---|---|
| Passing input to a view? | Paul Lambert | 06:03 |
| Re: Passing input to a view? | A. Kretschmer | 06:14 |
| Re: Passing input to a view? | Phillip Smith | 06:14 |
| Count rows by day interval | Loredana Curugiu | 08:01 |
| Re: query to select a linked list | Louis-David Mitterrand | 08:05 |
| insert a sequence | ivan marchesini | 14:49 |
| Re: Count rows by day interval | chester c young | 18:34 |
| Thread | Author | Time |
|---|---|---|
| Re: insert a sequence | Ireneusz Pluta | 10:03 |
| PL/PGSQL Record type question | Gábriel Ákos | 14:00 |
| Re: PL/PGSQL Record type question | imad | 14:09 |
| Re: PL/PGSQL Record type question | Gábriel Ákos | 14:42 |
| Re: PL/PGSQL Record type question | John DeSoi | 15:12 |
| Convert serial column to regular integer | Collin Peters | 16:24 |
| Re: Convert serial column to regular integer | Rodrigo De León | 16:36 |
| Re: PL/PGSQL Record type question | imad | 16:40 |
| Re: PL/PGSQL Record type question | Robins | 17:39 |
| Re: PL/PGSQL Record type question | imad | 18:19 |
| Re: Convert serial column to regular integer | Collin Peters | 20:18 |
| Re: Convert serial column to regular integer | Tom Lane | 20:32 |
| check_constraint and Extract not working? | Fernando Hevia | 21:14 |
| Thread | Author | Time |
|---|---|---|
| Howto convert / (re)store xml column to table in trigger using contrib/xml2? | Joost Kraaijeveld | 09:32 |
| Funny date-sorting task | Andreas | 23:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Funny date-sorting task | Frank Bax | 03:13 |
| Re: Funny date-sorting task | Rodrigo De León | 08:49 |
| Re: Funny date-sorting task | Greg Sabino Mullane | 13:47 |
| Thread | Author | Time |
|---|---|---|
| How to process inverted comma in "EXECUTE 'insert into xxx values(...)'; "? | Nemo Terry | 04:51 |
| Re: How to process inverted comma in "EXECUTE 'insert into xxx values(...)'; "? | Rodrigo De León | 06:25 |
| Re: How to process inverted comma in "EXECUTE 'insert into xxx values(...) | Nemo Terry | 06:50 |
| Re: How to process inverted comma in "EXECUTE 'insert into xxx values(...) | Richard Huxton | 07:12 |