pgsql-sql since 2004-04-16 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

April 16, 2004

Thread Author Time
Re: Database triggers Charity M 12:32
Re: Update is very slow on a bigger table Dimitar Georgievski 14:40
What is the best way of writing update rule on view with joined tables? Cornelius Grotjahn 17:43
Re: Update is very slow on a bigger table Yudie 17:47
Querying From two databases Pallav Kalva 17:55
Querying two databases Pallav Kalva 18:02
Re: Querying two databases Rajesh Kumar Mallah 18:37
run application from trigger? Yudie 20:21

April 17, 2004

Thread Author Time
ANN: www.SQL-Scripts.Com Greg 05:45
Re: run application from trigger? Richard Huxton 09:37
Re: Update is very slow on a bigger table Bruno Wolff III 15:13

April 18, 2004

Thread Author Time
Concatenate results of a single column query Marco Lazzeri 14:36
Concatenate results of a single column query Marco Lazzeri 15:44
Re: Concatenate results of a single column query Greg Stark 17:42
Re: problem porting MySQL SQL to Postgres Markus Bertheau 18:37
Re: problem porting MySQL SQL to Postgres Paul Thomas 19:24

April 19, 2004

Thread Author Time
Re: problem porting MySQL SQL to Postgres Bruno Wolff III 03:21
three-way join Gary Stainburn 12:47
Re: Concatenate results of a single column query Greg Stark 13:45
Re: three-way join Stijn Vanroye 14:06
Re: three-way join Gary Stainburn 15:01
Re: Concatenate results of a single column query Christoph Haller 15:15
Re: Update is very slow on a bigger table scott.marlowe 15:33
Re: Concatenate results of a single column query CoL 15:47
Prepared Statements and large where-id-in constant blocks? James Robinson 15:56
Re: three-way join - solved Gary Stainburn 16:13
Re: three-way join Bruno Wolff III 17:45
Re: Querying From two databases Bruce Momjian 18:30
Re: [SQL] SQL script scott.marlowe 20:17
Can someone tell me why this statement is failing? P A 20:31
Re: Prepared Statements and large where-id-in constant blocks? Oliver Jowett 22:21

April 20, 2004

Thread Author Time
Re: [SQL] Prepared Statements and large where-id-in constant blocks? Tom Lane 01:02
Re: relation X does not exist Tom Lane 01:11
Re: Prepared Statements and large where-id-in constant blocks? Oliver Jowett 02:57
Re: three-way join - solved Stijn Vanroye 07:26
Re: Can someone tell me why this statement is failing? Martin Marques 14:40
Re: Can someone tell me why this statement is failing? Edmund Bacon 14:42
Re: Can someone tell me why this statement is failing? Rod Taylor 15:32
Re: Prepared Statements and large where-id-in constant blocks? James Robinson 15:35
transaction H.J. Sanders 19:14
Follow-up: FK constraint performance ow 19:25
Syntax for cmd to EXEC...how many quotes? David B 23:24

April 21, 2004

Thread Author Time
Re: transaction Bruno Wolff III 02:00
staggered query? Vincent Ladlad 02:53
Re: Follow-up: FK constraint performance ow 03:45
Re: staggered query? Denis P Gohel 07:11
Re: transaction denis 07:28
Re: Syntax for cmd to EXEC...how many quotes? denis 08:44
Re: Can someone tell me why this statement is failing? denis 08:53
Re: transaction Andrew Sullivan 10:13
Order by YYYY MM DD in reverse chrono order trouble ogjunk-pgjedan 10:30
Re: Order by YYYY MM DD in reverse chrono order trouble Stijn Vanroye 10:58
Re: Order by YYYY MM DD in reverse chrono order trouble denis 11:36
Re: Syntax for cmd to EXEC...how many quotes? George Weaver 12:20
Re: Order by YYYY MM DD in reverse chrono order trouble ogjunk-pgjedan 12:20
datediff script Erik Aronesty 14:13
Trigger calling a function HELP ME! abief_ag_-postgresql 14:43
Re: Order by YYYY MM DD in reverse chrono order trouble Edmund Bacon 14:52
Trigger calling a function HELP ME! (2) Riccardo Facchini 14:54
Which SQL command creates ExclusiveLock? Denis Khabas 14:58
problem with slow select francescosaf 15:00
Trigger calling a function HELP ME! (2) abief_ag_-postgresql 15:16
Server Side C programming Environment Set up Kemin Zhou 17:57
Re: transaction Bruno Wolff III 18:02
Join issue on a maximum value Heflin 18:29
Re: Join issue on a maximum value Bruno Wolff III 18:51
Re: Join issue on a maximum value Jeremy Semeiks 19:12
Re: Join issue on a maximum value Edmund Bacon 19:21
rule's behavior with join interesting Kemin Zhou 20:07
Re: Join issue on a maximum value Heflin 20:28
Proper SQL syntax requested Blake 23:41

