Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| CREATE GROUP? | Vladimir Sovetov | 01:16 |
| subscribe pgsql-sql | Howie | 18:43 |
| varchar vs. upper(), lower() etc. | Leslie Mikesell | 18:46 |
| Primary and foreign key | Daniel Facciolo Pires | 21:24 |
| Thread | Author | Time |
|---|---|---|
| create a new user in a group | maloune | 12:33 |
| Re: [SQL] create a new user in a group | Sferacarta Software | 13:35 |
| Re: [SQL] How to Make Case InSensitive??? | Barracuda | 13:48 |
| Re[2]: [SQL] How to Make Case InSensitive??? | Sferacarta Software | 14:14 |
| Re[2]: [SQL] How to Make Case InSensitive??? | Herouth Maoz | 14:42 |
| Re: [SQL] How to Make Case InSensitive??? | Bruce Momjian | 17:30 |
| rtree, btree, hash index methods...should I care? | Patrick Giagnocavo | 18:19 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] How to Make Case InSensitive??? | Jerome Knobl | 08:13 |
| Datetime field | Henrik Denseje Pedersen | 10:46 |
| Re: [SQL] Datetime field | Jose' Soares | 13:28 |
| Turn autocommit off ? | Andreas Joppich | 14:12 |
| Re: [SQL] Turn autocommit off ? | Federico Passaro | 14:46 |
| IF..THEN..ELSE | David J. Haglin | 15:46 |
| Re: [SQL] Turn autocommit off ? | Bruce Momjian | 16:00 |
| Re: [SQL] Turn autocommit off ? | Bruce Momjian | 16:02 |
| Thread | Author | Time |
|---|---|---|
| postmaster dies on complicated views | David Rugge | 02:14 |
| Re: [SQL] postmaster dies on complicated views | Bruce Momjian | 02:58 |
| PostgreSQL syntax question | Stephen Davies | 05:07 |
| SQL equiv to MS-Access Transform | William Leeke | 06:39 |
| Re: [SQL] SQL equiv to MS-Access Transform | David Hartwig | 12:47 |
| Re: [SQL] PostgreSQL syntax question | Sferacarta Software | 13:13 |
| Re: [SQL] PostgreSQL syntax question | Bruce Momjian | 16:21 |
| Re: [SQL] Turn autocommit off ? | Peter T Mount | 17:29 |
| Thread | Author | Time |
|---|---|---|
| date problem | Ian Johnston | 21:53 |
| Re: [SQL] How to Make Case InSensitive??? | Leslie Mikesell | 22:48 |
| To create the query for a select where one is NOT in the other | Karl Denninger | 22:55 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] To create the query for a select where one is NOT in the other | Eric McKeown | 23:23 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] How to Make Case InSensitive??? | Bruce Momjian | 01:39 |
| Q:Update Rule | Detlef Boddin S/N O.21 | 10:00 |
| Re: [SQL] Q:Update Rule | Sferacarta Software | 13:53 |
| subscribe sql | Deslippe, Michael | 17:56 |
| RE: [SQL] To create the query for a select where one is NOT in th e other | Jackson, DeJuan | 18:07 |
| Re: [SQL] How to Make Case InSensitive??? | Mirek Budzanowski | 19:07 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] How to Make Case InSensitive??? | Bruce Momjian | 16:47 |
| 2 questions. | Colin Dick | 17:01 |
| Question re: null | Colin Dick | 17:37 |
| case-insensitive SORT BY? | Patrick Giagnocavo | 19:53 |
| Selecting from float4[] arrays | G. Anthony Reina | 20:09 |
| create function syntax question | William Leeke | 20:30 |
| Where to find postgres and SQL examples?? | William Leeke | 20:34 |
| RE: [SQL] To create the query for a select where one is NOT in th e other | Eric McKeown | 20:49 |
| Re: [SQL] case-insensitive SORT BY? | Richard Lynch | 21:41 |
| RE: [SQL] To create the query for a select where one is NOT in th e other | Jackson, DeJuan | 23:09 |
| arrays | Brook Milligan | 23:40 |
| Thread | Author | Time |
|---|---|---|
| subscribe | Lotto | 12:13 |
| Re: [SQL] 2 questions. | Chris Johnson | 12:44 |
| Re: [SQL] case-insensitive SORT BY? | Chris Johnson | 12:47 |
| Re: [SQL] 2 questions. | Sferacarta Software | 13:45 |
| Re: [SQL] Question re: null | Sferacarta Software | 15:25 |
| Cursors | Glenn Sullivan | 15:55 |
| '' != NULL in PostGres??? | Neil Harkins | 17:41 |
| Re: [SQL] '' != NULL in PostGres??? | Brook Milligan | 18:10 |
| Re: [SQL] case-insensitive SORT BY? | David Hartwig | 18:31 |
| Re: [SQL] '' != NULL in PostGres??? | Colin Dick | 18:57 |
| Re: [SQL] Cursors | Richard Lynch | 20:09 |
| Re: [SQL] '' != NULL in PostGres??? | James Olin Oden | 21:49 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] Re: [SQL] 2 questions. | Thomas G. Lockhart | 02:34 |
| Hello everybody,some question! | Tong Hoai Dan | 02:42 |
| Re: [HACKERS] Re: [SQL] 2 questions. | Jose' Soares | 10:46 |
| Re: [HACKERS] Re: [SQL] 2 questions. | Thomas G. Lockhart | 13:50 |
| C compiler error when using PostGres | G. Anthony Reina | 20:30 |
| Re: [SQL] C compiler error when using PostGres | John E. Garrott | 20:47 |
| Re: [SQL] C compiler error when using PostGres | G. Anthony Reina | 21:21 |
| I can't seem to set the -B option on the postmaster over 3000 | G. Anthony Reina | 22:22 |
| Thread | Author | Time |
|---|---|---|
| Having trouble with join | G. Anthony Reina | 00:49 |
| Re: [SQL] C compiler error when using PostGres | James Olin Oden | 11:44 |
| Thread | Author | Time |
|---|---|---|
| Problems with inserting into tables... | Gemeinschaft Studienarbeit Datenbanken | 15:55 |
| Thread | Author | Time |
|---|---|---|
| Timespan conversion | Herouth Maoz | 12:53 |
| Another nut to crack with insertion into tables... *sigh* | Gemeinschaft Studienarbeit Datenbanken | 20:46 |
| Thread | Author | Time |
|---|---|---|
| subscribe | Stan Thomas | 07:08 |
| SQL type conversion - text to char/varchar | R.K.Street | 09:48 |
| Re: [SQL] Another nut to crack with insertion into tables... *sigh* | Sferacarta Software | 13:35 |
| Re: Another nut to crack with insertion into tables... *sigh* | Tom Lane | 14:02 |
| Setting current time on insert | Bryan White | 14:50 |
| Re: [SQL] Re: Another nut to crack with insertion into tables... *sigh* | Herouth Maoz | 16:20 |
| Thread | Author | Time |
|---|---|---|
| Getting datatype before SELECT | Glenn Sullivan | 17:05 |
| Re: [SQL] Getting datatype before SELECT | David Hartwig | 21:28 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Getting datatype before SELECT | D'Arcy J.M. Cain | 02:10 |
| Re: [SQL] Getting datatype before SELECT | Bob Smither | 02:30 |
| Re: [SQL] Getting datatype before SELECT | James Olin Oden | 11:40 |
| Re: [SQL] Getting datatype before SELECT | Bryan White | 13:19 |
| Re: [SQL] Getting datatype before SELECT | herouth maoz | 22:21 |
| Thread | Author | Time |
|---|---|---|
| RE: [SQL] Getting datatype before SELECT | Jackson, DeJuan | 16:41 |
| Re: [SQL] Getting datatype before SELECT | Glenn Sullivan | 17:39 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Getting datatype before SELECT | D'Arcy J.M. Cain | 02:14 |
| Thread | Author | Time |
|---|---|---|
| grouping a ordered list | phansen | 06:50 |
| Thread | Author | Time |
|---|---|---|
| RE: [SQL] Getting datatype before SELECT | Herouth Maoz | 08:54 |
| Still the problem with the autoincrement field | Marc Eggenberger | 09:29 |
| Re: [GENERAL] Still the problem with the autoincrement field | Kevin Heflin | 09:57 |
| Re: [GENERAL] Still the problem with the autoincrement field | Herouth Maoz | 10:08 |
| Re: [SQL] Re: [GENERAL] Still the problem with the autoincrement field | James Oden | 11:48 |
| select-querries out of an array? | Gemeinschaft Studienarbeit Datenbanken | 15:03 |
| Re: [SQL] select-querries out of an array? | Herouth Maoz | 15:09 |
| Thread | Author | Time |
|---|---|---|
| random tuple | Mauro Bartolomeoli | 08:51 |
| RE: [SQL] random tuple | Jackson, DeJuan | 16:38 |
| unsubscribe | Florian M Unterkircher | 19:52 |
| CASE...WHEN... END | Giovanni Giuffrida | 19:59 |
| Updates/Deletes on class* | Gemeinschaft Studienarbeit Datenbanken | 22:05 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | bisheng | 05:04 |
| RE: [SQL] random tuple | Mauro Bartolomeoli | 12:04 |
| RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml' | Jackson, DeJuan | 16:29 |
| RE: [SQL] random tuple | Jackson, DeJuan | 16:46 |
| Re: [ADMIN] RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml' | Terry Mackintosh | 18:06 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] RE: [SQL] random tuple | Thomas G. Lockhart | 04:43 |
| Thread | Author | Time |
|---|---|---|
| french caracters in Postgresql database ? | Blaise Laurent | 09:27 |
| Thread | Author | Time |
|---|---|---|
| insert/update | David Welton | 20:23 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] french caracters in Postgresql database ? | Roberto Joao Lopes Garcia | 17:00 |
| correlative insertion | Jorge Maturana Ortiz | 22:18 |
| Thread | Author | Time |
|---|---|---|
| dilemma | Eric McKeown | 02:24 |
| Re: [SQL] dilemma | Herouth Maoz | 09:46 |
| Re: [SQL] correlative insertion | Herouth Maoz | 09:49 |
| Using the IN predicate in an UPDATE... | Thomas Good | 13:06 |
| Re: Using the IN predicate in an UPDATE... | Herouth Maoz | 14:42 |
| Re: [SQL] Re: Using the IN predicate in an UPDATE... | Gene Selkov Jr. | 20:27 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Using the IN predicate in an UPDATE... | Leslie Mikesell | 03:21 |
| Re: [SQL] dilemma | Michael Shields | 07:35 |
| Optimizing perfomance using indexes | Vladimir Litovka | 12:35 |
| Re: [SQL] Using the IN predicate in an UPDATE... | Thomas Good | 12:37 |
| Cluster(ing) to help joins? | pierre | 13:53 |
| Re: [SQL] Optimizing perfomance using indexes | Oleg Bartunov | 15:09 |
| RE: [SQL] Optimizing performance using indexes | Jackson, DeJuan | 15:25 |
| RE: Optimizing performance using indexes | Vladimir Litovka | 17:08 |
| Creating Indexes IP and MAC Data Types (followup) | Craig Orsinger | 23:11 |
| Thread | Author | Time |
|---|---|---|
| Optimizing again | Walt Bigelow | 01:25 |
| Re: [HACKERS] Re: [SQL] Optimizing perfomance using indexes | Thomas G. Lockhart | 06:10 |
| RE: Optimizing performance using indexes | Vladimir Litovka | 11:51 |
| Re: [SQL] RE: Optimizing performance using indexes | Bryan White | 16:49 |
| Re: Triggers and SQL functions | Philippe Rochat (RSR: 318 17 93) | 22:23 |
| Re: Triggers and SQL functions | Philippe Rochat (RSR: 318 17 93) | 22:38 |
| Thread | Author | Time |
|---|---|---|
| Is this BUG or FEATURE? | Vladimir Litovka | 13:19 |
| RE: [SQL] Is this BUG or FEATURE? | Taral | 17:44 |
| RE: [SQL] Is this BUG or FEATURE? | Vladimir Litovka | 17:48 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Using the IN predicate in an UPDATE... | Herouth Maoz | 09:24 |
| NULL DATE | Michel \'ZioBudda\' Morelli | 20:28 |
| Re: [SQL] NULL DATE | ZioBudda | 20:44 |
| Re: [SQL] NULL DATE | Jan Wieck | 20:56 |
| Re: [SQL] NULL DATE | Jan Wieck | 21:02 |
| RE: [SQL] NULL DATE | Taral | 21:03 |
| Thread | Author | Time |
|---|---|---|
| `statistical' aggregate functions etc. | Ulf Mehlig | 07:39 |
| [SQL, regex, words] how to match word boundaries using regex's? | Tony.Curtis | 13:02 |
| PostgreSQL COPY command | Paul Friberg CEO - ISTI | 13:03 |
| Re: [SQL] [SQL, regex, words] how to match word boundaries using regex's? | Gene Selkov Jr. | 13:33 |
| Re: [SQL] [SQL, regex, words] how to match word boundaries using regex's? | Tony.Curtis | 14:58 |
| index not used in like clause... | David Mansfield | 18:01 |
| Defaulting to current date | Bryan White | 19:31 |
| Defaulting to current date | Bryan White | 19:37 |
| Thread | Author | Time |
|---|---|---|
| timespan question: using value from row in select | Michael Olivier | 01:18 |
| Index on VARCHAR faster than TEXT? | Pascal Forget | 14:01 |
| RE: [SQL] timespan question: using value from row in select | Jackson, DeJuan | 14:46 |
| count(*) and group by's... | Howie | 16:59 |
| Re: [SQL] count(*) and group by's... | David Hartwig | 17:39 |
| Thread | Author | Time |
|---|---|---|
| Large Object Interface | Mark Wilson | 13:52 |
| Probs with arrays | Gregor Zych | 19:54 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] `statistical' aggregate functions etc. | Aleksey Dashevsky | 09:45 |
| Re: [SQL] `statistical' aggregate functions etc. | Jan Wieck | 10:04 |
| Time format ? (Really microsecond ??) | Philippe Rochat (RSR: 318 17 93) | 10:37 |
| Help me ,Thank you !! 📎 | ronggui | 13:05 |
| Thread | Author | Time |
|---|---|---|
| Reading and writing at the same time | G. Anthony Reina | 18:57 |
| Thread | Author | Time |
|---|---|---|
| varchar vs. text | Leslie Mikesell | 17:37 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Reading and writing at the same time | Herouth Maoz | 09:49 |
| Thread | Author | Time |
|---|---|---|
| palloc failure: memory exhausted, but ulimit 'unlimited' | Michael Olivier | 05:13 |
| idiom to move records? | Leslie Mikesell | 05:31 |
| Help on extensended attribute types? | Mike Meyer | 08:19 |
| Re: [SQL] idiom to move records? | Herouth Maoz | 09:34 |
| Re: [SQL] idiom to move records? | Jan Wieck | 10:02 |
| Re: [SQL] idiom to mv recs => [NEW] bleeding lock? | Thomas Good | 13:18 |
| Alternate disks for Indexes | pierre | 13:23 |
| RE: [SQL] Alternate disks for Indexes | Shulyak AN | 13:52 |
| Re: [SQL] idiom to mv recs => [NEW] bleeding lock? | Herouth Maoz | 14:57 |
| Thread | Author | Time |
|---|---|---|
| RE: [SQL] palloc failure: memory exhausted, but ulimit 'unlimited ' | Jackson, DeJuan | 00:13 |
| [No subject] | Brenda Butler | 02:16 |
| Re: [SQL] Joining bug???? | Gene Selkov Jr. | 03:18 |
| Joining bug???? | pierre | 03:39 |
| Re: [SQL] Joining bug???? | David Hartwig | 16:24 |
| Re: [SQL] Joining bug???? | pierre | 17:00 |
| Re: [SQL] Joining bug???? | David Hartwig | 18:21 |
| Re: [SQL] Joining bug???? | David Hartwig | 18:40 |
| Re: [SQL] Joining bug???? | pierre | 19:04 |
| RE: [SQL] Joining bug???? | Jackson, DeJuan | 23:21 |
| Re: [SQL] Joining bug???? | Howie | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Joining bug???? | pierre | 01:38 |
| Re: [SQL] Joining bug???? | Bruce Momjian | 02:19 |
| Unsubscribe | Felix Kwong | 07:03 |
| Re: [SQL] Joining bug???? | Jan Wieck | 11:43 |
| Operator <> for lseg,lseg bug | Guido Weber | 12:34 |
| Re: [SQL] Operator <> for lseg,lseg bug | Bruce Momjian | 16:05 |
| RE: [SQL] Joining bug???? | Jackson, DeJuan | 17:11 |
| RE: [SQL] Joining bug???? | Jackson, DeJuan | 17:49 |
| Re: [SQL] Joining bug???? | Jan Wieck | 17:56 |
| Re: [SQL] Joining bug???? | Jan Wieck | 18:38 |
| automatic increment field type | Daniel Facciolo Pires | 18:38 |
| Thread | Author | Time |
|---|---|---|
| SELECT and the need for cursors (?) | SQL User | 01:14 |
| more on what I meant by cursor issues | SQL User | 01:29 |
| Re: [SQL] SELECT and the need for cursors (?) | Ulf Mehlig | 07:30 |
| geometric types | vandeurzen luc | 14:03 |
| Thread | Author | Time |
|---|---|---|
| Access rights to sequence.nextval? | Petter Reinholdtsen | 14:40 |