Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-sql - March 2003

2003-03-01

• Re: Optimizing Dan Langille (01:12)
• Re: Optimizing Steve Crawford (01:16)
• Re: Executing SQL commands via triggers without the use of Stephan Szabo (02:00)
• Re: Beginner needs help Greg Stark (06:22)
• Re: use of geometric types in select ? Victor Yegorov (08:37)
• Re: Beginner needs help Victor Yegorov (08:41)
• Arrays in Postgresql Processes Aspire Something (12:33)
• Re: Users and groups Oliver Elphick (13:02)
• [No subject] bishop (13:50)
• Epoch extraction Denis Arh (14:47)
• Epoch extraction Denis Arh (14:53)
• Re: Executing SQL commands via triggers without the use of procedures Jeff Eckermann (16:35)
• Re: Denormalizing during select Rod Taylor (17:07)
• Re: Denormalizing during select Rod Taylor (17:07)
• Re: Epoch extraction Tom Lane (17:07)
• Re: Denormalizing during select Tom Lane (17:13)
• Re: Denormalizing during select Greg Stark (17:53)
• OUTER JOIN with filter Nicolas Fertig (18:53)
• Re: Beginner needs help Chad Thompson (22:55)
• PL/pgSQL Zodiac (22:57)

2003-03-02

• Re: Beginner needs help Bruno Wolff III (00:23)
• Re: Are scalar type's in/out functions implicitly STRICT? Denis Zaitsev (00:40)
• Re: Are scalar type's in/out functions implicitly STRICT? Denis Zaitsev (00:41)
• Re: OUTER JOIN with filter Stephan Szabo (01:07)
• Re: OUTER JOIN with filter Bruno Wolff III (01:54)
• Re: Any limitation in size for return result from SELECT? Stephan Szabo (03:03)
• Re: Any limitation in size for return result from SELECT? Joe Conway (03:41)
• Re: Any limitation in size for return result from SELECT? Bruno Wolff III (03:44)
• HardCORE QUERY HELP!!! Metnetsky (04:20)
• Re: Dynamic SELECT condition Bruno Wolff III (04:46)
• Re: Tom Lane (06:10)
• Re: OUTER JOIN with filter Tom Lane (07:09)
• Re: OUTER JOIN with filter Stephan Szabo (07:33)
• default operator class (PostgreSQL's error?) Denis Zaitsev (09:24)
• Re: Inquiry From Form [pgsql] Greg Stark (14:10)
• Re: Dynamic SELECT condition Greg Stark (14:19)
• Re: Dynamic SELECT condition Achilleus Mantzios (16:04)
• Re: Beginner needs help Tomasz Myrta (18:00)
• Re: default operator class (PostgreSQL's error?) Tom Lane (18:01)
• Re: Zodiac (21:58)

2003-03-03

• Re: default operator class (PostgreSQL's error?) Denis Zaitsev (02:07)
• Querying Hierarchical Data Eric (02:27)
• Re: default operator class (PostgreSQL's error?) Tom Lane (03:27)
• Re: default operator class (PostgreSQL's error?) Denis Zaitsev (05:03)
• Re: HardCORE QUERY HELP!!! Rajesh Kumar Mallah (06:25)
• Re: Dynamic SELECT condition Victor Yegorov (07:27)
• copy help val (09:16)
• Re: Users and groups Christoph Haller (09:58)
• Re: copy help Janning Vygen (10:29)
• complex query Matt Gerginski (10:59)
• pl/pgsql errors Tomasz Myrta (11:32)
• Re: pl/pgsql errors Tambet Matiisen (11:45)
• Re: Dynamic SELECT condition Achilleus Mantzios (12:01)
• Re: two dates Richard Huxton (12:09)
• Re: two dates Oliver Elphick (12:32)
• Re: pl/pgsql errors Tomasz Myrta (12:32)
• Re: HardCORE QUERY HELP!!! Tomasz Myrta (12:41)
• Re: Executing SQL commands via triggers without the use of procedures Oleg Samoylov (13:22)
• Re: Dynamic SELECT condition Oleg Samoylov (13:30)
• Re: Querying Hierarchical Data Lex Berezhny (15:31)
• Re: Querying Hierarchical Data Rajesh Kumar Mallah (15:40)
• Re: Querying Hierarchical Data Victor Yegorov (16:34)
• Checking my HD space (noarchive) Ries van Twisk (16:36)
• Insert multiple Rows Saint X (16:38)
• Query Against a dblink View Takes Too Long to Return Dawn Hollingsworth (16:58)
• Re: complex query Victor Yegorov (17:18)
• Re: Insert multiple Rows Victor Yegorov (17:32)
• Suggestion: set session authorization with password Aasmund Midttun Godal (17:49)
• Re: Insert multiple Rows Oliver Elphick (17:52)
• Re: Beginner needs help Josh Berkus (18:18)
• Re: HardCORE QUERY HELP!!! Erwin Moller (18:24)
• Re: Querying Hierarchical Data Joe Conway (18:25)
• Re: OUTER JOIN with filter Josh Berkus (18:30)
• Re: Querying Hierarchical Data Robert Treat (18:34)
• Re: Querying Hierarchical Data Josh Berkus (18:34)
• LIMIT and SUBQUERIES Chris (18:54)
• Re: OUTER JOIN with filter Tom Lane (19:17)
• Re: HardCORE QUERY HELP!!! Greg Stark (20:46)
• Re: HardCORE QUERY HELP!!! Matthew Metnetsky (20:57)
• Re: Querying Hierarchical Data Achilleus Mantzios (20:57)
• Forcing query to use an index Michael Nachbaur (21:05)
• Gist indexes on int arrays Greg Stark (21:29)
• Re: Forcing query to use an index Josh Berkus (22:09)
• Re: Forcing query to use an index Stephan Szabo (22:09)
• Re: Forcing query to use an index Greg Stark (22:21)
• Re: Forcing query to use an index Michael Nachbaur (22:29)
• Re: Forcing query to use an index Michael Nachbaur (22:32)
• Re: Forcing query to use an index Michael Nachbaur (22:46)
• Re: Forcing query to use an index Josh Berkus (23:21)
• Re: Forcing query to use an index Michael Nachbaur (23:27)
• Re: Forcing query to use an index Josh Berkus (23:32)

2003-03-04

• Database function syntax for inserting records Susan Hoddinott (00:34)
• Re: Forcing query to use an index Michael Nachbaur (01:03)
• Re: Forcing query to use an index Greg Stark (01:14)
• Re: Forcing query to use an index Greg Stark (01:26)
• SCHEMA's Hepworth, Mike (01:30)
• Re: SCHEMA's Tom Lane (02:25)
• Re: Query Against a dblink View Takes Too Long to Return Tom Lane (02:43)
• SQL books Juan Fernández (09:11)
• Re: Checking my HD space (noarchive) Richard Huxton (09:20)
• Re: Insert multiple Rows Oleg Samoylov (10:54)
• Re: using Avg() Christoph Haller (11:14)
• Re: Insert multiple Rows Gary Stainburn (11:19)
• Re: Gist indexes on int arrays Achilleus Mantzios (11:42)
• Re: SQL books Douglas Trainor (12:43)
• Re: Gist indexes on int arrays Greg Stark (15:28)
• Re: Gist indexes on int arrays Greg Stark (16:56)
• Re: Database function syntax for inserting records Josh Berkus (17:31)
• SETOF Fernando (17:44)
• Convert a text list to text array? Was: Denormalizing during select Guy Fraser (17:58)
• Re: Gist indexes on int arrays Oleg Bartunov (18:16)
• Re: Gist indexes on int arrays Oleg Bartunov (18:17)
• Re: Convert a text list to text array? Was: Denormalizing during select Greg Stark (18:27)
• Re: Gist indexes on int arrays Greg Stark (18:38)
• Re: Gist indexes on int arrays Guy Fraser (18:40)
• Re: Sorting by NULL values Josh Berkus (19:01)
• Re: Convert a text list to text array? Was: Denormalizing during Joe Conway (19:39)
• Sorting by NULL values Ian Burrell (19:45)
• Re: Forcing query to use an index Jean-Luc Lachance (19:52)
• Re: Sorting by NULL values Tomasz Myrta (20:01)
• Re: Sorting by NULL values Dan Langille (20:07)
• Re: Forcing query to use an index Greg Stark (20:10)
• Re: Sorting by NULL values Stephan Szabo (20:13)
• Re: Gist indexes on int arrays Oleg Bartunov (20:13)
• Re: Gist indexes on int arrays Greg Stark (20:40)
• Re: Gist indexes on int arrays Achilleus Mantzios (20:57)
• Re: Forcing query to use an index Jean-Luc Lachance (21:05)
• Re: LIMIT and SUBQUERIES Tomasz Myrta (21:35)
• Re: Sorting by NULL values Rod Taylor (22:01)
• unsuscribe Miriam Fernández Galicia (22:24)
• Re: Forcing query to use an index Tom Lane (22:33)

2003-03-05

• upgrading from 7.1.2 to 7.3.2 patrick (01:39)
• Re: sort / limit / range problem Tomasz Myrta (07:47)
• Re: Insert multiple Rows Christoph Haller (08:38)
• DELETE FROM A BLACK LIST luca.scaramella (10:27)
• DELETE FROM A BLACK LIST luca.scaramella (10:44)
• DELETE FROM A BLACK LIST luca.scaramella (10:45)
• Re: SETOF Christoph Haller (11:47)
• Re: SETOF Greg Stark (12:47)
• Re: SETOF Christoph Haller (13:11)
• Re: LIMIT and SUBQUERIES Christoph Haller (13:24)
• Re: SETOF Greg Stark (13:36)
• Re: SETOF Greg Stark (13:37)
• Re: SETOF Christoph Haller (14:10)
• Re: DELETE FROM A BLACK LIST Christoph Haller (14:27)
• problematic query (for me ;-) Kim Petersen (14:31)
• sort / limit / range problem Gary Stainburn (14:37)
• Re: problematic query (for me ;-) [solved? - sorry to bother] Kim Petersen (14:47)
• Re: DELETE FROM A BLACK LIST Achilleus Mantzios (15:21)
• Re: LIMIT and SUBQUERIES Greg Stark (15:22)
• Re: DELETE FROM A BLACK LIST Chad Thompson (15:52)
• Re: sort / limit / range problem Gary Stainburn (16:00)
• Re: sort / limit / range problem Achilleus Mantzios (18:59)
• View - Join based on dis-similar data types speakeasy (19:59)
• Re: INTERSECT / where id IN (etc..) Tomasz Myrta (23:39)

2003-03-06

• INTERSECT / where id IN (etc..) James Cooper (00:54)
• Re: problematic query (for me ;-) Bjarke Dahl Ebert (01:44)
• Arrays Or Loop Aspire Something (06:00)
• decode or case statements Priya, Nagappan (N.) (09:53)
• sql question regarding count(*) Rajesh Kumar Mallah (11:32)
• Re: sql question regarding count(*) Tomasz Myrta (12:00)
• Re: Cancelling Queries Mark Mitchell (14:31)
• Re: Arrays Or Loop Josh Berkus (17:17)
• Re: Relation "pg_relcheck" Bruce Momjian (19:53)
• Re: Copy from a SELECT Bruce Momjian (20:21)
• Cancelling Queries Mark Mitchell (23:25)

2003-03-07

• postgresql installation question Ninonard Policarpio (01:03)
• Re: disable constraints Bruce Momjian (01:31)
• Re: sql question regarding count(*) Rajesh Kumar Mallah (05:23)
• Re: Cancelling Queries jasiek (05:27)
• Re: sql question regarding count(*) Stephan Szabo (06:11)
• Re: sql question regarding count(*) Rajesh Kumar Mallah (06:31)
• Re: sql question regarding count(*) Stephan Szabo (06:40)
• Re: sql question regarding count(*) Rajesh Kumar Mallah (07:55)
• Help on indexing timestamps Andre Schubert (10:26)
• How to notice column changes in trigger Andreas Pflug (10:30)
• Re: Help on indexing timestamps Andre Schubert (11:27)
• Re: Help on indexing timestamps Andre Schubert (12:02)
• Re: How to notice column changes in trigger Christoph Haller (12:04)
• Re: Help on indexing timestamps Andre Schubert (12:47)
• problem with subselect Mathieu Arnold (13:04)
• Re: Help on indexing timestamps Andre Schubert (13:11)
• Re: problem with subselect Christoph Haller (13:15)
• Re: problem with subselect Mathieu Arnold (13:29)
• Re: problem with subselect Christoph Haller (14:51)
• Re: Help on indexing timestamps Achilleus Mantzios (15:01)
• Re: Help on indexing timestamps Tom Lane (15:05)
• Re: Help on indexing timestamps Achilleus Mantzios (15:48)
• Underscores in column names Mark Mitchell (15:58)
• Re: Help on indexing timestamps Achilleus Mantzios (16:17)
• Re: How to notice column changes in trigger Andreas Pflug (16:25)
• Re: Underscores in column names Richard Huxton (16:28)
• Re: Hex Integer Input Joe Conway (16:50)
• Re: Help on indexing timestamps Achilleus Mantzios (17:03)
• Re: Underscores in column names Tom Lane (17:08)
• Re: Hex Integer Input Tom Lane (17:13)
• Re: Underscores in column names Mark Mitchell (17:17)
• Re: How to notice column changes in trigger Josh Berkus (17:41)
• Re: problem with subselect Josh Berkus (17:48)
• Re: How to notice column changes in trigger Andreas Pflug (18:10)