Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Surprising sequence scan when function call used | Will Fitzgerald | 17:26 |
| How to call a shell command in rule | Jie Liang | 17:44 |
| Add Constraint | Sivagami . | 17:51 |
| Re: Alternate Database Locations | Roderick A. Anderson | 19:04 |
| Re: Alternate Database Locations | Brian C. Doyle | 19:20 |
| Re: Problem whith Stored queries | Jie Liang | 23:07 |
| Thread | Author | Time |
|---|---|---|
| renaming columns... danger? | Michael Teter | 05:01 |
| Re: HELP! ... pg_locale ??? | Tom Lane | 05:33 |
| Re: HELP! ... pg_locale ??? | Tom Lane | 05:33 |
| except on nulls? | Daniel Kalchev | 06:02 |
| Re: [SQL] renaming columns... danger? | Grant Finnemore | 08:30 |
| Re: [SQL] renaming columns... danger? | Grant Finnemore | 08:30 |
| Re: renaming columns... danger? | Emils Klotins | 09:00 |
| Re: renaming columns... danger? | Emils Klotins | 09:00 |
| benchmarks | Clayton C. | 11:36 |
| Re: except on nulls? | Tom Lane | 14:39 |
| Re: except on nulls? | Tom Lane | 14:39 |
| <database>.<table_name> | Sivagami . | 21:03 |
| Thread | Author | Time |
|---|---|---|
| Re: benchmarks | KuroiNeko | 03:54 |
| Re: benchmarks | Josh Berkus | 06:24 |
| Re: benchmarks | KuroiNeko | 21:00 |
| Thread | Author | Time |
|---|---|---|
| RE: benchmarks 📎 | Edmar Wiggers | 04:00 |
| Re: benchmarks | [email protected] | 14:53 |
| Thread | Author | Time |
|---|---|---|
| pgsql-sql list should now work again ... | The Hermit Hacker | 00:37 |
| select with function per row | Marcin Mazurek | 09:02 |
| [No subject] | Lengyel Ferenc | 12:36 |
| Large Object dump ? | Alessandro Rossi | 12:42 |
| RE: | Schlobohm, Jack | 12:52 |
| Re: | Yury Don | 12:55 |
| Synonyms | Carl Shelbourne | 13:17 |
| Re: Large Object dump ? | Alessandro Rossi | 14:11 |
| [No subject] | Petr Jezek | 14:20 |
| Re: | Philip Warner | 14:31 |
| unsubscribe | Vadim Govorov | 14:39 |
| Re: Large Object dump ? | [email protected] | 15:19 |
| unsubscribe 📎 | Schlobohm, Jack | 15:28 |
| fetching rows | Nikolay Mijaylov | 16:27 |
| Re: Synonyms | Peter Eisentraut | 16:44 |
| Re: fetching rows | K Parker | 18:58 |
| Re: fetching rows | Jeff Hoffmann | 19:02 |
| Re: fetching rows | Martin Christensen | 22:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Synonyms | hubert depesz lubaczewski | 07:16 |
| PLPGSQL examples | Kovacs Zoltan Sandor | 11:30 |
| Re: fetching rows | Decio Fonini | 12:54 |
| Need help! parse erro | Najm Hashmi | 15:39 |
| INSERT [IGNORE] INTO TABLE | Petr Jezek | 16:05 |
| Re: Need info: pl/pgsql performance | Kovacs Zoltan Sandor | 16:20 |
| RE: INSERT [IGNORE] INTO TABLE | Edmar Wiggers | 16:31 |
| RE: INSERT [IGNORE] INTO TABLE | Petr Jezek | 17:04 |
| RE: INSERT [IGNORE] INTO TABLE | Edmar Wiggers | 17:19 |
| RE: INSERT [IGNORE] INTO TABLE | K Parker | 19:42 |
| Problem with coalesce.. | George Henry C. Daswani | 21:52 |
| Thread | Author | Time |
|---|---|---|
| How To Increment A Field Value By Function | cn | 03:17 |
| Outer Joins | Marc Rohloff | 08:02 |
| Re(2): Large Object dump ? | pgsql-sql | 09:34 |
| Re: Re(2): Large Object dump ? | Karel Zak | 10:18 |
| Re: Outer Joins | Grant Finnemore | 11:56 |
| Re(2): Re(2): Large Object dump ? | pgsql-sql | 13:44 |
| Help! Storing trees in Postgres | Sergei O . Naumov | 14:02 |
| Re: Problem with coalesce.. | Continuing Technical Education | 15:01 |
| Re: Problem with coalesce.. | Stephan Szabo | 16:50 |
| Re: Outer Joins | Josh Berkus | 17:01 |
| Re: INSERT [IGNORE] INTO TABLE | Najm Hashmi | 17:56 |
| Thread | Author | Time |
|---|---|---|
| Timespan / interval calculations? | Petter Reinholdtsen | 02:13 |
| Re: INSERT [IGNORE] INTO TABLE | Bruce Momjian | 03:38 |
| Re: Outer Joins | Marc Rohloff | 07:11 |
| Antw: Outer Joins | Gerhard Dieringer | 07:55 |
| Re: [SQL] Re: Problem with coalesce.. | Tom Lane | 08:09 |
| Re: Outer Joins | Josh Berkus | 16:37 |
| Re: Outer Joins | Josh Berkus | 16:55 |
| Re: Re(2): Re(2): Large Object dump ? | Tom Lane | 17:17 |
| PL/PGSQL beginning is hard.... | Bruno Boettcher | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: PL/PGSQL beginning is hard.... | Stephan Szabo | 00:49 |
| user defined functions in Java ? | Umashankar Kotturu | 03:32 |
| Connecting to Postgres from Windows | Umashankar Kotturu | 03:50 |
| Urgent trigger problem. | Carolyn Lu Wong | 11:41 |
| Subqueries in from clause | Pierre Habraken | 17:36 |
| Re: Subqueries in from clause | Tom Lane | 17:48 |
| need help urgent | Jie Liang | 19:35 |
| Re: user defined functions in Java ? | Peter Eisentraut | 20:02 |
| RE: [SQL] really need help 📎 | Schlobohm, Jack | 21:45 |
| Re: Connecting to Postgres from Windows | Indraneel Majumdar | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Meaning of "REMINDER from pgsql..." | [email protected] | 15:30 |
| Re: Help! Storing trees in Postgres | kovacsz | 20:09 |
| PLPGSQL performance | kovacsz | 20:16 |
| Thread | Author | Time |
|---|---|---|
| Question about ordering views | hubert depesz lubaczewski | 11:44 |
| Time penalty on VIEWS on VIEWS | hubert depesz lubaczewski | 11:50 |
| Help with GROUP BY | Jean-Christophe Boggio | 18:03 |
| Conditional SQL query | Indraneel Majumdar | 19:03 |
| Re: Conditional SQL query | Cristóvão B. B. Dalla Costa | 21:46 |
| Re: Conditional SQL query | Cristóvão B. B. Dalla Costa | 22:44 |
| Thread | Author | Time |
|---|---|---|
| Returning Recordsets from Stored-procs | Marc Rohloff | 08:15 |
| Re: Conditional SQL query | Indraneel Majumdar | 09:07 |
| Re: Returning Recordsets from Stored-procs | Grant Finnemore | 09:39 |
| Re: Conditional SQL query | Indraneel Majumdar | 10:00 |
| Re: Conditional SQL query | Indraneel Majumdar | 10:23 |
| Re: Returning Recordsets from Stored-procs | Andreas Tille | 11:10 |
| Timing trouble with GROUP BY PostgreSQL / Oracle ? | Hervé Piedvache | 17:51 |
| Thread | Author | Time |
|---|---|---|
| UNION in views | Roberto Mello | 00:41 |
| SQL question regarding a couple of table joins. | Warren Vanichuk | 00:49 |
| RE: SQL question regarding a couple of table joins. | Edmar Wiggers | 01:14 |
| Re: UNION in views | Tom Lane | 01:49 |
| Re: Re: Returning Recordsets from Stored-procs | Najm Hashmi | 15:53 |
| RE: reinitialise serial counter | Edmar Wiggers | 16:55 |
| Trouble Converting Dates | Kate Collins | 17:18 |
| Cascading a pseudo-delete? | Brian Powell | 17:45 |
| Display of RI triggers | Larry Rosenman | 18:50 |
| reinitialise serial counter | Indraneel Majumdar | 21:30 |
| how to index a numeric(12,2) column? | Forest Wilkinson | 22:57 |
| Re: how to index a numeric(12,2) column? | Tom Lane | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Table secure problem. | Mateusz Mazur | 13:26 |
| Oracle, ODBC, MS IIS -> problem! | ANDREAS STEINBACH | 14:50 |
| ./configure problems | rocael | 17:24 |
| Re: how to index a numeric(12,2) column? | Forest Wilkinson | 18:49 |
| Re: how to index a numeric(12,2) column? | Tom Lane | 19:06 |
| shared memory problem | rocael | 19:17 |
| Thread | Author | Time |
|---|---|---|
| Re: shared memory problem | Tom Lane | 02:41 |
| alter table add column implementation undesirable? | Forest Wilkinson | 03:55 |
| alter pg_shadow | pgsql-sql | 06:26 |
| shared memory blocks? | rocael | 07:26 |
| insert value of form - checkboxes | Astrid Hexsel | 08:05 |
| Re: ./configure problems | Jerome Alet | 08:30 |
| Re: insert value of form - checkboxes | Antti Linno | 08:41 |
| Rules | Peeter Smitt | 08:50 |
| how to write it in most efficient way? | hubert depesz lubaczewski | 13:20 |
| Re: alter table add column implementation undesirable? | Tom Lane | 15:31 |
| Re: [SQL] alter pg_shadow | Peter Eisentraut | 15:53 |
| Re: [sql]Joins | Stephan Szabo | 16:24 |
| Re: Oracle, ODBC, MS IIS -> problem! | Josh Berkus | 16:25 |
| Requests for Development | Josh Berkus | 16:40 |
| Re: shared memory blocks? | Poul L. Christiansen | 16:45 |
| Re: [sql]Joins | Cristóvão B. B. Dalla Costa | 18:59 |
| Re: Requests for Development | Roberto Mello | 20:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Requests for Development | Andreas Tille | 07:43 |
| Re: Requests for Development | Gerhard Dieringer | 08:26 |
| Return from stored procedures | Graham Vickrage | 09:24 |
| Re: Re: Requests for Development | KuroiNeko | 10:00 |
| Re: Return from stored procedures | Kovacs Zoltan Sandor | 11:08 |
| sorting the text values as integers | Sandis Jerics | 11:55 |
| [sql]Joins | Najm Hashmi | 15:59 |
| SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3) | Christophe Boyanique | 16:25 |
| Re: SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3) | Tom Lane | 16:35 |
| Re: SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3) | Christophe Boyanique | 16:45 |
| Re: SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3) | Tomas Berndtsson | 18:10 |
| special caracters! | rocael | 19:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Using a postgres table to maintain unique id? | Dr Frog | 10:30 |
| Re: shared memory problem | Michael Teter | 12:17 |
| Re: shared memory problem | Tom Lane | 15:32 |
| Using a postgres table to maintain unique id? | Steve Wampler | 17:13 |
| Re: Using a postgres table to maintain unique id? | Poet/Joshua Drake | 17:26 |
| Re: Using a postgres table to maintain unique id? | Steve Wampler | 17:44 |
| Re: Using a postgres table to maintain unique id? | Forest Wilkinson | 18:53 |
| Re: Using a postgres table to maintain unique id? | Steve Wampler | 19:36 |
| how to continue a transaction after an error? | Cristi Petrescu-Prahova | 19:41 |
| Re: how to continue a transaction after an error? | Stephan Szabo | 19:57 |
| Re: how to continue a transaction after an error? | Ross J. Reedstrom | 20:08 |
| RE: how to continue a transaction after an error? | Edmar Wiggers | 20:13 |
| Re: Using a postgres table to maintain unique id? | Marten Feldtmann | 20:18 |
| Re: how to continue a transaction after an error? | Cristi Petrescu-Prahova | 20:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Using a postgres table to maintain unique id? | Michael Teter | 02:22 |
| Re: how to continue a transaction after an error? | Philip Warner | 05:30 |
| Re: how to continue a transaction after an error? | Stephan Szabo | 06:23 |
| Re: how to continue a transaction after an error? | Philip Warner | 06:43 |
| Trigger cant find function | Graham Vickrage | 13:36 |
| Re: Trigger cant find function | Tom Lane | 16:05 |
| Re: Using a postgres table to maintain unique id? | Thomas Swan | 17:35 |
| Re: how to continue a transaction after an error? | Stephan Szabo | 17:38 |
| Re: Using a postgres table to maintain unique id? | Steve Wampler | 17:44 |
| Re: Using a postgres table to maintain unique id? | Marten Feldtmann | 20:11 |
| Using Array-Values in subselect | Alvar Freude | 20:51 |
| Re: Using Array-Values in subselect | Roberto Mello | 21:15 |
| RE: Using Array-Values in subselect | Edmar Wiggers | 21:36 |
| Re: Using Array-Values in subselect | Alvar Freude | 21:48 |
| Re: Using Array-Values in subselect | Stephan Szabo | 22:31 |
| Re: Using Array-Values in subselect | Tom Lane | 23:16 |