pgsql-sql since 2002-07-28 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 28, 2002

Thread Author Time
performance difference in count(1) vs. count(*)? Markus Bertheau 15:50
Re: performance difference in count(1) vs. count(*)? Tom Lane 17:02
Re: using LIMIT only on primary table Lee Harr 18:13
Abbr. for TIMESTAMP WITHOUT TIME ZONE? Josh Berkus 23:53

July 29, 2002

Thread Author Time
Re: Problem with my query whithout double-quotes Keith Gray 03:34
Re: Abbr. for TIMESTAMP WITHOUT TIME ZONE? Tom Lane 06:11
RES: The best book Elielson Fontanezi 11:34
RES: The best book Elielson Fontanezi 11:44
RES: [SQL] RES: set DateStyle to 'SQL' Elielson Fontanezi 11:57
How to get binary data from pgsql function MaksimRomanov 13:47
How to optimize SQL query ? Milosz Krajewski 14:50
Re: RES: [SQL] RES: set DateStyle to 'SQL' Roberto Mello 16:44
Returning PK of first insert for second insert use. Peter Atkins 17:43
Returning PK of first insert for second insert use. Peter Atkins 18:32
Re: Returning PK of first insert for second insert use. Ken Corey 18:59
Re: Returning PK of first insert for second insert use. Peter Atkins 19:52
Decision support query inefficiencies ... Gunther Schadow 20:00
Re: Returning PK of first insert for second insert use. Ken Corey 20:04
Re: Returning PK of first insert for second insert use. Peter Atkins 20:20
Re: Decision support query inefficiencies ... Tom Lane 20:39
Extremely slow query Patrick Hatcher 23:32

July 30, 2002

Thread Author Time
Re: Returning PK of first insert for second insert use. Christopher Kings-Lynne 01:42
Re: Extremely slow query Christopher Kings-Lynne 02:00
contrib/dblink suggestion Bhuvan A 06:51
Re: Change size of a field ROUWEZ Stephane 08:07
Group And Sort After Union cnliou 08:46
Is login_cnt is reserved attribute name? Rajesh Kumar Mallah. 12:38
Re: contrib/dblink suggestion Bruce Momjian 15:26
Re: contrib/dblink suggestion Joe Conway 15:35
Delete a FOREIGN KEY Marcelo Henrique da Silva 17:38
formating numeric values Elielson Fontanezi 19:20
Re: Delete a FOREIGN KEY Stephan Szabo 19:23
COUNT DISTINCT? Josh Berkus 21:27
Re: COUNT DISTINCT? Stephan Szabo 21:45
Re: COUNT DISTINCT? Josh Berkus 22:52

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

Browse Archives

Prev | Next