pgsql-sql - April 2005

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

April 1, 2005

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

April 3, 2005

Thread Author Time
Re: Query history file Bruce Momjian 02:56
Re: Date/Time Conversion Yasir Malik 03:49
Re: Date/Time Conversion Tom Lane 03:50
Re: Query history file PFC 08:03
Re: [SQL] delphi access question? Andreas Pflug 09:20
How to store directory like structures? Axel Straschil 10:13
Re: Merging item codes using referential integrity Andrus Moor 10:50
Re: a very big table Sean Davis 12:38
Re: Date/Time Conversion Yasir Malik 13:45
Re: How to store directory like structures? Oleg Bartunov 17:00
Re: How to store directory like structures? Axel Straschil 17:26
Re: How to store directory like structures? PFC 18:09
Re: How to store directory like structures? PFC 18:11
Re: How to store directory like structures? Oleg Bartunov 18:18
Re: a very big table PFC 18:21
Re: How to store directory like structures? Axel Straschil 18:34
Re: How to store directory like structures? Axel Straschil 19:03
Re: How to store directory like structures? Oleg Bartunov 19:24
Re: How to store directory like structures? PFC 19:57
Re: Date/Time Conversion Greg Stark 20:35
Re: How to store directory like structures? Axel Straschil 20:36
Re: How to store directory like structures? Axel Straschil 20:39

April 4, 2005

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

April 5, 2005

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

April 6, 2005

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

April 7, 2005

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

April 8, 2005

Thread Author Time
Re: Table PARTITION Enrico Weigelt 01:47
Re: Table PARTITION Dinesh Pandey 04:52
Re: Question on triggers and plpgsql John DeSoi 12:28
getting count for a specific querry Joel Fradkin 13:29
Re: Question on triggers and plpgsql Sean Davis 13:41
Re: Question on triggers and plpgsql John DeSoi 14:13
Re: Question on triggers and plpgsql Tom Lane 14:36
Re: Question on triggers and plpgsql Andrew Sullivan 14:59
Re: getting count for a specific querry Andrew Sullivan 15:07
Re: Question on triggers and plpgsql John DeSoi 15:29
Re: Question on triggers and plpgsql Tom Lane 15:35
Re: Question on triggers and plpgsql Andrew Sullivan 15:50
Re: Question on triggers and plpgsql Richard Huxton 16:02
Re: getting count for a specific querry Ragnar Hafstað 16:17
Re: getting count for a specific querry Ragnar Hafstað 16:25
Re: getting count for a specific querry Andrew Sullivan 16:30
Re: getting count for a specific querry Tom Lane 16:32
Re: getting count for a specific querry Rod Taylor 16:51
Numeric and CSV under 8.0.1 ? Stef 16:51
Re: getting count for a specific querry Ragnar Hafstað 16:55
Re: getting count for a specific querry Joel Fradkin 17:08
Re: Numeric and CSV under 8.0.1 ? Jim Johannsen 17:56
Re: Question on triggers and plpgsql Vivek Khera 18:02
Re: getting count for a specific querry Scott Marlowe 18:10
Re: Numeric and CSV under 8.0.1 ? Keith Worthington 18:12
Re: Numeric and CSV under 8.0.1 ? Stef 18:25
Re: Numeric and CSV under 8.0.1 ? Michael Fuhr 18:39
Re: Question on triggers and plpgsql Tom Lane 18:47
Re: getting count for a specific querry Bob Henkel 18:54
Re: getting count for a specific querry Joel Fradkin 19:23
Re: getting count for a specific querry Tom Lane 19:27
Re: getting count for a specific querry Andrew Sullivan 19:33
Re: getting count for a specific querry Joel Fradkin 19:37
Re: getting count for a specific querry Bob Henkel 19:39
Re: getting count for a specific querry Mischa Sandberg 19:39
Re: getting count for a specific querry 📎 Joel Fradkin 19:47
Re: getting count for a specific querry Joel Fradkin 19:51
Re: getting count for a specific querry Vivek Khera 20:23
Re: getting count for a specific querry Scott Marlowe 20:31
Re: getting count for a specific querry Bob Henkel 20:35
Re: getting count for a specific querry Vivek Khera 20:36
Re: getting count for a specific querry Vivek Khera 20:41
Re: getting count for a specific querry Scott Marlowe 20:42
Re: getting count for a specific querry Scott Marlowe 20:42
Re: getting count for a specific querry Bob Henkel 20:46
Re: getting count for a specific querry Scott Marlowe 20:50
Re: getting count for a specific querry Joel Fradkin 21:09
Re: getting count for a specific querry PFC 21:37
Re: getting count for a specific querry PFC 22:15

April 9, 2005

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

April 10, 2005

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

April 11, 2005

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

April 12, 2005

Thread Author Time
Re: Getting the output of a function used in a where clause Bill Lawrence 01:25
Re: Query runs very slowly in Postgres, but very fast in other DBMS Ezequiel Tolnay 05:36
Re: Query runs very slowly in Postgres, but very fast in other DBMS Tom Lane 05:43
Re: Query runs very slowly in Postgres, but very fast in other DBMS Krasimir Dimitrov 06:33
Re: Update aborted if trigger function fails? Richard Huxton 07:30
Re: OpenFTS Oleg Bartunov 07:30
Re: Query runs very slowly in Postgres, but very fast in other DBMS Andrus 10:09
operating "inet" type Ilya A. Kovalenko 12:34
Re: Getting the output of a function used in a where clause Scott Marlowe 13:55
Re: Update aborted if trigger function fails? Carlos Moreno 14:55
Re: Update aborted if trigger function fails? Andrew Sullivan 15:17
Re: Query runs very slowly in Postgres, but very fast in other DBMS Dan Feiveson 15:18
Re: Update aborted if trigger function fails? Carlos Moreno 15:47
max question A. R. Van Hook 17:24
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin PFC 18:34
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin PFC 18:41
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin Tom Lane 18:45
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin PFC 18:54
Re: getting count for a specific querry Vivek Khera 19:29
Re: Query history file Vivek Khera 19:33
Re: getting count for a specific querry Scott Marlowe 20:23
Re: getting count for a specific querry Vivek Khera 20:32
Re: getting count for a specific querry Scott Marlowe 20:42

April 13, 2005

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

April 14, 2005

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

Browse Archives

Prev | Next