Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Simmultanous Connections | Jude Weaver | 09:21 |
| Re: [SQL] query to do a backward 'skip', possible with (index) optimization ? | Tom Lane | 15:17 |
| Re: [SQL] query to do a backward 'skip', possible with (index) optimization ? | Alain TESIO | 19:14 |
| problems creating functions, triggers, and rules | Werner Fraga | 20:54 |
| query to do a backward 'skip', possible with (index) optimization ? | Albert Loo | 21:15 |
| problems creating functions and triggers | Werner Fraga | 22:32 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] problems creating functions and triggers | Tom Lane | 00:40 |
| Re: [SQL] createdb -D xxxx not working | Peter Eisentraut | 13:26 |
| Re: [SQL] createdb -D xxxx not working | Tom Lane | 15:14 |
| best strategy doing a large copy and using indexes | Dirk Lutzebaeck | 15:21 |
| Re: [HACKERS] Re: [SQL] createdb -D xxxx not working | Thomas Lockhart | 15:57 |
| Re: [SQL] best strategy doing a large copy and using indexes | Tom Lane | 16:14 |
| Problem with array syntax | Web Manager | 20:29 |
| Problem with array syntax | Web Manager | 21:00 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] Re: [SQL] createdb -D xxxx not working | Peter Eisentraut | 03:30 |
| mdopen: couldn't open | Prakash | 07:56 |
| simple question | Thomas Leavitt | 10:10 |
| function parameters/output values | Thomas Leavitt | 10:29 |
| stats on select | admin | 12:12 |
| help. | Alexandr Listopad | 13:44 |
| Re: [HACKERS] Re: [SQL] createdb -D xxxx not working | Thomas Lockhart | 16:26 |
| Not Allowing Users to Create Tables | Neil Cameron | 17:19 |
| Rules, triggers, ??? - What is the best way to enforce data-valid ation tests? | Greg Youngblood | 17:52 |
| Re: [SQL] query to do a backward 'skip' ...thanks, it's working. | Albert Loo | 20:53 |
| proposal -- Re: [HACKERS] Re: [SQL] createdb -D xxxx not working | Peter Eisentraut | 23:29 |
| Re: [SQL] function parameters/output values | Peter Eisentraut | 23:29 |
| Thread | Author | Time |
|---|---|---|
| RE: [SQL] function parameters/output values | Thomas Leavitt | 00:40 |
| Getting environment variables? | mpg4 | 02:25 |
| foreign key implementation | Pausas Fuentes, Jaume | 11:14 |
| Re: [SQL] foreign key implementation | Oliver Elphick | 21:21 |
| Thread | Author | Time |
|---|---|---|
| key set delete query | Michael McCarthy | 08:09 |
| Optimizing ORDER BY with indexes? | Dirk Lutzebaeck | 08:41 |
| Re: [SQL] Optimizing ORDER BY with indexes? | Dirk Lutzebaeck | 09:31 |
| Re: [SQL] Optimizing ORDER BY with indexes? | Dirk Lutzebaeck | 09:34 |
| Re: [SQL] key set delete query | Tom Lane | 15:02 |
| Re: [SQL] Optimizing ORDER BY with indexes? | Tom Lane | 15:18 |
| Re: [SQL] Optimizing ORDER BY with indexes? | Bruce Momjian | 16:37 |
| numeric question.. | Mitch Vincent | 16:56 |
| Aggregates and Views | Mark Volpe | 21:16 |
| Re: Aggregates & Views | Mark Volpe | 21:19 |
| Re: [SQL] numeric question.. | Tom Lane | 21:27 |
| Re: [SQL] numeric question.. | Mitch Vincent | 21:39 |
| Re: [SQL] Aggregates and Views | Tom Lane | 22:26 |
| Re: [SQL] numeric question.. | Tom Lane | 23:09 |
| Thread | Author | Time |
|---|---|---|
| (no subject) 📎 | Michal Frajt | 11:19 |
| Thread | Author | Time |
|---|---|---|
| Patches for various NUMERIC bugs posted on pgsql-patches | Tom Lane | 01:07 |
| [No subject] | Egon Rothenberger | 12:51 |
| attribute level rules not supported? | Marc Tardif | 13:20 |
| Re: [SQL] Getting environment variables? | Peter Eisentraut | 17:13 |
| Re: [SQL] numeric question.. | Peter Eisentraut | 17:14 |
| Re: [SQL] numeric question.. | Tom Lane | 17:35 |
| Thread | Author | Time |
|---|---|---|
| Antw: [SQL] attribute level rules not supported? | Gerhard Dieringer | 08:12 |
| index usage ... strange !? | Marten Feldtmann | 19:29 |
| Re: [SQL] index usage ... strange !? | Tom Lane | 22:26 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] char(19) to varchar(32) | Marc Tardif | 10:56 |
| Bug in CEIL? | Mark Alliban | 12:13 |
| Bug in CEIL? | Mark Alliban | 13:26 |
| Re: [SQL] char(19) to varchar(32) | Jose Soares | 14:01 |
| Re: [SQL] Bug in CEIL? | Nikolay Mijaylov | 14:05 |
| Re: [SQL] Bug in CEIL? | Tom Lane | 15:02 |
| Re: [SQL] Foreign Keys, Triggers and such | Marc Tardif | 15:40 |
| Re: [SQL] char(19) to varchar(32) | Tom Lane | 15:41 |
| (no subject) | Sevo Stille | 16:32 |
| Re: [GENERAL] Re: [SQL] Bug in CEIL? | Bruce Momjian | 17:07 |
| Re: [SQL] char(19) to varchar(32) | Tom Lane | 17:24 |
| Re: [SQL] index usage ... strange !? | Marten Feldtmann | 17:46 |
| Re: [SQL] index usage ... strange !? | Tom Lane | 18:07 |
| Re: [SQL] char(19) to varchar(32) | Tom Lane | 18:11 |
| Foreign Keys, Triggers and such | Daniel Spratlen | 19:16 |
| Thread | Author | Time |
|---|---|---|
| null and integer field | Hamid Khoshnevis | 00:57 |
| Re: [SQL] null and integer field | Tom Lane | 02:20 |
| round() and || | Graeme Merrall | 02:42 |
| Re: [SQL] round() and || | Tom Lane | 06:34 |
| inserting values into arrays | T.I.P. | 08:16 |
| [SQL] inserting values into arrays | T.I.P. | 09:19 |
| inserting values into arrays | Kovacs Zoltan | 09:27 |
| Help for performance | dLux | 11:54 |
| Re: [SQL] crypt in Postgres? | Peter Eisentraut | 11:58 |
| inserting values into arrays | Kovacs Zoltan | 12:30 |
| sql performance help needed | dLux | 12:56 |
| inserting values into arrays | T.I.P. | 13:07 |
| insert values into arrays | Kovacs Zoltan Sandor | 13:35 |
| insert values into arrays | Kovacs Zoltan Sandor | 13:40 |
| crypt in Postgres? | Emils Klotins | 13:47 |
| Geometric types in SELECT? | mpg4 | 13:52 |
| Re: [SQL] crypt in Postgres? | D'Arcy J.M. Cain | 13:53 |
| Re: [SQL] crypt in Postgres? | Peter Mount | 14:39 |
| inserting values into arrays | Thomas Lockhart | 15:24 |
| Re: [SQL] insert values into arrays | Peter Eisentraut | 21:55 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Geometric types in SELECT? | Tom Lane | 01:22 |
| (no subject) | david tzuriel | 12:25 |
| [No subject] | 13:46 | |
| Problem with large tuples. | Patrik Kudo | 15:05 |
| Duplicate tuples with unique index | Patrik Kudo | 15:09 |
| Re: [SQL] Problem with large tuples. | Dirk Lutzebaeck | 15:38 |
| Re: [SQL] Duplicate tuples with unique index | Tom Lane | 16:23 |
| psql - odbc - bde - data dictionary | Tibor Laszlo | 16:53 |
| DISTINCT and aggregates | Brook Milligan | 17:00 |
| [No subject] | Tibor Laszlo | 17:59 |
| Re: [SQL] DISTINCT and aggregates | Tom Lane | 18:38 |
| Re: [SQL] SQL Things | De Moudt Walter | 23:50 |
| Thread | Author | Time |
|---|---|---|
| SQL Things | Neil Cameron | 01:14 |
| More efficient DELETE ... ? | The Hermit Hacker | 17:20 |
| Re: [SQL] More efficient DELETE ... ? | Bruce Momjian | 17:56 |
| geo_distance radius question | Mark Stosberg | 18:06 |
| Re: [SQL] More efficient DELETE ... ? | Tom Lane | 18:07 |
| Repost: restore from dump problem - query buffer full | Web Manager | 18:28 |
| Re: [SQL] More efficient DELETE ... ? | Bruce Momjian | 19:37 |
| how many inserts in one transaction? | gav | 21:15 |
| Re: [SQL] More efficient DELETE ... ? | Tom Lane | 21:43 |
| Re: [SQL] More efficient DELETE ... ? | The Hermit Hacker | 23:18 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] SQL Things | Peter Eisentraut | 01:29 |
| Re: [SQL] how many inserts in one transaction? | Christopher Sawtell | 07:21 |
| (no subject) | Dmitry A. Alyekhin | 08:53 |
| pqReadData... | gav | 13:44 |
| Re: [SQL] pqReadData... | Tom Lane | 16:18 |
| Join-Question | Dorthe Luebbert | 18:38 |
| Re: [SQL] Join-Question | Borek.Lupomesky | 22:38 |
| Thread | Author | Time |
|---|---|---|
| can I index a field of type "point"? | Mark Stosberg | 00:36 |
| Re: [SQL] can I index a field of type "point"? | Gene Selkov, Jr. | 02:24 |
| Question about COPY command | Mercury He | 04:11 |
| Re: [SQL] Duplicate tuples with unique index | Patrik Kudo | 10:00 |
| Re: [SQL] Question about COPY command | Christopher Sawtell | 10:48 |
| Re: [SQL] Blobs | Mathijs Brands | 15:54 |
| Backend crash | Mark Volpe | 16:14 |
| Fwd: Re: [SQL] Blobs | Compte utilisateur Sultan-advl | 16:16 |
| Backend crash | Mark Volpe | 16:25 |
| Re: [SQL] Backend crash | Tom Lane | 17:16 |
| Re: [SQL] Backend crash | Bruce Momjian | 17:17 |
| Re: [SQL] Backend crash | Mark Volpe | 18:58 |
| Re: [SQL] Backend crash | Bruce Momjian | 19:08 |
| Re: [SQL] Join-Question | De Moudt Walter | 20:09 |
| Re: [SQL] Backend crash | Alain TESIO | 20:58 |
| Re: [SQL] Backend crash | Bruce Momjian | 22:31 |
| Blobs | Neil Cameron | 22:33 |
| Re: [SQL] Blobs | Peter Eisentraut | 23:49 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Problem with large tuples. | Palle Girgensohn | 00:26 |
| Re: [SQL] Duplicate tuples with unique index | Palle Girgensohn | 00:31 |
| Re: [SQL] Duplicate tuples with unique index | Bruce Momjian | 00:33 |
| Re: [SQL] Duplicate tuples with unique index | Palle Girgensohn | 00:37 |
| Re: [SQL] Duplicate tuples with unique index | Tom Lane | 05:38 |
| Re: [SQL] Duplicate tuples with unique index | Bruce Momjian | 05:43 |
| dumping groups and users | Kovacs Zoltan Sandor | 10:57 |
| Re: [SQL] dumping groups and users | Kovacs Zoltan Sandor | 12:28 |
| Re: [SQL] Duplicate tuples with unique index | Palle Girgensohn | 15:07 |
| Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace | Peter Eisentraut | 18:34 |
| Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace | Peter Eisentraut | 18:34 |
| Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace | Tom Lane | 18:40 |
| Help understanding how indexes are used by the query optimizer | Peter Bojanic | 20:28 |