pgsql-sql since 2002-07-31 00:00

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

July 31, 2002

Thread Author Time
Re: contrib/dblink suggestion Bhuvan A 04:30
Transitive Closure Suhas Joshi 04:50
Re: 3-tier John Gunther 10:42
3-tier Elielson Fontanezi 11:28
Re: [SQL] 3-tier Achilleus Mantzios 12:26
SQL syntax Mindaugas Riauba 13:16
Re: SQL syntax Stephan Szabo 15:57
Re: 3-tier Chad R. Larson 18:22
negative queries puzzle Jinn Koriech 19:15
Re: negative queries puzzle Stephan Szabo 20:08
Case Statement Tom Haddon 22:59
Re: Case Statement Stephan Szabo 23:17
FW: Case Statement Tom Haddon 23:32

Aug. 1, 2002

Thread Author Time
Re: Case Statement Otto Hirr 00:10
Re: FW: Case Statement Stephan Szabo 00:23
Re: negative queries puzzle Christopher Kings-Lynne 01:51
Re: negative queries puzzle Ludwig Lim 01:51
Re: License Christopher Kings-Lynne 06:46
Re: Please Help me Christopher Kings-Lynne 06:49
How to disable rules?? friedrich nietzsche 09:28
Function problems, cache lookup failed Archibald Zimonyi 09:47
Random resultset retrieving -> performance bottleneck Cédric Dufour 11:35
Re: determine if a table exists Christoph Haller 12:42
Re: Function problems, cache lookup failed Tom Lane 14:01
Re: Please Help me 📎 Michelle Murrain 14:16
Re: Please Help me Chad Thompson 14:32
Re: Please Help me 📎 Michelle Murrain 14:48
Re: License Roberto Mello 14:51
Re: Please Help me Chad Thompson 14:56
Re: Please Help me Jochem van Dieten 15:16
Please Help me Waheed Rahuman 17:10
License Waheed Rahuman 17:41
Re: negative queries puzzle Gunther Schadow 18:07
type conversion / casting doc Kevin Brannen 18:33
determine if a table exists Joseph Syjuco 22:08

Aug. 2, 2002

Thread Author Time
Re: Please Help me Christopher Kings-Lynne 01:13
Re: Returning PK of first insert for second insert use. Cédric Dufour (Cogito Ergo Soft) 12:59
Re: How to optimize SQL query ? Cédric Dufour (Cogito Ergo Soft) 13:17
Re: Group And Sort After Union Tom Lane 13:47
Re: How to optimize SQL query ? Tom Lane 13:49
Re: total newbie question: windows download (binary) Henshall, Stuart - WCP 14:01
Re: How to optimize SQL query ? Cédric Dufour (Cogito Ergo Soft) 14:06
Re: Random resultset retrieving -> performance bottleneck Stephan Szabo 14:12
possible bug in \df+ Rajesh Kumar Mallah. 14:17
Seeking advice regarding a design problem Wei Weng 16:16
Re: Seeking advice regarding a design problem Wei Weng 16:21
Ltree usage.. Rajesh Kumar Mallah. 16:33
Re: Ltree usage.. Oleg Bartunov 17:00
Aggregates and Indexes Adam Erickson 18:20
Re: Seeking advice regarding a design problem Stephan Szabo 18:24
Re: Seeking advice regarding a design problem Wei Weng 18:41
Re: Seeking advice regarding a design problem Stephan Szabo 19:35
Re: Aggregates and Indexes Josh Berkus 20:20
Re: Aggregates and Indexes Tom Lane 20:43
What about this? Wei Weng 21:40
Re: What about this? Josh Berkus 23:14
Add Primary Key to a Table Tom Haddon 23:16
Re: Add Primary Key to a Table Josh Berkus 23:19
Re: Add Primary Key to a Table Tom Haddon 23:20
Re: What about this? Tom Lane 23:52

Aug. 3, 2002

