pgsql-sql before 2002-11-20 00:00

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

Nov. 7, 2002

Thread Author Time
PLpgSQL FOR IN EXECUTE question Christoph Haller 14:35
Re: primary keys Bruno Wolff III 14:35
Re: primary keys Tomasz Myrta 14:49
Re: [SQL] Problem: Referential Integrity Constraints lost Tom Lane 14:55
Re: how to get the source table & field name of a view field Ken Kennedy 15:08
Re: primary keys Sangeetha Rao 15:12
Re: cast lo to oid Tom Lane 15:16
Re: PLpgSQL FOR IN EXECUTE question Richard Huxton 16:13
Re: Copying a rowtype variable. Jean-Luc Lachance 16:28
Re: [SQL] Problem: Referential Integrity Constraints lost Achilleus Mantzios 16:38
Re: Weird NULL behavior Stephan Szabo 16:41
Re: Copying a rowtype variable. Rison, Stuart 16:51
Re: Generating a cross tab (pivot table) Joe Conway 17:25
Re: PLpgSQL FOR IN EXECUTE question Tom Lane 18:01
Quartile (etc) ranking in a SQL statement? Jeff Boes 18:16
Re: Weird NULL behavior Tom Lane 19:09
pg_dump, no inserts but \copy? Joost Witteveen 19:20
Re: Weird NULL behavior Stephan Szabo 19:35
Re: Weird NULL behavior Tom Lane 20:00
Re: Quartile (etc) ranking in a SQL statement? Jean-Luc Lachance 20:50
Re: PLpgSQL FOR IN EXECUTE question Josh Berkus 21:30
Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL Neil Conway 21:56
Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL Josh Berkus 22:57
Re: query optimization question terry 23:18

Nov. 8, 2002

Thread Author Time
Re: cast lo to oid Nekta Katz 00:11
Re: cast lo to oid Nekta Katz 00:24
Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL elein 03:11
get source table.field name from view's field Prime Ho 05:17
Delete cascade for multi tables? Zhidian Du 05:36
No promany key in parent table, how to use delete cascade? Zhidian Du 06:19
Re: No promany key in parent table, how to use delete cascade? Stephan Szabo 06:49
Alter table Rachel.Vaudron 07:22
changing numeric into int Huub 07:41
Re: how to get the source table & field name of a view field Christoph Haller 08:22
Re: Alter table Tomasz Myrta 08:44
Re: Alter table Rachel.Vaudron 08:50
Re: PLpgSQL FOR IN EXECUTE question Christoph Haller 09:06
Re: Generating a cross tab (pivot table) Ludwig Lim 09:39
Re: query optimization question Christoph Haller 10:01
Re: Alter table Daniel Schuchardt 13:24
Re: query optimization question Masaru Sugawara 14:22
Re: pg_dump, no inserts but \copy? Bruce Momjian 15:56
Permission on insert rules Luis Sousa 17:29
Time difference without intervals Roberto Mello 18:20
Re: Time difference without intervals Bruno Wolff III 18:59
Re: changing numeric into int Robert Treat 19:12
Re: Time difference without intervals Tom Lane 21:11

Nov. 9, 2002

Thread Author Time
Re: Permission on insert rules Josh Berkus 01:35
Re: Permission on insert rules Bruce Momjian 02:40
Passing OLD/NEW as composite type PL/PGSQL Ludwig Lim 02:50
More than 1 trigger of the same kind Ludwig Lim 03:35
Re: More than 1 trigger of the same kind Stephan Szabo 03:49
Some more weird NULL behavior Ludwig Lim 04:30
Re: More than 1 trigger of the same kind Tom Lane 04:33
Re: Some more weird NULL behavior Stephan Szabo 05:13
Output of function into a file karthick v 05:30
CREATE VIEW (dynamically) Emmanuel Engelhart 14:52
Re: Time difference without intervals Bruno Wolff III 15:52
execute a query in an other db LR 16:51

Nov. 10, 2002

Thread Author Time
table protein does not have an attribute oid? why? Zhidian Du 06:01
Parent table has not oid? Zhidian Du 06:04
Re: [SQL] Parent table has not oid? Tom Lane 13:50

Nov. 11, 2002

