pgsql-sql - July 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

July 1, 2003

Thread Author Time
Re: help with "delete joins" Josh Berkus 00:35
Re: cleaning up useless pl/pgsql functions Rod Taylor 00:39
Re: Need help creating a BEFORE DELETE trigger Rod Taylor 00:41
Re: LEAST and GREATEST functions? Josh Berkus 03:32
Re: cleaning up useless pl/pgsql functions Mendola Gaetano 03:40
Re: CREATE SEQUENCE fails in plpgsql function Stephan Szabo 04:49
Re: LEAST and GREATEST functions? Stefan Bill 04:54
Re: need some help with a delete statement Matthew Hixson 08:24
passing a record as a function argument in pl/pgsql Alon Noy 09:01
Immutable attributes? Troels Arvin 09:59
mergejoin error message executing in 7.2 kevin rowe 11:12
Re: need some help with a delete statement scott.marlowe 12:47
Failed to initialize lc_messages to '' Rado Petrik 13:11
Re: CREATE SEQUENCE fails in plpgsql function Tom Lane 13:33
Re: help with "delete joins" Robert Treat 13:43
Re: CREATE SEQUENCE fails in plpgsql function Rod Taylor 13:53
help with rpm script Craig Jensen 14:17
Re: Failed to initialize lc_messages to '' Tom Lane 14:39
Re: help with "delete joins" Bruno Wolff III 14:46
Re: Immutable attributes? Robert Treat 16:28
Re: LEAST and GREATEST functions? Greg Stark 16:29
Re: Failed to initialize lc_messages to '' Peter Eisentraut 17:48
Re: need some help with a delete statement Matthew Hixson 17:55
Re: Immutable attributes? Troels Arvin 19:17
Re: need some help with a delete statement scott.marlowe 20:13
Re: LEAST and GREATEST functions? Bruno Wolff III 20:22
Re: LEAST and GREATEST functions? Joe Conway 20:22
Re: mergejoin error message executing in 7.2 Tom Lane 22:32
Re: LEAST and GREATEST functions? Joe Conway 23:31

July 2, 2003

Thread Author Time
Re: LEAST and GREATEST functions? Josh Berkus 00:04
Re: LEAST and GREATEST functions? Joe Conway 01:42
Re: passing a record as a function argument in pl/pgsql Joe Conway 02:25
columnar format Don Soledad 02:42
Timeout for lock table Jonathan Man 03:17
Break referential integrity. Rudi Starcevic 03:59
Re: LEAST and GREATEST functions? Ang Chin Han 04:02
Re: Break referential integrity. Stephan Szabo 04:14
Re: LEAST and GREATEST functions? Tom Lane 05:37
Re: LEAST and GREATEST functions? Ang Chin Han 06:12
About Postgresql Service on SUN OS Atul Pedgaonkar 06:13
SQL Jonathan Man 06:21
Re: LEAST and GREATEST functions? Tom Lane 06:36
Re: LEAST and GREATEST functions? Ang Chin Han 07:11
Re: Getting all rows even if not a member of any groups Együd Csaba 10:00
Re: Postgres - Delphi Application Együd Csaba 10:39
Weird order problem (ignoring whitespaces?) g.o.d 11:32

July 3, 2003

Thread Author Time
Re: Inquiry From Form [pgsql] Bruno Wolff III 11:19
Re: SEQUENCE and PRIMARY KEY Rod Taylor 12:22
Re: Inquiry From Form [pgsql] scott.marlowe 16:12

July 4, 2003

Thread Author Time
INSERT ... SELECT problem in Mysql Evil Azrael 21:11
Re: INSERT ... SELECT problem in Mysql Tom Lane 21:45
Re: INSERT ... SELECT problem in Mysql Evil Azrael 22:06

July 5, 2003

Thread Author Time
inet versus text for ip addresses Dan Langille 00:08
Re: INSERT ... SELECT problem in Mysql Ian Barwick 12:14

July 7, 2003