Thread Author Time
Re: Aggregates and Indexes Ron Johnson 00:27
Re: [SQL] Aggregates and Indexes Bruce Momjian 01:36
Re: Ltree usage.. Rajesh Kumar Mallah. 05:26
Re: Random resultset retrieving -> performance bottleneck Christopher Kings-Lynne 10:09
Re: What about this? Christopher Kings-Lynne 10:42
Re: Random resultset retrieving -> performance bottleneck Cédric Dufour 13:24
Re: [SQL] Aggregates and Indexes Josh Berkus 16:40
Triggers for inserting on VIEWS Marc SCHAEFER 18:04
Re: RES: The best book Joshua D. Drake 18:32
Re: Triggers for inserting on VIEWS Josh Berkus 18:33
Re: Triggers for inserting on VIEWS Tom Lane 18:34
STATISTICS? Josh Berkus 19:26
Re: STATISTICS? mallah 19:58
Re: Triggers for inserting on VIEWS Marc SCHAEFER 20:14
VACUUM not doing its job? Kristian Eide 20:53
Bug with dump/restore when using UNION and ORDER BY in views Kristian Eide 21:11
Re: VACUUM not doing its job? Ken Corey 22:14
Re: VACUUM not doing its job? Kristian Eide 22:40
Re: VACUUM not doing its job? Sander Steffann 22:59
Re: VACUUM not doing its job? Joe Conway 23:02
Re: VACUUM not doing its job? Kristian Eide 23:39

Aug. 4, 2002

Thread Author Time
Re: STATISTICS? Josh Berkus 00:31
Re: VACUUM not doing its job? Joe Conway 00:32
Re: [SQL] Aggregates and Indexes Bruce Momjian 00:43
Re: Bug with dump/restore when using UNION and ORDER BY in views Tom Lane 03:06
Re: Bug with dump/restore when using UNION and ORDER BY in views Christopher Kings-Lynne 05:24
Re: Bug with dump/restore when using UNION and ORDER BY in views Tom Lane 05:30
Re: Bug with dump/restore when using UNION and ORDER BY in views Bruce Momjian 05:54
Re: Bug with dump/restore when using UNION and ORDER BY in views Tom Lane 06:07
Re: VACUUM not doing its job? Jochem van Dieten 11:22

Aug. 5, 2002

Thread Author Time
Re: Group And Sort After Union Terry Yapt 09:55
Re: VACUUM not doing its job? Robert Treat 21:40

Aug. 6, 2002

Thread Author Time
Concatenate aggregate? Julian Scarfe 08:03
Re: Concatenate aggregate? Archibald Zimonyi 08:28
Re: Concatenate aggregate? Julian Scarfe 08:37
Table design question... Joerg Hessdoerfer 09:17
Re: Table design question... Joerg Hessdoerfer 10:35
Re: copy files to postgresql 📎 John Zhang 12:14
Multi table insert and passing sequence ids Norman Khine 12:55
Re: Table design question... Richard Huxton 12:59
Re: copy files to postgresql Jeff Eckermann 13:23
Re: copy files to postgresql Tom Lane 14:01
Re: Transitive Closure Bruno Wolff III 14:06
Re: Transitive Closure Dan Langille 14:59
problem fetching currval of sequence Charles Hauser 15:14
Re: Table design question... Joerg Hessdoerfer 15:24
Re: Transitive Closure Oleg Bartunov 15:28
SQL syntax frederic massot 15:29
Re: problem fetching currval of sequence Josh Berkus 15:45
Re: problem fetching currval of sequence Stephan Szabo 15:57
Re: problem fetching currval of sequence Tom Lane 16:16
Re: copy files to postgresql Jean-Luc Lachance 16:20
Re: problem fetching currval of sequence Tom Lane 16:25
Re: problem fetching currval of sequence Charles Hauser 16:43
Re: problem fetching currval of sequence Tom Lane 16:48
Re: SQL syntax Tod McQuillin 16:48
Re: Transitive Closure Bruno Wolff III 17:01
Re: SQL syntax Cedric Dufour (Cogito Ergo Soft) 17:10
Re: Transitive Closure Oleg Bartunov 17:34
Re: Multi table insert and passing sequence ids Richard Huxton 17:38
Re: SQL syntax Jean-Luc Lachance 17:38
Re: SQL syntax Jean-Luc Lachance 17:53
Re: problem fetching currval of sequence Josh Berkus 18:35
Re: problem fetching currval of sequence Tom Lane 20:18
Re: problem fetching currval of sequence Josh Berkus 20:37
Re: problem fetching currval of sequence Charles Hauser 20:53
Re: problem fetching currval of sequence Josh Berkus 21:26
control reaches end of trigger procedure without RETURN rramostalo 22:12
ALTER TABLE follow up Tom Haddon 22:41

Aug. 7, 2002