Thread Author Time
Re: Time difference without intervals Roberto Mello 05:17
Re: Time difference without intervals Tom Lane 05:22
small problem Carlos Sousa 14:30
small proble Carlos Sousa 14:30
Re: small problem dima 14:42
bigger problem Carlos Sousa 14:57
Re: Generating a cross tab (pivot table) Christoph Haller 15:42
Generating a cross tab II (pivot table) 📎 Christoph Haller 15:55
Re: Permission on insert rules Robert Treat 16:45
Re: Permission on insert rules Josh Berkus 17:59
Re: bigger problem Josh Berkus 18:13
Re: Generating a cross tab (pivot table) Josh Berkus 18:27
parse bug floyds 19:25
Re: bigger problem Peter Eisentraut 20:12
Re: Permission on insert rules Josh Berkus 20:12

Nov. 12, 2002

Thread Author Time
pg_dump / dates: Martin Crundall 05:15
[No subject] dnaren 07:22
Efficient ON DELETE trigger when referential integrity is involved ? Cédric Dufour 09:42
Efficient ON DELETE trigger when referential integrity is involved ? Cédric Dufour (Cogito Ergo Soft) 09:50
Re: Richard Huxton 10:19
Re: CREATE VIEW (dynamically) Christoph Haller 13:57
Re: parse bug Achilleus Mantzios 14:10
Re: execute a query in an other db Bruno Wolff III 14:18
Re: Output of function into a file Christoph Haller 14:37
averaging interval values praveen vejandla 15:40
Re: averaging interval values Christoph Haller 16:07
Re: Efficient ON DELETE trigger when referential integrity is Stephan Szabo 16:30
Re: Permission on insert rules Luis Sousa 17:10
Re: [SQL] Parent table has not oid? scott.marlowe 17:12
Re: Permission on insert rules Luis Sousa 17:12
Re: Permission on insert rules Luis Sousa 17:16
Re: Permission on insert rules Josh Berkus 17:29
Inconsistent or incomplete behavior obverse in where clause Paul Ogden 17:39
Re: Inconsistent or incomplete behavior obverse in where Josh Berkus 18:23
Re: Inconsistent or incomplete behavior obverse in where clause Tom Lane 18:34
Re: [HACKERS] Inconsistent or incomplete behavior obverse in where Tom Lane 18:44
Re: [SQL] Output of function into a file Rajesh Kumar Mallah. 18:48
Re: Inconsistent or incomplete behavior obverse in where Paul Ogden 18:52
Re: Inconsistent or incomplete behavior obverse in where Josh Berkus 19:13
Re: Postgres Date pg_dump/Import: Martin Crundall 20:12
Re: Postgres Date pg_dump/Import: Tom Lane 20:41
Re: Postgres Date pg_dump/Import: Martin Crundall 21:19
Re: Permission on insert rules Robert Treat 21:40

Nov. 13, 2002

Thread Author Time
Re: Permission on insert rules Luis Sousa 10:44
Re: Passing OLD/NEW as composite type PL/PGSQL Christoph Haller 12:09
SET DEFAULT Archibald Zimonyi 12:19
Re: SET DEFAULT Achilleus Mantzios 12:38
Re: Permission on insert rules Tom Lane 14:27
Re: Permission on insert rules Luis Sousa 15:09
Re: Permission on insert rules Josh Berkus 17:29
Re: Permission on insert rules Bruno Wolff III 19:52
Re: System´s database table Josh Berkus 20:06
Re: System´s database table Jean-Luc Lachance 20:37
Re: System´s database table Josh Berkus 20:43
RE: [SQL] System´s database table Paul Ogden 20:44
System´s database table Pedro Igor Craveiro e Silva 20:53
Re: RE: [SQL] System´s database table Jean-Luc Lachance 21:28

Nov. 14, 2002

Thread Author Time
Old "Feature" - Copy table ignores column defaults Tim Perdue 01:42
Re: Press Release -- Numbers greg 02:31
Re: Old "Feature" - Copy table ignores column defaults Tom Lane 04:37
Re: Old "Feature" - Copy table ignores column defaults Tom Lane 04:44
Re: RE: [SQL] System´s database table Robert Treat 23:04

Nov. 15, 2002

Thread Author Time
numeric problems jack 02:21
Re: numeric problems Paul Ogden 02:36
Error message: standard SQL or PostgreQSL? Huub 06:31
Does Postgres replace \\ with \ in an update query Vaughn Cleminson 07:23
Proposal of hierarchical queries, a la Oracle Evgen Potemkin 09:41
Updating a table column with ref integrity teknokrat 11:45
Re: Error message: standard SQL or PostgreQSL? Tom Lane 15:20
Re: Error message: standard SQL or PostgreQSL? Stephan Szabo 15:42
Re: Proposal of hierarchical queries, a la Oracle Oleg Bartunov 16:59
Re: Updating a table column with ref integrity Josh Berkus 18:07
Re: Does Postgres replace \\ with \ in an update query Richard Huxton 18:48
how can I improve the speed of this query Peter T. Brown 20:33