April 22, 2004

Thread Author Time
Re: Join issue on a maximum value Bruno Wolff III 01:51
Re: Join issue on a maximum value Tom Lane 03:30
Re: Server Side C programming Environment Set up Peter Eisentraut 05:18
Re: Server Side C programming Environment Set up Tom Lane 05:59
Select from two databases Becky Alcorn 07:00
Re: staggered query? Vincent Ladlad 08:44
Bug#960: WAS: Trigger calling a function HELP ME! (2) abief_ag_-postgresql 09:41
Re: rule's behavior with join interesting Richard Huxton 09:49
Re: Select from two databases Richard Huxton 09:50
Re: Order by YYYY MM DD in reverse chrono order trouble ogjunk-pgjedan 09:56
Re: Order by YYYY MM DD in reverse chrono order trouble Stijn Vanroye 10:47
Re: Trigger calling a function HELP ME! (2) Richard Huxton 11:19
Re: Order by YYYY MM DD in reverse chrono order trouble Tom Lane 13:01
Re: Order by YYYY MM DD in reverse chrono order trouble ogjunk-pgjedan 13:37
Re: Server Side C programming Environment Set up Rod Taylor 13:58
Re: Server Side C programming Environment Set up Peter Eisentraut 14:07
Re: Server Side C programming Environment Set up Peter Eisentraut 14:11
Re: Server Side C programming Environment Set up Rod Taylor 14:21
Design Problem... Ryan Riehle 15:09
Re: Server Side C programming Environment Set up Tom Lane 16:07
Re: Server Side C programming Environment Set up Kemin Zhou 16:09
Re: Server Side C programming Environment Set up Tom Lane 16:13
lifetime of temp schema versus compiled image of plpgsql proc Dennis 19:29
Re: rule's behavior with join interesting Jan Wieck 19:57
Re: staggered query? Federico Pedemonte 20:09
Cascade delete question Glenn MacGregor 21:23
Re: lifetime of temp schema versus compiled image of plpgsql proc Dennis 21:32
Is there an easy way to normalize-space with given string functions Janning Vygen 22:59
Re: lifetime of temp schema versus compiled image of plpgsql proc Bruce Momjian 23:46
Re: lifetime of temp schema versus compiled image of plpgsql proc Bruce Momjian 23:54

April 23, 2004

Thread Author Time
Re: lifetime of temp schema versus compiled image of plpgsql proc Tom Lane 02:06
Re: lifetime of temp schema versus compiled image of plpgsql proc Tom Lane 02:16
Re: Is there an easy way to normalize-space with given string functions Tom Lane 02:34
Re: staggered query? Greg Stark 04:37
Re: Order by YYYY MM DD in reverse chrono order trouble Stijn Vanroye 07:14
Re: Order by YYYY MM DD in reverse chrono order trouble ogjunk-pgjedan 07:53
Record Lock details Denis P Gohel 08:43
Re: Server Side C programming Environment Set up Peter Eisentraut 08:45
converting unix seconds to timestamp Alexei Chetroi 08:46
Re: Is there an easy way to normalize-space with given string functions Janning Vygen 09:37
Re: Record Lock details Peter Eisentraut 10:03
Re: converting unix seconds to timestamp Alexei Chetroi 10:17
Re: Server Side C programming Environment Set up Tom Lane 12:01
Re: Server Side C programming Environment Set up Bruce Momjian 13:18
CONTEXT on PL/pgSQL Martin Marques 13:18
Multi ordered select and indexing Antal Attila 13:32
Re: CONTEXT on PL/pgSQL Tom Lane 14:18
Multi ordered select and indexing Antal Attila 14:33
Re: CONTEXT on PL/pgSQL Martin Marques 15:07
Re: Multi ordered select and indexing Stephan Szabo 16:41
Re: Multi ordered select and indexing Bruno Wolff III 17:37
Postgres DB Sumita Biswas 18:10
Re: lifetime of temp schema versus compiled image of plpgsql proc Jaime Casanova 21:10

April 24, 2004

Thread Author Time
Re: Trigger calling a function HELP ME! (2) Riccardo G. Facchini 05:50
Re: Order by YYYY MM DD in reverse chrono order trouble Greg Sabino Mullane 11:16
Postgres backend to backup system Kent L. Nasveschuk 15:14
Re: Design Problem... Greg Sabino Mullane 16:54
Question re: serial Michael Satterwhite 17:24
Re: Question re: serial Devrim GUNDUZ 17:37
Re: Question re: serial Bruno Wolff III 17:44