Thread Author Time
Re: ALTER TABLE follow up Christopher Kings-Lynne 02:02
Limit A Table To 1 Row cnliou 03:29
Re: SQL syntax Tom Lane 03:31
Re: Limit A Table To 1 Row Bruno Wolff III 03:42
Re: SQL syntax Bruno Wolff III 03:47
Re: Limit A Table To 1 Row Josh Berkus 03:52
looking to speed up SELECT ... LEFT JOIN query Trey Ackerman 05:03
Effective usage without unique key -- suggestion Bhuvan A 08:27
Re: Limit A Table To 1 Row Richard Huxton 08:30
Views/queries and optimal indexes usage (cf. planner) Cédric Dufour 11:49
Re: control reaches end of trigger procedure without RETURN Jeff Eckermann 13:35
Table is modified? Yuri Gordienko 14:29
running psql in a cron job Wei Weng 14:51
Re: running psql in a cron job Wei Weng 15:01
Re: running psql in a cron job Wei Weng 17:07
manipulating the POINT data type Floyd Shackelford 17:16
Re: running psql in a cron job Ignacio Coloma 18:02
Re: ALTER TABLE follow up Tom Haddon 18:30
getting oid of an INSERT automatically John Brothers 18:39
Re: running psql in a cron job Ross J. Reedstrom 18:54
Altering live databases Gregory Brauer 21:45

Aug. 8, 2002

Thread Author Time
Re: ALTER TABLE follow up Christopher Kings-Lynne 02:32
Re: Altering live databases Christopher Kings-Lynne 02:38
Re: Altering live databases Gregory Brauer 02:52
Re: Altering live databases Christopher Kings-Lynne 02:59
Re: Effective usage without unique key -- suggestion Richard Huxton 09:20
to_char and '=' weirdness Frank Joerdens 11:33
Re: to_char and '=' weirdness Ludwig Lim 11:48
Re: to_char and '=' weirdness Karel Zak 12:11
Re: to_char and '=' weirdness Frank Joerdens 12:46
Re: to_char and '=' weirdness Frank Joerdens 13:04
Re: getting oid of an INSERT automatically Oliver Elphick 13:28
Re: manipulating the POINT data type Tom Lane 13:35
Re: looking to speed up SELECT ... LEFT JOIN query Richard Huxton 14:24
Re: getting oid of an INSERT automatically John Brothers 19:18
Table Sorting and Limit Question Dawn Hollingsworth 20:10

Aug. 9, 2002

Thread Author Time
Re: Table Sorting and Limit Question Ludwig Lim 01:42
expressions operating on arrays h012 04:38
Re: expressions operating on arrays Achilleus Mantzios 06:17
Re: expressions operating on arrays h012 07:12
Re: expressions operating on arrays Oleg Bartunov 07:30
Re: expressions operating on arrays Tom Lane 13:53
Re: Table Sorting and Limit Question Dawn Hollingsworth 13:55
Re: expressions operating on arrays Oleg Bartunov 14:57
Re: expressions operating on arrays h012 20:49
How to update record in a specified order Jean-Luc Lachance 21:21
Re: SQL syntax Jean-Luc Lachance 21:36
retrieving all rows from a "tree" in one select - how ? h012 21:36
Re: How to update record in a specified order Josh Berkus 21:37
Re: How to update record in a specified order Jean-Luc Lachance 21:59
Re: How to update record in a specified order Dan Langille 22:02
Re: retrieving all rows from a "tree" in one select - how ? Adam Erickson 22:04
Re: How to update record in a specified order Josh Berkus 22:12
Re: retrieving all rows from a "tree" in one select - how ? Josh Berkus 22:15
Re: retrieving all rows from a "tree" in one select - how ? Oleg Bartunov 23:37

Aug. 10, 2002

Thread Author Time
getting ILIKE or ~* to use indexes.... Rajesh Kumar Mallah. 06:13
Re: getting ILIKE or ~* to use indexes.... Josh Berkus 18:10
update on a large table Aaron Held 21:01
Re: getting ILIKE or ~* to use indexes.... mallah 21:14

Aug. 11, 2002

Thread Author Time
slowing down too fast - why ? h012 04:22
Re: slowing down too fast - why ? h012 04:36
Re: slowing down too fast - why ? Tom Lane 14:43
Re: slowing down too fast - why ? h012 18:10
Re: slowing down too fast - why ? Marc Spitzer 19:30

Aug. 12, 2002

Thread Author Time
Need Help for select Andre Schubert 13:06
Calling stored procedures in table constraint checks Florian Weimer 14:13
Re: Calling stored procedures in table constraint checks Tom Lane 15:11
Re: Need Help for select Ludwig Lim 15:11
Is this valid? Wei Weng 23:21

Aug. 13, 2002

Thread Author Time
Re: Is this valid? Robert Treat 00:10
Problems using UPDATE and SUM Brian Cawthon 00:31

Browse Archives

Prev | Next