pgsql-sql since 2003-03-04 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

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
Re: Cancelling Queries Bruce Momjian 18:26
Re: problem with subselect Tom Lane 18:31
Using column alias in WHERE clause? August Detlefsen 19:17
Hex Integer Input Achilleus Mantzios 20:14
Re: Splitting text into rows with SQL Ryan 22:08
Splitting text into rows with SQL Chris Gamache 22:14

March 8, 2003

Thread Author Time
Atomicity of UPDATE, interchanging values in unique column daniel alvarez 21:17
Re: Atomicity of UPDATE, interchanging values in unique column Rod Taylor 21:33
Re: Atomicity of UPDATE, interchanging values in unique column daniel alvarez 21:48
Re: Atomicity of UPDATE, interchanging values in unique Rod Taylor 21:56
Re: Atomicity of UPDATE, interchanging values in unique Tom Lane 22:10
Re: Cancelling Queries jasiek 22:27
Re: Beginner needs help Björn Lundin 23:20
Re: Atomicity of UPDATE, interchanging values in unique daniel alvarez 23:21

March 9, 2003

Thread Author Time
pl/pgsql how to return multiple values from a function jack 03:33
Re: pl/pgsql how to return multiple values from a function jack 05:42
Re: Insert multiple Rows mark carew 05:58
Re: pl/pgsql how to return multiple values from a function Rajesh Kumar Mallah 05:59
Re: pl/pgsql how to return multiple values from a function Stephan Szabo 08:51
check if table/object is locked Jonathan Weiss 15:14
Re: check if table/object is locked Rod Taylor 15:35
Special characters in SQL queries Vernon Wu 19:53
Cursors and backwards scans and SCROLL Tom Lane 20:35
Re: [SQL] Cursors and backwards scans and SCROLL Josh Berkus 20:59
Re: Cursors and backwards scans and SCROLL Rod Taylor 21:04
Re: Cursors and backwards scans and SCROLL Tom Lane 21:18
Re: Cursors and backwards scans and SCROLL Neil Conway 21:20
Re: Beginner needs help Lee Harr 22:42

March 10, 2003

Thread Author Time
Re: pl/pgsql how to return multiple values from a function jack 00:47
Re: pl/pgsql how to return multiple values from a function jack 00:50
About Create Type jack 01:21
Re: About Create Type Joe Conway 01:33
types? James Cooper 02:09
Re: Cursors and backwards scans and SCROLL Christopher Kings-Lynne 02:17
Re: Cursors and backwards scans and SCROLL Doug McNaught 02:32
Re: Cursors and backwards scans and SCROLL Christopher Kings-Lynne 02:33
Re: About Create Type jack 04:48
Re: Cursors and backwards scans and SCROLL Hannu Krosing 07:14
Re: Help on indexing timestamps Tomasz Myrta 09:12
Re: Help on indexing timestamps Andre Schubert 09:17
Re: Cursors and backwards scans and SCROLL Hiroshi Inoue 09:20
Re: Cursors and backwards scans and SCROLL Zeugswetter Andreas SB SD 09:29
Optimizing view 📎 Victor Yegorov 13:52
Re: Help on indexing timestamps Andre Schubert 14:24
Re: How to notice column changes in trigger Christoph Haller 14:34
Re: Cursors and backwards scans and SCROLL Tom Lane 14:40
Re: Help on indexing timestamps Tom Lane 15:07
Re: Optimizing view Tom Lane 15:14
Re: Cursors and backwards scans and SCROLL Jeroen T. Vermeulen 15:32
Execution plan problem Hesham Gowaily 15:40
Re: Cursors and backwards scans and SCROLL Tom Lane 15:41
Re: Cursors and backwards scans and SCROLL Bruce Momjian 16:26
Execution plan Question Objectz 16:43
Re: Execution plan Question Tomasz Myrta 17:13
Re: Could someone please sort out the e-mail to news gateway! Joseph Shraibman 22:57

March 11, 2003

Thread Author Time
explain (internal feature) A.M. 03:25
Re: explain (internal feature) Josh Berkus 04:08
Re: How to notice column changes in trigger Aspire Something 04:15
Re: explain (internal feature) Tom Lane 04:54
Re: Execution plan Question Objectz 05:09
export from postgres into dbf cristi 06:00
Re: Execution plan Question Tomasz Myrta 08:00
Re: Execution plan Question ObjectZ 08:11
Re: Hex Integer Input Achilleus Mantzios 12:13
Re: Hex Integer Input Achilleus Mantzios 12:14
Re: Special characters in SQL queries Christoph Haller 15:32
Re: How to notice column changes in trigger Andreas Pflug 15:36
Novice needs help Terry Lee Tucker 17:47
The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard David Delorme 19:39
Re: Novice needs help Terry Lee Tucker 20:46
Re: Novice needs help Joe Conway 20:59
Re: Novice needs help jasiek 21:03
Re: Novice needs help Chad Thompson 21:24

March 12, 2003

Thread Author Time
converting time_t to timestamp? patrick 02:57
Re: Special characters in SQL queries Vernon Wu 03:28
Table Updates .. Rudi Starcevic 03:50
Re: Table Updates .. Josh Berkus 03:57
Re: Table Updates .. Rudi Starcevic 04:07
Re: converting time_t to timestamp? Stephan Szabo 04:42
Re: Novice needs help Rajesh Kumar Mallah 04:55
Re: Special characters in SQL queries Rupa Schomaker 05:50
Re: Help on indexing timestamps Andre Schubert 06:27
Re: Special characters in SQL queries Victor Yegorov 06:44
SERIAL does not ROLLBACK Muhammad Shariq Muzaffar 07:21
Re: SERIAL does not ROLLBACK BERG Thomas 07:31
Re: [SQL] SERIAL does not ROLLBACK Stephan Szabo 07:34
Re: Special characters in SQL queries Christoph Haller 08:14
Create function statement with insert statement 📎 Susan Hoddinott 09:03
Using update statements in create function statements 📎 Susan Hoddinott 09:11
Re: Special characters in SQL queries Richard Huxton 09:44
filtering out doubles Jules Alberts 10:03

Browse Archives

Prev | Next