pgsql-sql since 2003-03-08 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 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
Re: [SQL] What's wrong with this group by clause? Manfred Koizar 15:16
A Brief Real-World Trigger Example Richard Huxton 15:26
Re: [SQL] What's wrong with this group by clause? Christoph Haller 16:15
Re: [SQL] What's wrong with this group by clause? Tom Lane 17:02
Re: nearest match Ryan Orth 17:22
massive INSERT Kurt Overberg 17:45
Re: nearest match Ryan 17:56
Re: nearest match Jason Earl 19:22
Retrieving Definition for Composite Type Jordan S. Jones 19:32
[No subject] Tilo Schwarz 21:27
Re: Tilo Schwarz 21:34
Re: Retrieving Definition for Composite Type jasiek 22:20
Re: Retrieving Definition for Composite Type Joe Conway 22:37

March 14, 2003

Thread Author Time
Poor performance on a right join Carmen 00:12
Re: massive INSERT Greg Stark 00:20
date and plpgsql error Christopher Smith 01:37
Re: date and plpgsql error Stephan Szabo 01:55
displaying correct name Bruce Young 03:11
Re: nearest match Larry Rosenman 05:18
Re: displaying correct name Tomasz Myrta 07:56
Re: Poor performance on a right join dev 08:13
parse error when calling function in plpgsql David Witham 09:18
Re: What's wrong with this group by clause? Manfred Koizar 10:38
Re: View - Join based on dis-similar data types Richard Huxton 10:52
Re: Deleting large object from table pg_largeobject Richard Huxton 11:02
Re: Poor performance on a right join Carmen Sarlo 14:15
Re: Create function statement with insert statement Susan Hoddinott 14:28
Re: Create function statement with insert statement Susan Hoddinott 14:52
Re: Create function statement with insert statement Andreas Schmitz 14:52
Re: Create function statement with insert statement Christoph Haller 15:05
look for latest user login in one table from a list of users in a nother Sill-II, Stephen 16:35
Re: look for latest user login in one table from a list of users Jean-Luc Lachance 17:13
Re: look for latest user login in one table from a list of Sill-II, Stephen 17:15
Re: Create function statement with insert statement Susan Hoddinott 18:54
Re: Create function statement with insert statement Susan Hoddinott 18:58
Re: Create function statement with insert statement Joe Conway 19:37
MapInfo and PostgreSQL how-to David Delorme 20:06
Re: look for latest user login in one table from a list of Achilleus Mantzios 21:14
Re: Function calling error in postgreSQL 7.3.1 CoL 22:49

March 15, 2003

Thread Author Time
Re: SERIAL does not ROLLBACK Andrew McMillan 07:57
create index right after create table not working? joost witteveen 09:16
help with table constraint / check cliff 15:38
Re: help with table constraint / check Bruno Wolff III 16:29
create index right after create table not working? Joost Witteveen 23:53

March 16, 2003

Thread Author Time
Re: two dates D.Sanchez 22:37

March 17, 2003

Thread Author Time
String aggregate function Objectz 08:01
Re: create index right after create table not working? Manfred Koizar 08:08
How to compare dates? Abdul Wahab Dahalan 08:29
Re: How to compare dates? Victor Yegorov 08:45
Re: How to compare dates? Christoph Haller 08:58
Re: String aggregate function Tomasz Myrta 09:16
Re: String aggregate function Objectz 10:35
Re: String aggregate function Tomasz Myrta 10:55
Re: String aggregate function Tomasz Myrta 10:59
Re: Create function statement with insert statement Christoph Haller 11:25
Formatting intervals.. Rajesh Kumar Mallah 11:47
Re: Formatting intervals.. Tomasz Myrta 11:56
Re: Formatting intervals.. Christoph Haller 13:03
Re: Formatting intervals.. Rajesh Kumar Mallah 13:04
Howto?? J.C.M. van der Kwast 13:34
Re: Formatting intervals.. Rajesh Kumar Mallah 14:02
Re: Formatting intervals.. Christoph Haller 14:09
Re: Formatting intervals.. Tomasz Myrta 14:15
Re: String aggregate function Objectz 14:25
Re: Formatting intervals.. Christoph Haller 14:26
Re: Formatting intervals.. Tomasz Myrta 14:32
Re: How to compare dates? Achilleus Mantzios 14:41
Re: Formatting intervals.. Rajesh Kumar Mallah 14:54
Min values? J.C.M. van der Kwast 16:48
howto? Sjors 17:09
Re: howto? Bruno Wolff III 17:53
Re: Formatting intervals.. Josh Berkus 18:00
Re: Formatting intervals.. Larry Rosenman 18:02
Re: Howto?? chester c young 18:57
Re: Howto?? Tomasz Myrta 19:06

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