Nov. 16, 2002

Thread Author Time
Re: execute a query in an other db LR 10:43
Chaning locale sorting order for statements Albrecht Berger 10:51
Re: Chaning locale sorting order for statements pginfo 11:01
Re: Proposal of hierarchical queries, a la Oracle Evgen Potemkin 11:30
Re: Chaning locale sorting order for statements Tomasz Myrta 11:56
Re: Proposal of hierarchical queries, a la Oracle Oleg Bartunov 16:58
DATE TIME INDEX ? PostgreSQL Server 17:01
INDEX PROBLEMS ? PostgreSQL Server 18:04
Re: DATE TIME INDEX ? Tom Lane 18:42
Re: INDEX PROBLEMS ? Josh Berkus 19:06
Re: Proposal of hierarchical queries, a la Oracle Josh Berkus 19:09
Problems invoking psql. Help please. Hugh Esco 19:11
Problems invoking psql. Help please. Hugh Esco 19:28
Re: Proposal of hierarchical queries, a la Oracle Joe Conway 20:44
Re: execute a query in an other db Joe Conway 20:48

Nov. 17, 2002

Thread Author Time
Re: Problems invoking psql. Help please. jasiek 09:21
Re: Problems invoking psql. Help please. Tom Lane 19:16
Trees: maintaining pathnames 📎 Dan Langille 19:39
Press Release -- Just Waiting for Tom Josh Berkus 19:43
Re: Problems invoking psql. Help please. jasiek 20:24
Re: Trees: maintaining pathnames Josh Berkus 22:51

Nov. 18, 2002

Thread Author Time
Re: Trees: maintaining pathnames greg 01:09
be or not to be ??? 2000 Informática 01:59
Re: Problems invoking psql. Help please. Luis Sousa 09:57
Re: Problems invoking psql. Help please. Oliver Elphick 10:46
Re: Trees: maintaining pathnames Dan Langille 14:32
Bug with sequence Thomas Aichinger 15:45
Re: Press Release -- Just Waiting for Tom Jason Hihn 16:39
slow group by query Ellen Cyran 17:55
Re: Press Release -- Just Waiting for Tom Jason Hihn 18:04
Re: Press Release -- Just Waiting for Tom Robert Treat 18:05

Nov. 19, 2002

Thread Author Time
Re: Bug with sequence Lee Harr 01:22
Re: Problems invoking psql. Help please. Hugh Esco 04:44
Re: Press Release -- Just Waiting for Tom Justin Clift 05:41
Re: Problems invoking psql. Help please. Tom Lane 05:56
create index [email protected] 06:44
[No subject] sun yu 08:09
Re: Problems invoking psql. Help please. Tomasz Myrta 08:25
Re: Problems invoking psql. Help please. Luis Sousa 09:03
index usage for query Tomas Berndtsson 09:10
Re: Proposal of hierarchical queries, a la Oracle Evgen Potemkin 12:12
Re: index usage for query Richard Huxton 12:25
Re: Proposal of hierarchical queries, a la Oracle Evgen Potemkin 12:26
Re: Proposal of hierarchical queries, a la Oracle Evgen Potemkin 12:45
Re: Proposal of hierarchical queries, a la Oracle Oleg Bartunov 13:36
Re: create index Tomasz Myrta 14:13
Re: Tomasz Myrta 14:26
Re: slow group by query Stephan Szabo 15:04
Re: slow group by query Tom Lane 15:21
Re: how can I improve the speed of this query Frank Bax 15:44
Re: Problems invoking psql. Help please. Hugh Esco 15:56
Re: slow group by query Ellen Cyran 16:08
Re: slow group by query Ellen Cyran 16:26
Re: slow group by query Tom Lane 16:54
SQL -select count- Giannis 17:06
Re: Problems invoking psql. Help please. Luis Sousa 17:20
Re: Proposal of hierarchical queries, a la Oracle Joe Conway 17:27
Re: slow group by query Ellen Cyran 17:47
Using VIEW to simplify code... Chris Gamache 18:29
Re: Using VIEW to simplify code... Tom Lane 19:47
Re: Using VIEW to simplify code... Chris Gamache 21:37
Re: Using VIEW to simplify code... Stephan Szabo 22:56
Re: Using VIEW to simplify code... Tom Lane 23:15
Re: Using VIEW to simplify code... Chris Gamache 23:40

Browse Archives

Prev | Next