Discussion for users on SQL related matters.
| 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 |
| Thread | Author | Time |
|---|---|---|
| Getting the output of a function used in a where clause | Bill Lawrence | 01:43 |
| Re: getting count for a specific querry | John DeSoi | 15:00 |
| Re: getting count for a specific querry | Bob Henkel | 15:43 |
| Re: getting count for a specific querry | John DeSoi | 15:51 |
| subselect query time and loops problem | pankaj naug | 20:21 |
| Re: subselect query time and loops problem | Tom Lane | 23:26 |
| Re: Question on triggers and plpgsql | Carlos Moreno | 23:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Question on triggers and plpgsql | Tom Lane | 03:21 |
| pg 8.0.1-r3 killls pgadmin3 and phppgadmin | PFC | 11:52 |
| Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin | Tony Caduto | 14:37 |
| Re: subselect query time and loops problem | pankaj naug | 14:54 |
| Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin | Tom Lane | 16:27 |
| Re: subselect query time and loops problem | Ragnar Hafstað | 17:29 |
| Thread | Author | Time |
|---|---|---|
| Re: [GENERAL] Problems with Set Returning Functions (SRFs) | Michael Fuhr | 02:06 |
| Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin | PFC | 08:48 |
| Re: Getting the output of a function used in a where clause | PFC | 08:51 |
| Re: [SQL] Problems with Set Returning Functions (SRFs) | Sean Davis | 10:07 |
| How to Port Oracle's user defined "Package" into Postgres 8.0.1. | Dinesh Pandey | 13:39 |
| Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin | Tom Lane | 14:05 |
| Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin | PFC | 15:25 |
| Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin | Tom Lane | 16:20 |
| Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin | PFC | 16:32 |
| Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin | Tom Lane | 16:42 |
| Update aborted if trigger function fails? | Carlos Moreno | 20:29 |
| OpenFTS | Dan Feiveson | 20:38 |
| PGCrypto: Realworld scenario and advice needed | Moran.Michael | 21:18 |
| Query runs very slowly in Postgres, but very fast in other DBMS | Andrus Moor | 21:43 |
| Re: PGCrypto: Realworld scenario and advice needed | Joe Conway | 22:26 |
| Thread | Author | Time |
|---|---|---|
| ignore single character in SELECT query? | jspring | 02:46 |
| Re: Getting the output of a function used in a where clause | Bill Lawrence | 03:46 |
| Re: max question | Tom Lane | 04:46 |
| Re: ignore single character in SELECT query? | Greg Stark | 04:56 |
| Re: ignore single character in SELECT query? | Dinesh Pandey | 04:58 |
| Re: max question | Dinesh Pandey | 05:02 |
| Re: Getting the output of a function used in a where clause | Bill Lawrence | 06:08 |
| Re: operating "inet" type | Bruno Wolff III | 13:14 |
| Re: max question | Bruno Wolff III | 13:20 |
| can a function return a virtual table? | Kai Hessing | 13:44 |
| SQL subquery (count distinct) - Any Ideas? | Matt Fulford | 17:28 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL group select question | Ezequiel Tolnay | 09:20 |
| Very low performance on table with only 298 rows | Andreas Joseph Krogh | 10:48 |
| Re: Very low performance on table with only 298 rows | Richard Huxton | 11:28 |