Thread Author Time
Merge Record in Database(SQL Statement) Shahbuddin Md Isa 01:23
Merge Record in database(sql statement) Shahbuddin Md Isa 02:54
Merge Record in database(sql statement) Shahbuddin Md Isa 02:55
Re: Merge Record in database(sql statement) Markus Bertheau 05:21
Re: Merge Record in Database(SQL Statement) listrec 09:19
create view error Gary Stainburn 11:40
Re: create view error mila boldareva 12:06
Re: create view error Richard Huxton 12:07
Concat and view - Re: create view error Gary Stainburn 12:36
Re: Concat and view - Re: create view error Gary Stainburn 13:12
Database Upgrade scripts (AKA Conditional SQL execution) Richard Rowell 13:58
sort for ranking Andreas Schmitz 14:14
Re: Concat and view - Re: create view error Richard Huxton 14:34
Re: sort for ranking Henshall, Stuart - TNP Southwest 15:06
Re: Concat and view - Re: create view error Gary Stainburn 15:10
max length of sql select statement ? 15:15
Re: Database Upgrade scripts (AKA Conditional SQL execution) Joe Conway 15:20
Re: Concat and view - Re: create view error Richard Huxton 15:44
max length of sql select statement ? markus brosch 15:44
Re: max length of sql select statement ? mallah 15:57
Need help with complex query Yasir Malik 15:58
Re: max length of sql select statement ? markus brosch 16:07
Re: max length of sql select statement ? mallah 16:13
Re: max length of sql select statement ? markus brosch 16:20
Re: max length of sql select statement ? Rod Taylor 16:20
Re: max length of sql select statement ? Stephan Szabo 16:23
Re: max length of sql select statement ? markus brosch 16:23
Re: create view error Achilleus Mantzios 17:05
Re: sort for ranking Jean-Luc Lachance 17:19
Re: sort for ranking scott.marlowe 19:51
avoid select expens_expr(col) like unneccessary calculations Markus Bertheau 22:35
Re: avoid select expens_expr(col) like unneccessary calculations Stephan Szabo 22:47
Re: avoid select expens_expr(col) like unneccessary calculations scott.marlowe 22:55

July 8, 2003

Thread Author Time
Re: columnar format Christoph Haller 08:44
Setuid functions Luis Sousa 16:29
Re: Setuid functions Joe Conway 16:34
Datatype conversion help Yasir Malik 20:07
Re: Datatype conversion help Michael A Nachbaur 20:26
Re: Datatype conversion help Yasir Malik 20:28
Re: Datatype conversion help Michael A Nachbaur 20:45
Re: Datatype conversion help David Olbersen 21:02
Re: Datatype conversion help Yasir Malik 21:19
Logging select statements Rudi Starcevic 23:52

July 9, 2003

Thread Author Time
executing a function adivi 05:29
Re: executing a function Matthew Horoschun 05:49
Re: Logging select statements Rudi Starcevic 06:55
Re: Datatype conversion help Richard Huxton 08:29
Re: Logging select statements Rudi Starcevic 09:06
Re: max length of sql select statement ? markus brosch 09:45
Re: Logging select statements Matthew Horoschun 09:56
Re: Logging select statements Rudi Starcevic 10:32
Re: Logging select statements Achilleus Mantzios 11:46
Re: Logging select statements Achilleus Mantzios 12:16
Re: max length of sql select statement ? Rod Taylor 13:29
Re: Need help with complex query Yasir Malik 15:07
Recursive request ... Benoît Bournon 15:27
Re: max length of sql select statement ? markus brosch 15:51
Re: max length of sql select statement ? Rod Taylor 17:02
Re: Datatype conversion help Yasir Malik 18:49
Re: Datatype conversion help Yasir Malik 18:55
Re: Break referential integrity. Jan Wieck 19:06
Home-brewed table syncronization Michael A Nachbaur 21:14
Re: Home-brewed table syncronization Cliff Wells 21:28
Re: Home-brewed table syncronization Michael A Nachbaur 21:50
Re: Home-brewed table syncronization Jason Earl 22:13
Re: Datatype conversion help Dmitry Tkach 22:40
Re: Datatype conversion help Dmitry Tkach 22:51

July 10, 2003

