Discussion for users on SQL related matters.
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] Character type name?? How to lower case it? (fwd) | Remigiusz Sokolowski | 07:40 | 
| Re: [SQL] Character type name?? How to lower case it? | Remigiusz Sokolowski | 08:10 | 
| Re: [SQL] index on aggregate function | Remigiusz Sokolowski | 08:50 | 
| PL/pgSQL / SPI and UTILITY statements | Jan Wieck | 14:20 | 
| Re: [SQL] Re: [HACKERS] Re: SELECT DISTINCT ON ... ORDER BY ... | jose' soares | 14:57 | 
| Re: [SQL] Re: [HACKERS] Re: SELECT DISTINCT ON ... ORDER BY ... | Oliver Elphick | 16:40 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] Re: [HACKERS] Re: SELECT DISTINCT ON ... ORDER BY ... | jose' soares | 15:25 | 
| Re: [SQL] Re: [HACKERS] Re: SELECT DISTINCT ON ... ORDER BY ... | Herouth Maoz | 15:57 | 
| RE: [GENERAL] Dashed if I can work this out. Help needed copying substring to another field | Jackson, DeJuan | 18:17 | 
| RE: [SQL] index on int2. | Jackson, DeJuan | 18:28 | 
| RE: [GENERAL] Missing features ? | Jackson, DeJuan | 19:55 | 
| Thread | Author | Time | 
|---|---|---|
| keeping OID's when copying table | Michael Olivier | 00:42 | 
| Re: [SQL] index on int2. | Vladimir Dobrokhotov | 01:01 | 
| Re: [SQL] keeping OID's when copying table | Bruce Momjian | 03:55 | 
| subscribe pgsql-sql | Claudius du Plessis | 05:57 | 
| [No subject] | Sebestyen Zoltan | 11:40 | 
| [No subject] | Sebestyen Zoltan | 11:41 | 
| Re: [PyGreSQL] referencial keys foreign keys | Johann Spies | 15:53 | 
| how to use arrays? | Viorel Anghel | 17:49 | 
| Two table select | Andy | 18:16 | 
| RE: [SQL] Two table select | Jackson, DeJuan | 18:53 | 
| RE: Two table select (fwd) | Jackson, DeJuan | 19:09 | 
| RE: Two table select (fwd) | Andy | 19:11 | 
| Re: [SQL] Two table select | Jan Wieck | 19:50 | 
| RE: Two table select (fwd) | Jackson, DeJuan | 20:57 | 
| Thread | Author | Time | 
|---|---|---|
| Performance Question | Tim Perdue | 02:25 | 
| [No subject] | joop | 08:33 | 
| Re: [SQL] Performance Question | Tim Perdue | 15:24 | 
| Re: Performance Question | Tom Lane | 15:27 | 
| using matches on int4 | Gregory Holston | 17:13 | 
| RE: [SQL] using matches on int4 | Jackson, DeJuan | 17:40 | 
| RE: [SQL] using matches on int4 | Gregory Holston | 17:49 | 
| RE: [SQL] using matches on int4 | Jackson, DeJuan | 18:02 | 
| Re: [SQL] using matches on int4 | George Moga | 18:08 | 
| problem with join & count | pat | 20:39 | 
| RE: [SQL] problem with join & count | Jackson, DeJuan | 21:00 | 
| Re: [SQL] keeping OID's when copying table | Michael Olivier | 21:34 | 
| Re: [SQL] keeping OID's when copying tableu | Bruce Momjian | 21:42 | 
| Re: [SQL] problem with join & count | Jan Wieck | 21:49 | 
| Re: [SQL] keeping OID's when copying table | Bruce Momjian | 21:51 | 
| Re: [SQL] Performance Question | Viorel Anghel | 21:57 | 
| Re: [SQL] problem with join & count | Dimitri | 22:10 | 
| Re: [SQL] problem with join & count | Dimitri | 22:14 | 
| RE: [SQL] problem with join & count | Jackson, DeJuan | 22:52 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] index on aggregate function | Sascha Schumann | 12:49 | 
| Re: [SQL] Functional Indexes | Tom Lane | 17:27 | 
| Re: [SQL] Function returning multiple rows? | Jan Wieck | 17:39 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] Functional Indexes | Sascha Schumann | 00:28 | 
| Re: [SQL] Functional Indexes | Marc Howard Zuckman | 02:42 | 
| Re: [SQL] Functional Indexes | Tom Lane | 03:18 | 
| Re: [SQL] Functional Indexes | Bruce Momjian | 03:48 | 
| [No subject] | Claudius du Plessis | 09:08 | 
| subscribe pgsql-sql | Pascal GEND | 13:08 | 
| Re: [HACKERS] Re: [SQL] Functional Indexes | Thomas G. Lockhart | 15:56 | 
| Re: [SQL] Functional Indexes | Bryan White | 18:36 | 
| RE: SQL Syntax | Jackson, DeJuan | 20:49 | 
| HAVING | Gregory Holston | 21:53 | 
| Re: [SQL] Quickie | Gregory W Burnham | 21:56 | 
| Quickie | pierre | 21:57 | 
| Re: [SQL] Quickie | D'Arcy J.M. Cain | 22:49 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] HAVING | Oliver Elphick | 00:03 | 
| Using Indexes with Pg | Fabrice Scemama | 00:26 | 
| RE: [GENERAL] pqReadData() -- backend closed the channel unexpect edly. | Jackson, DeJuan | 17:15 | 
| Re: [GENERAL] pqReadData() -- backend closed the channel unexpect edly. | Ludovico Magnocavallo | 17:30 | 
| RE: [GENERAL] pqReadData() -- backend closed the channel unexpect edly. | Jackson, DeJuan | 20:16 | 
| Re: [GENERAL] pqReadData() -- backend closed the channel unexpect edly. | Ludovico Magnocavallo | 21:55 | 
| RE: [GENERAL] pqReadData() -- backend closed the channel unexpect edly. | Jackson, DeJuan | 22:50 | 
| Thread | Author | Time | 
|---|---|---|
| [Fwd: [SQL] Using Indexes with Pg]IamReal. | Fabrice Scemama | 05:23 | 
| Select max field | Bob Kruger | 19:42 | 
| Outer Joins | Jan Mönnich | 21:32 | 
| Rule problem | pierre | 21:34 | 
| RES: [GENERAL] Select max field | Ricardo J.C.Coelho | 21:40 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] Plpgsql Language Feature? | Jan Wieck | 01:08 | 
| DEFAULT TEXT 'now' in create table | Roberto Joao Lopes Garcia | 16:20 | 
| Re: [HACKERS] RULE (and ALTER TABLE) questions | Hannu Krosing | 17:09 | 
| Re: [HACKERS] RULE (and ALTER TABLE) questions | Jan Wieck | 19:16 | 
| Booleans and Casting | Paul Ramsey | 21:33 | 
| Thread | Author | Time | 
|---|---|---|
| connection timeout? | pierre | 01:03 | 
| Moving Database -> New Disk | Tim Perdue, Directricity.com | 04:45 | 
| unsubscribe | Walter Butz | 08:25 | 
| Re: [SQL] connection timeout? | Sascha Schumann | 14:55 | 
| replace missing | Michael Scheuner | 18:33 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] Moving Database -> New Disk | Fabrice Scemama | 00:17 | 
| RE: [SQL] connection timeout? | Kim Markle | 16:29 | 
| Re: Moving Database -> New Disk | Tom Lane | 18:38 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] index on aggregate function | Remigiusz Sokolowski | 07:57 | 
| ENUM Type | J. Kinsley | 09:01 | 
| Re: [SQL] DEFAULT TEXT 'now' in create table | Remigiusz Sokolowski | 11:12 | 
| Re: [SQL] index on aggregate function | jose' soares | 12:07 | 
| Re: [SQL] index on aggregate function | Remigiusz Sokolowski | 13:50 | 
| [SQL] difficulties combining nextval and rules | Justin Subert | 20:35 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] Booleans and Casting | jose' soares | 08:51 | 
| creating text files out of a database | Martin Möderndorfer | 11:02 | 
| Creating Textfiles out of tables | Martin Möderndorfer | 13:05 | 
| Re: [GENERAL] Creating Textfiles out of tables | jose' soares | 13:44 | 
| Creating Textfiles out of tables II | Martin Möderndorfer | 17:50 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [ADMIN] Creating Textfiles out of tables | Terry Mackintosh | 02:29 | 
| Question about SQL FUnction | Martin Möderndorfer | 19:03 | 
| [No subject] | Atika | 20:49 | 
| INSERT query !! | Atika | 21:02 | 
| INSERT query (using insert from a Java application, concerning String input) | Atika | 21:10 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] INSERT query (using insert from a Java application, concerning String input) | Brett W. McCoy | 00:22 | 
| Re: [SQL] INSERT query (using insert from a Java application, concerning String input) | Peter Garner | 00:46 | 
| Re: [SQL] Question about SQL FUnction | David Martinez Cuevas | 00:52 | 
| Re: [SQL] Question about SQL FUnction | Anatoly K. Lasareff | 07:37 | 
| Thread | Author | Time | 
|---|---|---|
| Insert a long text | Ghita Voda | 10:00 | 
| Re: [SQL] Insert a long text | Brian Baquiran | 12:03 | 
| Re: [SQL] Insert a long text | Anatoly K. Lasareff | 12:25 | 
| SQL-Query 2 get primary key | Marc Grimme | 13:22 | 
| Re: [SQL] Insert a long text | Frank Barknecht | 14:28 | 
| [SQL] Troubles whith using aggregat inside function. | Alexey Pikunov | 14:36 | 
| problem with function in plpgsql | Eric BASIER | 15:08 | 
| Re: [SQL] SQL-Query 2 get primary key | jose' soares | 16:32 | 
| Re: [SQL] SQL-Query 2 get primary key | Marc Grimme | 17:09 | 
| Triggers to create Tables | Martin Möderndorfer | 17:37 | 
| RE: [SQL] Insert a long text | Jackson, DeJuan | 18:33 | 
| Thread | Author | Time | 
|---|---|---|
| [No subject] | Eric Lee Green | 03:18 | 
| Re: [SQL] SQL-Query 2 get primary key | D'Arcy J.M. Cain | 04:07 | 
| psql: how to find out type of an index (hash, btree, ...)? | Michael Olivier | 05:04 | 
| questions on interpreting the output of explain | Michael Olivier | 05:07 | 
| Re: [SQL] SQL-Query 2 get primary key | Michael Olivier | 05:19 | 
| Re: [SQL] questions on interpreting the output of explain | Bruce Momjian | 06:06 | 
| Re: [HACKERS] Re: [SQL] SQL-Query 2 get primary key | Oliver Elphick | 08:32 | 
| Re: [SQL] problem with function in plpgsql | Anatoly K. Lasareff | 11:09 | 
| Re: [SQL] Triggers to create Tables | Anatoly K. Lasareff | 11:20 | 
| Re: [SQL] Triggers to create Tables | Martin Möderndorfer | 11:33 | 
| Re: [HACKERS] Re: [SQL] SQL-Query 2 get primary key | Hannu Krosing | 12:39 | 
| Re: [HACKERS] Re: [SQL] SQL-Query 2 get primary key | D'Arcy J.M. Cain | 13:18 | 
| Re: [HACKERS] Re: [SQL] SQL-Query 2 get primary key | Thomas G. Lockhart | 16:17 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] INSERT query (using insert from a Java application, concerning String input) | Herouth Maoz | 15:45 | 
| triggers (refint) | Werner Reisberger | 17:38 | 
| Re: questions on interpreting the output of explain | Tom Lane | 20:36 | 
| Re: [SQL] Re: questions on interpreting the output of explain\ | Bruce Momjian | 21:23 | 
| HAVING confusion.. | George Henry C. Daswani | 22:33 | 
| SQL query _slow_ | Gregg Berkholtz | 23:02 | 
| Re: [SQL] SQL query _slow_ | Bruce Momjian | 23:52 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] SQL query _slow_ | Gregg Berkholtz | 00:01 | 
| Re: [SQL] SQL query _slow_ | Bruce Momjian | 01:07 | 
| Re: [SQL] SQL query _slow_ | Gregg Berkholtz | 06:29 | 
| Re: [SQL] SQL query _slow_ | Bruce Momjian | 06:45 | 
| Re: [SQL] HAVING confusion.. | Oliver Elphick | 07:07 | 
| Groups | Remigiusz Sokolowski | 10:02 | 
| Re: [SQL] Insert a long text | Frank Barknecht | 11:37 | 
| Re: [SQL] SQL-Query 2 get primary key | jose' soares | 13:23 | 
| questions on features | pierre | 14:46 | 
| Re: HAVING confusion.. | Tom Lane | 15:35 | 
| Re: [SQL] SQL query _slow_ | Tom Lane | 15:42 | 
| Re: your mail | Roderick A. Anderson | 18:17 | 
| Re: [SQL] questions on features | Bruce Momjian | 19:27 | 
| Problem with HAVING clause | Mauricio Carvalho de Oliveira | 19:49 | 
| Problem with HAVING clause | Mauricio Carvalho de Oliveira | 19:53 | 
| Stepping/Paging Through Rows | Dan Parker | 21:06 | 
| Re: [SQL] questions on features | Dave Inskeep | 22:43 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] Stepping/Paging Through Rows | Brett W. McCoy | 00:08 | 
| subscribe | Chuang Fang-sheng | 00:17 | 
| 8K limit ... | Edmund | 07:24 | 
| inet type SELECT ... | The Hermit Hacker | 15:01 | 
| RE: [SQL] inet type SELECT ... | Jackson, DeJuan | 17:13 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] 8K limit ... | Ken Mort | 02:58 | 
| PL/Perl? | Dr. Nisai Wanakule | 17:03 |