Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| How to make update statement to work | Andrus Moor | 15:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Auto Numbering | Michael Fuhr | 07:26 |
| Re: Foreign key | Michael Fuhr | 07:47 |
| Re: How to make update statement to work | Tom Lane | 07:57 |
| Re: select a list of schema names | Michael Fuhr | 08:04 |
| Re: Accessing other Databases | Michael Fuhr | 08:09 |
| Re: Is there a way to find a schema name | Michael Fuhr | 08:22 |
| Postgre: 8.0.1 Create Table insde a function gives strange error at execution time | Franz Stuetzle | 12:17 |
| detaching triggers | Enrico Weigelt | 15:41 |
| (non)zero function | Enrico Weigelt | 15:58 |
| Re: Postgre: 8.0.1 Create Table insde a function gives strange error at execution time | Tom Lane | 16:01 |
| Re: detaching triggers | Mike Rylander | 16:20 |
| Re: Foreign key | Bruno Wolff III | 16:33 |
| Re: (non)zero function | Bruno Wolff III | 16:51 |
| Re: "Flattening" query result into columns | Thomas Borg Salling | 21:09 |
| Thread | Author | Time |
|---|---|---|
| Executing Anonymous Blocks | imad | 07:27 |
| connectby queries | Chandan_Kumaraiah | 08:32 |
| Re: (non)zero function | Christian Kratzer | 08:42 |
| Re: Executing Anonymous Blocks | Alvaro Herrera | 14:43 |
| Re: connectby queries | Michael Fuhr | 16:37 |
| Postgres 7.3 migrate to 8.0 date problems. | Thomas Seeber | 19:44 |
| Re: Postgres 7.3 migrate to 8.0 date problems. | Scott Marlowe | 20:48 |
| cost of CREATE VIEW ... AS SELECT DISTINCT | T E Schmitz | 21:43 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | Scott Marlowe | 22:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Executing Anonymous Blocks | Neil Conway | 07:59 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | T E Schmitz | 10:07 |
| Re: Merging item codes using referential integrity | Richard Huxton | 10:12 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | Sean Davis | 10:59 |
| when using a bound cursor, error found... | 윤동수 | 11:49 |
| Re: Executing Anonymous Blocks | Andrew Dunstan | 11:55 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | T E Schmitz | 13:21 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | Bruno Wolff III | 13:29 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | Alvaro Herrera | 13:58 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | T E Schmitz | 14:12 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | Bruno Wolff III | 15:04 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | Bruno Wolff III | 15:07 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | Tom Lane | 15:54 |
| Re: cost of CREATE VIEW ... AS SELECT DISTINCT | T E Schmitz | 16:01 |
| a very big table | _moray | 16:25 |
| Thread | Author | Time |
|---|---|---|
| A SQL Question About distinct, limit, group by, having, aggregate | =?BIG5?Q?=AAL=A9?=[=?BIG5?Q?=BEN?= | 02:29 |
| Re: A SQL Question About distinct, limit, group by, having, aggregate | Jaime Casanova | 03:01 |
| Re: Postgres 7.3 migrate to 8.0 date problems. | Michael Fuhr | 03:11 |
| Re: delphi access question | Lin Kun Hsin | 04:22 |
| Re: A SQL Question About distinct, limit, group by, having, aggregate | Lin Kun Hsin | 05:14 |
| Re: save me from an unconstrained join | Richard Huxton | 07:15 |
| Re: A SQL Question About distinct, limit, group by, having, | Ragnar Hafstað | 08:05 |
| Help - Oracle 9i to PostgreSQL SQL conversion | Dinesh Pandey | 11:05 |
| Re: A SQL Question About distinct, limit, group by, having, aggregate | Lin Kun Hsin | 12:24 |
| Re: Speed up slow select - was gone blind | Dinesh Pandey | 12:44 |
| Re: New record position | Greg Patnude | 16:42 |
| Re: New record position | Chris Browne | 17:33 |
| unsubscribe pgsql-sql | Robin M. | 18:31 |
| Re: unsubscribe pgsql-sql | Chris Hebrard | 23:45 |
| Thread | Author | Time |
|---|---|---|
| asynchrous triggers | Enrico Weigelt | 03:52 |
| Re: asynchrous triggers | Alvaro Herrera | 04:07 |
| gone blind - can't see syntax error | Gary Stainburn | 11:36 |
| Re: gone blind - can't see syntax error | Dinesh Pandey | 11:51 |
| Re: gone blind - can't see syntax error | Mike Rylander | 11:55 |
| Re: gone blind - can't see syntax error | Kenneth Gonsalves | 12:01 |
| Re: gone blind - can't see syntax error | Gary Stainburn | 12:08 |
| Speed up slow select - was gone blind | Gary Stainburn | 12:32 |
| Re: Speed up slow select - was gone blind | Mike Rylander | 12:46 |
| Re: Speed up slow select - was gone blind | Richard Huxton | 13:00 |
| Order of items in FROM causes error? | Rosser Schwarz | 16:24 |
| Re: Order of items in FROM causes error? | Tom Lane | 16:35 |
| Re: Order of items in FROM causes error? | Stephan Szabo | 16:37 |
| Query history file | Mauro Bertoli | 23:42 |
| Thread | Author | Time |
|---|---|---|
| Re: a very big table | Tom Lane | 00:50 |
| select & group by | Michael L. Hostbaek | 10:16 |
| Re: [SQL] delphi access question? | Miguel Juan | 10:29 |
| Re: select & group by | Richard Huxton | 10:39 |
| Re: select & group by | Ragnar Hafstað | 10:47 |
| Re: select & group by | Ragnar Hafstað | 10:59 |
| Re: select & group by | Michael L. Hostbaek | 12:23 |
| Chield Serial | lucas | 13:01 |
| Migrated Oracle database to PostgreSQL ?? | Dinesh Pandey | 13:41 |
| Re: Migrated Oracle database to PostgreSQL ?? | Yasir Malik | 19:35 |
| Re: Migrated Oracle database to PostgreSQL ?? | Dinesh Pandey | 19:57 |
| Thread | Author | Time |
|---|---|---|
| Re: Speed up slow select - was gone blind | Gary Stainburn | 09:44 |
| [ocpfree] Problem finding the time difference while tuning a query | Karthik Dakshinamoorthy | 13:17 |
| Re: Query history file | Mauro Bertoli | 15:29 |
| Thread | Author | Time |
|---|---|---|
| Crosstab function | bandeng | 06:55 |
| Re: Crosstab function | Richard Huxton | 08:25 |
| Re: [despammed] Crosstab function | Andreas Kretschmer | 08:32 |
| CURSOR EXAMPLE - ORACLE TO POSTGRES CONVERSION | Dinesh Pandey | 08:38 |
| DROP TYPE without error? | Philippe Lang | 12:59 |
| createlang 'pltclu' with postgreSQL. | Dinesh Pandey | 14:09 |
| TIMESTAMP / summertime | T E Schmitz | 15:08 |
| Re: createlang 'pltclu' with postgreSQL. | Michael Fuhr | 15:43 |
| Re: createlang 'pltclu' with postgreSQL. | Dinesh Pandey | 15:48 |
| Re: createlang 'pltclu' with postgreSQL. | Dinesh Pandey | 15:59 |
| FW: createlang 'pltclu' with postgreSQL. | Dinesh Pandey | 16:22 |
| Problems with Set Returning Functions (SRFs) | Otto Blomqvist | 18:53 |
| Re: DROP TYPE without error? | Mischa | 20:03 |
| Re: Problems with Set Returning Functions (SRFs) | Tom Lane | 20:30 |
| Re: [GENERAL] Problems with Set Returning Functions (SRFs) | Otto Blomqvist | 22:31 |
| Thread | Author | Time |
|---|---|---|
| 9.17.5. Row-wise Comparison | TJ O'Donnell | 03:48 |
| Re: 9.17.5. Row-wise Comparison | Tom Lane | 04:47 |
| ar: Command not found. | Dinesh Pandey | 04:51 |
| Re: ar: Command not found. | Dinesh Pandey | 05:00 |
| Query Problem | Abdul Wahab Dahalan | 07:16 |
| Re: Query Problem | Richard Huxton | 08:46 |
| Re: [despammed] Crosstab function | bandeng | 09:46 |
| Re: [despammed] Crosstab function | Markus Schaber | 11:36 |
| Table PARTITION | Dinesh Pandey | 11:38 |
| Re: Table PARTITION | Richard Huxton | 12:06 |
| Re: Table PARTITION | Dinesh Pandey | 12:09 |
| Re: Table PARTITION | Sean Davis | 12:16 |
| Re: TIMESTAMP / summertime | Christoph Haller | 12:26 |
| Re: Table PARTITION | Richard Huxton | 12:32 |
| Re: DROP TYPE without error? | Harald Fuchs | 12:37 |
| Re: Table PARTITION | Richard Huxton | 12:37 |
| Re: 9.17.5. Row-wise Comparison | TJ O'Donnell | 13:44 |
| Re: 9.17.5. Row-wise Comparison | Ragnar Hafstað | 15:51 |
| Re: DROP TYPE without error? | Jeff Boes | 19:48 |
| Re: DROP TYPE without error? | Craig Addleman | 20:24 |
| Question on triggers and plpgsql | Carlos Moreno | 21:45 |