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

July 8, 2003

Thread	Author	Time
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
Re: Table Partitioning and Rules	Richard Huxton	18:52
Re: OR vs UNION	Josh Berkus	19:00
Re: Table Partitioning and Rules	Josh Berkus	19:03
Re: OR vs UNION	Scott Cain	19:18
Re: Table Partitioning and Rules	Rod Taylor	19:22
Re: Table Partitioning and Rules	Girish Bajaj	19:22
Re: OR vs UNION	Tom Lane	19:24
Re: Table Partitioning and Rules	Josh Berkus	19:38
Re: Table Partitioning and Rules	Steve Crawford	19:39
Re: Table Partitioning and Rules	Dmitry Tkach	19:42
Re: OR vs UNION	terry	19:58
Re: parse error for function def	Jonathan Gardner	21:37
Return a set of values from postgres Function	Derrick Betts	22:30

July 18, 2003

Thread	Author	Time
Re: Recursive request ...	Greg Stark	06:00
Re: Table Partitioning and Rules	Greg Stark	06:15
Re: Table Partitioning and Rules	Richard Huxton	07:06
(trigger function) -> ERROR: NEW used in non-rule query	Terence Kearns	08:22
Re: (trigger function) -> ERROR: NEW used in non-rule query	Richard Huxton	09:03
Re: (trigger function) -> ERROR: NEW used in non-rule query	Terence Kearns	09:18
Re: (trigger function) -> ERROR: NEW used in non-rule query	Richard Huxton	13:06
How to determine the currently logged on username	Chris Travers	13:41
Re: How to determine the currently logged on username	Richard Huxton	14:25
How access to array component	Cristian Cappo	14:52
plpgsql strangeness with select into <variable>	Reinoud van Leeuwen	15:24
Re: [HACKERS] plpgsql strangeness with select into <variable>	Josh Berkus	16:14
Re: [HACKERS] plpgsql strangeness with select into <variable>	Stephan Szabo	16:19
Re: (trigger function) -> ERROR: NEW used in non-rule query	Josh Berkus	16:38
Re: (trigger function) -> ERROR: NEW used in non-rule query	Dmitry Tkach	16:49
Re: plpgsql strangeness with select into <variable>	Robert Treat	17:55
how to copy table to another database?	Yudie	20:47
Re: how to copy table to another database?	scott.marlowe	20:58
Re: how to copy table to another database?	Dmitry Tkach	21:06
casting to arrays	Mike Rylander	21:07
Re: casting to arrays	Joe Conway	21:34
Re: ODBC query problem AGAIN	Maksim Likharev	21:50
Re: casting to arrays	Mike Rylander	22:29
Re: [GENERAL] ODBC query problem AGAIN	Luis Magaña	22:42
Re: casting to arrays	Joe Conway	22:47
Re: (trigger function) -> ERROR: NEW used in non-rule query	Terence Kearns	23:13

July 19, 2003

Thread	Author	Time
Re: plpgsql strangeness with select into <variable>	Philip Warner	14:23
Re: casting to arrays	Greg Stark	23:11

Browse Archives

Prev | Next