pgsql-sql since 2003-03-05 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

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
The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard David Delorme 14:15
Re: SERIAL does not ROLLBACK Tim Pushor 14:52
Re: SERIAL does not ROLLBACK Jens Eliasson 15:25
Re: SERIAL does not ROLLBACK Manfred Koizar 16:24
LEFT JOIN and missing values mila 18:24
Re: LEFT JOIN and missing values Tomasz Myrta 18:47
extending ORDER BY make query much slower Dan Langille 19:36
Re: Create function statement with insert statement Jon Griffin 19:59
Re: filtering out doubles Chad Thompson 20:03
Re: LEFT JOIN and missing values mila 20:12
Re: filtering out doubles Stephan Szabo 20:17
Re: LEFT JOIN and missing values Tomasz Myrta 20:40
Re: DELETE FROM A BLACK LIST Steve Crawford 20:49
Re: LEFT JOIN and missing values mila boldareva 20:49
Deleting large object from table pg_largeobject David 20:59
Re: DELETE FROM A BLACK LIST Bruno Wolff III 21:03
"hide" values in a column Valerie Goodman 21:12
nearest match Ryan 21:32
Re: Using column alias in WHERE clause? Rod Taylor 21:36
Re: "hide" values in a column Rod Taylor 21:43
Re: extending ORDER BY make query much slower Stephan Szabo 21:44
Re: "hide" values in a column Tomasz Myrta 21:46
Re: extending ORDER BY make query much slower Tom Lane 22:00
Retrieving Definition for Composite Type Jordan S. Jones 22:01
Re: View - Join based on dis-similar data types Tom Lane 22:32
Re: "hide" values in a column Steve Crawford 22:39
Re: extending ORDER BY make query much slower Dan Langille 22:48
Re: extending ORDER BY make query much slower Dan Langille 22:59

March 13, 2003

Thread Author Time
Function calling error in postgreSQL 7.3.1 vincent 03:09
Re: Function calling error in postgreSQL 7.3.1 Stephan Szabo 06:05
Re: What's wrong with this group by clause? Len Morgan 07:34
Re: nearest match Tomasz Myrta 08:57
Re: Using update statements in create function statements Christoph Haller 09:02
Re: The folding of unquoted names to lower case in PostgreSQL is Christoph Haller 09:36
Re: Create function statement with insert statement Christoph Haller 10:07
Re: Create function statement with insert statement Christoph Haller 13:15
Re: View - Join based on dis-similar data types speakeasy 13:48
Re: What's wrong with this group by clause? Christoph Haller 14:12
Re: Create function statement with insert statement Ian Harding 14:45
Re: "hide" values in a column Chris Gamache 14:52

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31