Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) 📎 | Hiroshi Inoue | 00:26 |
| RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) | Hiroshi Inoue | 04:36 |
| Re: [SQL] parser :parse error | Frederic boucher | 05:28 |
| Is this a bug? | Imtiaz. S. M | 05:43 |
| Re: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) | Stoyan Genov | 11:15 |
| HAVING in EXISTS-clause ... | marten | 11:26 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] HAVING in EXISTS-clause ... | Stuart Rison | 11:03 |
| PostgreSQL Compliance | Sladewski, Joseph | 16:17 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] HAVING in EXISTS-clause ... | Tom Lane | 04:00 |
| [No subject] | Roomi | 04:16 |
| Does postgres have something like MySQL's DESCRIBE? | Mark Stosberg | 19:54 |
| Nested Views take forever | Zot O'Connor | 23:10 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Nested Views take forever | Tom Lane | 00:34 |
| Re: [SQL] Nested Views take forever | marten | 07:42 |
| Re: [SQL] HAVING in EXISTS-clause ... | marten | 07:55 |
| Rules and referential integrity | <Miguel Sofer | 15:13 |
| Rules and referential integrity | <Miguel Sofer | 15:13 |
| Re: [SQL] Rules and referential integrity | Jan Wieck | 16:13 |
| Trying to move a 6.1 database to 6.5 | Klein, Robert | 16:37 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] HAVING in EXISTS-clause ... | Jan Wieck | 03:17 |
| Re: [SQL] parser :parse error | Tom Lane | 07:50 |
| Porting MySQL's DESCRIBE and ENUM features | Mark Stosberg | 16:33 |
| Re: [SQL] Porting MySQL's DESCRIBE and ENUM features | Peter Eisentraut | 17:04 |
| Re: [SQL] Porting MySQL's DESCRIBE and ENUM features | Tom Lane | 19:41 |
| national characters in plpgsql | Artur Kokoszka | 22:30 |
| Thread | Author | Time |
|---|---|---|
| Verificate values in other table? | juman | 10:25 |
| Re: [SQL] Verificate values in other table? | Peter Eisentraut | 18:44 |
| Arrays of composites, bug or usage? | Chaotic Inceptions | 21:03 |
| Thread | Author | Time |
|---|---|---|
| how can tell if a column is a primary key? | Mark Stosberg | 04:57 |
| Re: [SQL] Verificate values in other table? | Tom Lane | 05:18 |
| Re: [SQL] how can tell if a column is a primary key? | Gary MacMinn | 05:28 |
| [SQL] Handling NULL Dates | Gary MacMinn | 05:43 |
| Re: [SQL] nulls and datetime | Tom Lane | 06:10 |
| Re: [SQL] Trying to move a 6.1 database to 6.5 | Stoyan Genov | 08:52 |
| large objects over network connection | oskar stuffer | 11:49 |
| Re: [SQL] how can tell if a column is a primary key? | D'Arcy J.M. Cain | 12:34 |
| Re: [SQL] how can tell if a column is a primary key? | Tom Lane | 15:24 |
| Re: [SQL] nulls and datetime | Thomas Lockhart | 15:29 |
| Re: [SQL] nulls and datetime | Tom Lane | 15:41 |
| Re: [SQL] nulls and datetime | Thomas Lockhart | 16:11 |
| NULL | Goran Thyni | 19:07 |
| Re: [SQL] NULL | Bruce Momjian | 19:23 |
| Re: [SQL] NULL | Bruce Stephens | 19:57 |
| Re: [SQL] how can tell if a column is a primary key? | Howie | 22:37 |
| Re: [SQL] Verificate values in other table? | Jan Wieck | 23:36 |
| Re: [SQL] NULL | Jan Wieck | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] NULL | Tom Lane | 00:50 |
| Re: [SQL] how can tell if a column is a primary key? | D'Arcy J.M. Cain | 03:19 |
| permanent deleting | Roomi | 07:26 |
| Re: [SQL] NULL | jose soares | 13:37 |
| Re: [SQL] NULL | Jan Wieck | 14:16 |
| ODBC/Openlink/Delphi | maxsbox | 18:17 |
| Updating datetime fields with NULL values | Gary MacMinn | 22:28 |
| Re: [SQL] Updating datetime fields with NULL values | John Ziniti | 22:58 |
| Re: [SQL] zombie postmasters | [email protected] | 23:00 |
| zombie postmasters | Hamid Khoshnevis | 23:06 |
| Re: [SQL] zombie postmasters | Chad Miller | 23:21 |
| Re: [SQL] zombie postmasters | Stephen J Lombardo | 23:39 |
| Thread | Author | Time |
|---|---|---|
| Threaded PGSQL access (was Re: [SQL] zombie postmasters) | Mathijs Brands | 00:10 |
| Re: [SQL] zombie postmasters | Tom Lane | 05:05 |
| Re: [SQL] nulls and datetime | Gary MacMinn | 05:16 |
| Re: [SQL] zombie postmasters | Jan Wieck | 08:26 |
| Re: [SQL] zombie postmasters | Zalman Stern | 08:44 |
| Re: [SQL] ODBC/Openlink/Delphi | jose soares | 13:34 |
| Building "ON DELETE" rules to keep the referential integrity of a database | Stoyan Genov | 13:42 |
| Re: [SQL] NULL | jose soares | 13:56 |
| Re: [SQL] NULL | Jan Wieck | 18:31 |
| Thread | Author | Time |
|---|---|---|
| Antw: [SQL] Building "ON DELETE" rules to keep the referential integrity of a database | Gerhard Dieringer | 08:01 |
| please help me on pl/pgsql triggers (fwd) | Mario Olimpio de Menezes | 09:49 |
| Can't create an index on NUMERIC(x,y) | secret | 16:08 |
| Re: [SQL] Can't create an index on NUMERIC(x,y) | Jan Wieck | 22:18 |
| sql question: min remapped value | Douglas Nichols | 23:26 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] sql question: min remapped value | Tom Lane | 00:43 |
| Backend message type 0x45 arrived while idle | Haris Susanto | 07:24 |
| Deleting rows with time 55 minutes less than max time | Imtiaz. S. M | 11:07 |
| selecting from indexes | Tim Joyce | 14:22 |
| Re: [SQL] selecting from indexes | Tom Lane | 15:21 |
| Re: [SQL] selecting from indexes | Tim Joyce | 16:25 |
| Re: [SQL] selecting from indexes | Tom Lane | 17:23 |
| Re: [SQL] selecting from indexes | Tim Joyce | 20:06 |
| Re: [SQL] selecting from indexes | Tom Lane | 22:18 |
| Re: [SQL] selecting from indexes | Tim Joyce | 22:55 |
| Thread | Author | Time |
|---|---|---|
| Deleting indexes before vacuum? | Matthew Hagerty | 01:03 |
| Re: [SQL] Deleting indexes before vacuum? | Tom Lane | 06:14 |
| Re: [SQL] Deleting indexes before vacuum? | Oleg Bartunov | 07:57 |
| RE: [SQL] Deleting indexes before vacuum? | Pham, Thinh | 15:29 |
| Re: [SQL] Deleting indexes before vacuum? | Tom Lane | 17:01 |
| Re: [SQL] Deleting indexes before vacuum? | Oleg Bartunov | 18:57 |
| Re: [SQL] Deleting indexes before vacuum? | Oleg Bartunov | 19:44 |
| Thread | Author | Time |
|---|---|---|
| How to optimize this simple query :-( | marten | 11:12 |
| Thread | Author | Time |
|---|---|---|
| RE: [SQL] Deleting indexes before vacuum? | Hiroshi Inoue | 01:53 |
| Re: [SQL] Deleting indexes before vacuum? | Tom Lane | 03:18 |
| Parameterised ADOCommand object Vs Exec SQL | CHAITANYANC | 04:24 |
| RE: [SQL] Deleting indexes before vacuum? | Hiroshi Inoue | 05:52 |
| unsubscribe | Drinks, Ivan - ITD | 17:07 |
| Thread | Author | Time |
|---|---|---|
| soporte | Liliana Pineda | 11:06 |
| [No subject] | Stefano Lixi | 18:49 |
| Re: [SQL] Store multi-media with Postgres? | Mathijs Brands | 21:05 |
| Store multi-media with Postgres? | Duncan Kinder | 21:43 |
| [No subject] | Christopher Sawtell | 21:56 |
| Thread | Author | Time |
|---|---|---|
| Info on SQL Parsing required | CHAITANYANC | 03:39 |
| Re: [SQL] Info on SQL Parsing required | neko | 10:22 |
| Re: [SQL] NULL | Bruce Stephens | 15:08 |
| Re: pgsql-sql-digest V1 #422 | maxsbox | 18:14 |
| Thread | Author | Time |
|---|---|---|
| recursive 📎 | Julien Cadiou | 01:09 |
| recursion 📎 | Julien Cadiou | 01:15 |
| very slow connection | Szucs Laszlo | 12:21 |
| pqReadData() error | Dipankar Chakrabarti | 12:23 |
| Re: [SQL] pqReadData() error | Jan Wieck | 12:37 |
| Re: [SQL] Re: pgsql-sql-digest V1 #422 | Fabrice Scemama | 22:03 |
| Re: [SQL] Info on SQL Parsing required | Peter Eisentraut | 23:43 |
| Thread | Author | Time |
|---|---|---|
| Re: pgsql-sql-digest V1 #424 | Dipankar Chakrabarti | 05:42 |
| Backend dies (6.5.3-1) on SELECT from 6 row table | Emils Klotins | 14:35 |
| national character once again | Artur Kokoszka | 15:52 |
| Re: [SQL] Backend dies (6.5.3-1) on SELECT from 6 row table | Tom Lane | 16:20 |
| DISTINCT & COUNT | Moray McConnachie | 16:35 |
| 6.5.3 - backend closes if wrong parameters to NULLIF, CASE | Emils Klotins | 17:48 |
| Re: [SQL] DISTINCT & COUNT | Stuart Rison | 18:00 |
| Re: [SQL] 6.5.3 - backend closes if wrong parameters to NULLIF, CASE | Tom Lane | 18:06 |
| Re: [SQL] DISTINCT & COUNT | Tom Lane | 18:19 |
| TEST MESSAGE - PLEASE IGNORE | Zodiac Speaker | 19:56 |
| Re: [SQL] national character once again | Jan Wieck | 23:26 |
| Thread | Author | Time |
|---|---|---|
| Numeric format for currency | Rich Shepard | 01:23 |
| Usage of index in "ORDER BY" operations | Matthias Ackermann | 15:32 |
| Re: [SQL] Usage of index in "ORDER BY" operations | Tom Lane | 17:18 |
| Design Question | Andy Lewis | 18:25 |
| Re: [SQL] Design Question | Rich Shepard | 18:41 |
| Re: [SQL] Design Question | Andy Lewis | 18:49 |
| Re: [SQL] Design Question 📎 | Julien Cadiou | 22:50 |
| recusrion | Julien Cadiou | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Design Question | De Moudt Walter | 19:23 |
| Re: [SQL] Design Question | Andy Lewis | 20:56 |
| Thread | Author | Time |
|---|---|---|
| create view on union -- workaround? | Brian Haney | 08:13 |
| Your query ... | S S Mani | 09:14 |
| Your Query... | S S Mani | 09:28 |
| Re: [SQL] recusrion | Stoyan Genov | 09:38 |
| [No subject] | Alexey V. Meledin | 17:00 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] NULL | Bruce Momjian | 03:13 |
| unixtime -> datetime | Thilo Mezger | 08:07 |
| found a way to update a table with data from another one | Patrick JACQUOT | 12:07 |
| Re: [SQL] found a way to update a table with data from another one | Tom Lane | 15:22 |
| Re: [SQL] NULL | Ross J. Reedstrom | 16:12 |
| Re: [SQL] NULL | Peter Eisentraut | 16:27 |
| Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?) | Emils Klotins | 16:43 |
| Re: [SQL] NULL | Ross J. Reedstrom | 17:48 |
| Re: [SQL] NULL | Tom Lane | 18:07 |
| Re: [SQL] NULL | Ross J. Reedstrom | 19:09 |
| date function questions... | Zsolt Varga | 19:15 |
| Re: [SQL] Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?) | Oliver Elphick | 22:04 |
| Re: [SQL] Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?) | Tom Lane | 22:56 |
| slow sort for simple join | Mark Kirkwood | 23:14 |
| Thread | Author | Time |
|---|---|---|
| RestrictionClauseSelectivity | Frank Bax | 01:35 |
| RestrictionClauseSelectivity | Frank Bax | 02:45 |
| Re: [SQL] RestrictionClauseSelectivity | Bruce Momjian | 03:07 |
| Many booleans | Chris Griffin | 03:26 |
| VACUUM PROBLEM | Dipankar Chakrabarti | 05:40 |
| Antw: [SQL] Many booleans | Gerhard Dieringer | 08:34 |
| Re: [SQL] found a way to update a table with data from another one | Patrick JACQUOT | 09:32 |
| Partial Search | pez | 14:07 |
| Antw: [SQL] Partial Search | Gerhard Dieringer | 14:50 |
| do queries from strings in pgplsql | Virgilio Sanz | 16:04 |
| Re: [SQL] VACUUM PROBLEM | Tom Lane | 16:19 |
| Re: [SQL] Partial Search | Wim Ceulemans | 17:03 |
| Except operation | Satyajeet Seth | 18:40 |
| arrays | Marcin Mazurek - Multinet SA - Poznan | 22:34 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] arrays | Karel Zak - Zakkr | 10:20 |
| Re: [SQL] arrays | Marcin Mazurek - Multinet SA - Poznan | 11:01 |
| Re: [SQL] arrays | Karel Zak - Zakkr | 11:11 |
| PL/PgSQL: selects into strings | Virgilio Sanz | 15:16 |
| Logical and for int4? | Chris Griffin | 18:09 |
| How to avoid "Out of memory" using aggregate functions? | Mark Dalphin | 19:30 |
| PHP/Postgres dieing in random but consistent place. | Zot O'Connor | 20:18 |
| A search SQL query | Tom Techoueyres | 20:51 |
| RE: [SQL] A search SQL query | Tom Techoueyres | 21:38 |
| Re: [SQL] A search SQL query | kaiq | 22:27 |
| SQLState | Rini Dutta | 22:52 |
| RE: [SQL] A search SQL query | kaiq | 22:53 |
| Re: [SQL] A search SQL query | Tom Lane | 23:05 |
| Re: [SQL] How to avoid "Out of memory" using aggregate functions? | Tom Lane | 23:32 |