pgsql-sql before 2004-05-12 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

April 23, 2004

Thread Author Time
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
Rank Muhyiddin A.M Hayat 18:22
Re: Permissions not working Peter Eisentraut 21:13

May 2, 2004

Thread Author Time
double left outer join on the same table T E Schmitz 16:23
Re: double left outer join on the same table Adam Witney 16:44
Re: double left outer join on the same table T E Schmitz 17:09

May 3, 2004

Thread Author Time
an indexing problem on postgreSQL jwang 10:55
\D TO FILE Eric Anderson Vianet SAO 11:49
Re: \D TO FILE Geoffrey 12:32
Re: \D TO FILE Paul Thomas 12:34
Re: [SPAM] Re: Permissions not working Pallav Kalva 13:33
Re: [SPAM] Re: Permissions not working Tom Lane 14:23
Re: [SPAM] Re: Permissions not working Pallav Kalva 15:06
Re: \D TO FILE Arne Stoelck 15:36
returning multiple values and ref cursors Dennis 17:40
Re: [SPAM] Re: Permissions not working Peter Eisentraut 17:55
Re: [SPAM] Re: Permissions not working Pallav Kalva 18:28
start H.J. Sanders 19:36
Re: start Peter Eisentraut 19:56
Re: start scott.marlowe 20:16

May 4, 2004

Thread Author Time
Procedure failing after upgrade patkins 13:32
typecasting numeric(18,4) to varchar/text [email protected] 13:35
Re: Rank Martin Knipper 13:42
Re: Rank george young 14:11
Re: start Andrei Bintintan 14:20
Re: Database structure Andrei Bintintan 14:37
Re: typecasting numeric(18,4) to varchar/text Andrew Sullivan 14:37
Re: invalid input syntax for integer: "" scott.marlowe 14:58
Re: Check a value in array Contact AR-SD.NET 15:03
Re: typecasting numeric(18,4) to varchar/text Martin Knipper 15:08
Re: Rank Martin Knipper 15:14
Re: returning multiple values and ref cursors Dennis 15:28
Re: Database structure Alain Reymond 15:45
Re: Database structure Svenne Krap 16:10
Re: Database structure Bruno Wolff III 16:25
Re: Rank Rob 16:47
Re: Rank Martin Knipper 17:39

May 5, 2004

Thread Author Time
Test - please ignore Richard Huxton 12:21
COUNT on a DISTINCT query Freddy Villalba Arias 14:57
not really SQL but I need info on BLOBs Theodore Petrosky 15:10
Re: Procedure failing after upgrade Jie Liang 17:20
Re: Procedure failing after upgrade Rod Taylor 17:49
Re: Procedure failing after upgrade Tom Lane 19:46

May 6, 2004

Thread Author Time
Re: not really SQL but I need info on BLOBs Andrei Bintintan 05:27
Subselect returning 2 columns Francesc Leveque 08:52
Re: not really SQL but I need info on BLOBs Theodore Petrosky 11:46
new and old as parameter in a function Riccardo G. Facchini 12:24
Re: new and old as parameter in a function Tom Lane 12:51
Re: not really SQL but I need info on BLOBs Andrew Sullivan 12:55
Re: not really SQL but I need info on BLOBs Andrei Bintintan 13:06

May 7, 2004

Thread Author Time
Re: Subselect returning 2 columns Tom Lane 01:26
Re: SUM() & GROUP BY Martin Kuria 06:47
Re: SUM() & GROUP BY Richard Huxton 08:00
EXPORT / IMPORT Freddy Villalba Arias 08:20
Re: EXPORT / IMPORT Jerome Alet 08:38
Display format for column Abdul Wahab Dahalan 09:08
Re: Display format for column Karel Zak 09:58
Re: EXPORT / IMPORT Andrew Sullivan 11:16