Thread Author Time
plpgsql vs. SQL performance (again) Michael Pohl 01:48
Re: Home-brewed table syncronization Raj Mathur 03:36
substr_count Tom Rochester 04:38
trigger proceedures in sql adivi 05:40
Re: Datatype conversion help listrec 05:58
Re: Recursive request ... Joe Conway 07:44
Re: trigger proceedures in sql David Witham 07:56
Re: help yourself by helping others Richard Huxton 08:24
Re: trigger proceedures in sql Richard Huxton 08:29
Problem with temporary table -- Urgent Vijay Kumar 08:39
problem with temporary table. Vijay Kumar 10:03
server side error variable adivi 10:11
Blobs sri devi 11:10
Re: help yourself by helping others Yasir Malik 12:25
Re: substr_count Michael Pohl 12:55
Re: Recursive request ... Rod Taylor 13:32
Re: substr_count Rod Taylor 13:43
Re: help yourself by helping others Rod Taylor 13:47
Re: trigger proceedures in sql Stephan Szabo 14:27
Re: help yourself by helping others scott.marlowe 15:20
Re: max length of sql select statement ? scott.marlowe 15:24
Re: substr_count scott.marlowe 15:36
Re: trigger proceedures in sql scott.marlowe 15:47
Re: help yourself by helping others Jonathan Gardner 19:14
Re: trigger proceedures in sql Jonathan Gardner 19:16
Re: help yourself by helping others 📎 Michael A Nachbaur 20:00

July 11, 2003

Thread Author Time
Re: substr_count Rajesh Kumar Mallah 09:53

July 12, 2003

Thread Author Time
Re: Problem with temporary table -- Urgent Stephan Szabo 04:03
time date interval... Erik Thiele 07:00
Re: Problem with temporary table -- Urgent Richard Huxton 08:45
Re: time date interval... Bruno Wolff III 13:36

July 13, 2003

Thread Author Time
Re: Blobs Rajesh Kumar Mallah 06:28
Re: trigger proceedures in sql Rajesh Kumar Mallah 06:31
Re: Recursive request ... Rajesh Kumar Mallah 06:47
Re: help yourself by helping others Rajesh Kumar Mallah 07:46
Re: trigger proceedures in sql Jan Wieck 12:03
How to write this query! Jo 16:32
Replacing a simple nested query? Steve Wampler 21:50
Re: Replacing a simple nested query? Joe Conway 22:01

July 14, 2003

Thread Author Time
Re: max length of sql select statement (long!) markus brosch 12:57
Re: [SQL] Replacing a simple nested query? Steve Wampler 13:38
Cannot insert dup id in pk Scott Cain 17:01

July 15, 2003

Thread Author Time
ad hoc referential integrity Matt Tenenbaum 04:39
Re: ad hoc referential integrity Stephan Szabo 04:48
Re: Recursive request ... Benoît Bournon 06:42
summing tables Erik Thiele 12:09
Re: summing tables Viorel Dragomir 12:16
Re: summing tables Dani Oderbolz 12:17
Re: summing tables Erik Thiele 12:39
Non-Blocking Locks (i.e. Oracle NOWAIT) Jan Bernhardt 12:44
Cannot insert dup id in pk Scott Cain 13:00
help with troublesome query teknokrat 13:26
Re: summing tables Viorel Dragomir 13:37
Re: help with troublesome query Bruno Wolff III 13:47
Re: Cannot insert dup id in pk Henshall, Stuart - TNP Southwest 14:31
Count dates distinct within an interval Dmitry Tkach 14:33
Re: max length of sql select statement (long!) greg 14:39
Re: Cannot insert dup id in pk Dmitry Tkach 14:43
Re: Count dates distinct within an interval greg 14:54
Re: Non-Blocking Locks (i.e. Oracle NOWAIT) Christoph Haller 14:54
Re: summing tables Greg Stark 14:55
Re: Count dates distinct within an interval Dmitry Tkach 15:00
Re: summing tables Jean-Luc Lachance 15:02
Re: summing tables Viorel Dragomir 15:06
Re: summing tables Tom Lane 15:14
Re: Non-Blocking Locks (i.e. Oracle NOWAIT) Dmitry Tkach 15:16
Re: Non-Blocking Locks (i.e. Oracle NOWAIT) Tom Lane 15:17
Re: Cannot insert dup id in pk Tom Lane 15:25
Re: summing tables Viorel Dragomir 15:32
Re: summing tables Greg Stark 15:38
Re: Count dates distinct within an interval greg 15:40
Re: summing tables Tom Lane 15:42
Re: summing tables Viorel Dragomir 15:49
column doesn't get calculated floyds 16:13
Re: Cannot insert dup id in pk Scott Cain 16:47
Re: Count dates distinct within an interval Stuart 17:31
Functional Indexes David Olbersen 17:36
Re: Functional Indexes Frank Bax 18:06
Re: Functional Indexes Tom Lane 18:12

Browse Archives

Prev | Next