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

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
Re: Functional Indexes Joe Conway 18:30
min() and NaN Michael S. Tibbetts 19:09
Timestamp problem Raymond Chui 19:15
changing an update via rules Lauren Matheson 22:13

July 16, 2003

Thread Author Time
Datatype Conversion help Ramesh Kumar B 00:41
Help Me Ramesh Kumar B 01:17
Re: Non-Blocking Locks (i.e. Oracle NOWAIT) Ang Chin Han 03:17
Data Warehousing Rudi Starcevic 04:43
numerical sort on mixed alpha/numeric data Gary Stainburn 11:48
pg_dump "feature" Viorel Dragomir 13:41
Re: problem with temporary table. Jonathan Gardner 13:42
Re: numerical sort on mixed alpha/numeric data Dmitry Tkach 14:27
Re: pg_dump "feature" Tom Lane 14:29
Re: pg_dump "feature" Dmitry Tkach 14:33
Re: numerical sort on mixed alpha/numeric data Gary Stainburn 14:39
Re: pg_dump "feature" Viorel Dragomir 14:43
Re: column doesn't get calculated - updated floyds 15:04
Re: Data Warehousing Dani Oderbolz 15:27
"Truncate [ Table ] name [Cascade]"? Andreas 15:44
Re: numerical sort on mixed alpha/numeric data Bruno Wolff III 16:41
Re: column doesn't get calculated - update # 2 floyds 16:54
Re: numerical sort on mixed alpha/numeric data Bruno Wolff III 16:54
Re: column doesn't get calculated - update # 2 Barry Lind 17:44
Why do the two queries below return different results? Warren Little 20:52

July 17, 2003

Thread Author Time
relevance jtx 00:52
Join table with itself for heirarchial system? Benjamin Smith 01:34
Re: relevance Oleg Bartunov 02:37
Re: relevance Terence Kearns 02:51
Re: Recursive request ... Benoît Bournon 06:39
Re: Recursive request ... BenLaKnet 06:44
Re: relevance Rajesh Kumar Mallah 07:15
Re: relevance Terence Kearns 08:39
parse error for function def Terence Kearns 10:46
unique value - trigger? Gary Stainburn 11:56
Is it possible to connect to another database BenLaKnet 14:03
Re: Is it possible to connect to another database Adam Witney 14:05
Re: Is it possible to connect to another database Viorel Dragomir 14:06
Re: parse error for function def greg 14:19
Re: parse error for function def Dmitry Tkach 14:24
Re: NOT and AND problem terry 14:29
NOT and AND problem Richard Jones 14:29
Re: unique value - trigger? Dmitry Tkach 14:34
Re: NOT and AND problem Viorel Dragomir 14:34
Re: NOT and AND problem Dmitry Tkach 14:41
Re: NOT and AND problem terry 14:52
Re: NOT and AND problem Richard Jones 15:09
Re: parse error for function def Stephan Szabo 15:39
Re: unique value - trigger? Gary Stainburn 15:49
Re: unique value - trigger? Dmitry Tkach 16:03
Re: unique value - trigger? Richard Poole 16:05
Re: unique value - trigger? Richard Poole 16:09
Table Partitioning and Rules Girish Bajaj 17:20
Re: Recursive request ... Joe Conway 17:42
OR vs UNION Scott Cain 18:11

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