pgsql-sql - March 2003

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

March 1, 2003

Thread Author Time
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

March 2, 2003

Thread Author Time
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

March 3, 2003

Thread Author Time
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

March 4, 2003

Thread Author Time
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

March 5, 2003

Thread Author Time
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

March 6, 2003

Thread Author Time
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

March 7, 2003

Thread Author Time
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

Browse Archives

Prev | Next