April 25, 2004

Thread Author Time
Python connection Michael Satterwhite 16:29

April 26, 2004

Thread Author Time
Re: Trigger calling a function HELP ME! (2) Riccardo G. Facchini 07:47
Re: Python connection Karsten Hilbert 08:29
Own opclass and LIKE problem again! Antal Attila 10:07
Own opclass and LIKE problem again! Atesz 10:11
SQL Query Timeouts Dan Field 11:08
Re: Join issue on a maximum value Atesz 13:05
Re: problem with slow select Rod Taylor 18:58

April 27, 2004

Thread Author Time
Logical comparison on Strings kumar 06:13
Customised Encoding kumar 06:54
Postgres as backend to Backup System Kent L. Nasveschuk 08:39
Performance issue Michael L. Hostbaek 09:12
Problem with a "blocking period" Trigger Marcus Krause 09:55
Re: Logical comparison on Strings Rajesh Kumar Mallah 10:16
Re: Performance issue Paul Thomas 11:42
Re: How to get binary value for an Integer Achilleus Mantzios 11:51
Re: Proper SQL syntax requested Richard Huxton 12:06
Re: Customised Encoding Richard Huxton 12:09
How to get binary value for an Integer kumar 12:26
Re: Customised Encoding Richard Huxton 13:16
query optimizer dont treat correctly OR Luiz Rafael Culik Guimaraes 14:48
Re: [SQL] query optimizer dont treat correctly OR Richard Huxton 15:35
Re: [SQL] Postgres as backend to Backup System Kent L. Nasveschuk 18:10
Re: [SQL] Postgres as backend to Backup System Kent L. Nasveschuk 18:59
SELECTing part of a matrix Tony Reina 19:12

April 28, 2004

Thread Author Time
date arithmetic over calender year boundaries Ray Jackson 04:12
Re: Which SQL command creates ExclusiveLock? Tom Lane 04:16
Re: Customised Encoding kumar 06:18
Re: date arithmetic over calender year boundaries Bruno Wolff III 06:48
select distinct and order by Stijn Vanroye 09:27
Re: select distinct and order by Viorel Dragomir 09:54
Re: select distinct and order by Stijn Vanroye 10:34
Bacula cookfire 13:23

April 29, 2004

Thread Author Time
Equivalant of SQL Server's Nchar and NVARCHAR kumar 10:11
Re: Equivalant of SQL Server's Nchar and NVARCHAR Karsten Hilbert 13:05
Re: Multi ordered select and indexing Christoph Haller 13:35
Re: Equivalant of SQL Server's Nchar and NVARCHAR Rob 14:18
Use arrays or not? Roelant Ossewaarde 16:41
Re: Use arrays or not? Josh Berkus 17:23
Check a value in array Marco Lazzeri 17:37
Re: Check a value in array Rod Taylor 17:56
Re: Equivalant of SQL Server's Nchar and NVARCHAR Josh Berkus 19:20
Re: Multi ordered select and indexing Tom Lane 19:34
Re: Use arrays or not? Roelant Ossewaarde 20:26
Re: Use arrays or not? Josh Berkus 20:47
Permissions not working Pallav Kalva 20:53
Re: Permissions not working scott.marlowe 21:26
Re: Permissions not working Pallav Kalva 21:45
Re: Permissions not working scott.marlowe 21:59
isnumeric() function? Yudie 22:46
Re: Permissions not working Tom Lane 23:07

April 30, 2004

Thread Author Time
Problem in SQL Trigger 📎 Ramesh Patel 04:48
Re: Use arrays or not? Achilleus Mantzios 05:49
Re: isnumeric() function? CoL 07:14
Re: Check a value in array Marco Lazzeri 08:18
Re: problem with slow select francescosaf 09:25
Re: Check a value in array CoL 12:14
Re: Permissions not working Pallav Kalva 13:37
Re: isnumeric() function? Jeff Eckermann 14:11
Re: Problem in SQL Trigger Rajesh Kumar Mallah 14:14
Database structure Alain Reymond 15:06
Re: isnumeric() function? Yudie 15:29
Re: Permissions not working Tom Lane 16:19
Re: isnumeric() function? Frank Bax 16:24
Re: Permissions not working Pallav Kalva 18:00
invalid input syntax for integer: "" Sebastian Tewes 22:44

May 1, 2004

Thread Author Time
Re: Performance issue Tom Lane 04:37
Rank Muhyiddin A.M Hayat 13:30
Re: isnumeric() function? Jeff Eckermann 14:29

Browse Archives

Prev | Next