pgsql-sql - May 2004

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

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
Re: not really SQL but I need info on BLOBs	Jeff Boes	11:29
Re: SUM() & GROUP BY	Martin Kuria	11:32
SELECT - ORDER BY Croatian characters ....	Kornelije	11:51
Re: SUM() & GROUP BY	Richard Huxton	13:25
Re: COUNT on a DISTINCT query	Suller András	14:19
Re: SUM() & GROUP BY	Jean-Luc Lachance	17:31
Re: SELECT - ORDER BY Croatian characters ....	Peter Eisentraut	18:39
\df	Jie Liang	23:15
Re: \df	Yasir Malik	23:29
Re: \df	Stefan Weiss	23:39
Re: \df	Jie Liang	23:47
Re: CONTEXT on PL/pgSQL	Gaetano Mendola	23:50

May 8, 2004

Thread	Author	Time
Re: SELECT - ORDER BY Croatian characters ....	Kornelije Rabuzin	09:54
Re: techniques for manual ordering of data ?	Bruno Wolff III	16:36
Adding MERGE to the TODO list (resend with subject)	elein	21:37
Re: Adding MERGE to the TODO list (resend with subject)	Bruce Momjian	22:46
Re: Adding MERGE to the TODO list (resend with subject)	elein	23:19

May 9, 2004

Thread	Author	Time
Re: Adding MERGE to the TODO list (resend with subject)	Christopher Kings-Lynne	01:50
Re: Adding MERGE to the TODO list (resend with subject)	Alvaro Herrera	03:54
Re: Adding MERGE to the TODO list (resend with subject)	Christopher Kings-Lynne	04:13
Re: Adding MERGE to the TODO list (resend with subject)	Alvaro Herrera	05:18
Re: Adding MERGE to the TODO list (resend with subject)	Christopher Kings-Lynne	05:32
Re: not really SQL but I need info on BLOBs	Denis Braekhus	12:43
Re: Adding MERGE to the TODO list (resend with subject)	Alvaro Herrera	16:09

May 10, 2004

Thread	Author	Time
Trigger function to know which fields are being updated	Bernard Cheung	02:47
Re: Adding MERGE to the TODO list (resend with subject)	Bruce Momjian	03:58
working with schema	William Anthony Lim	08:10
Re: not really SQL but I need info on BLOBs	Theodore Petrosky	11:41
Re: working with schema	Christoph Haller	12:49
Exceptions when 0 rows affected.	Stef	13:08
Re: Adding MERGE to the TODO list (resend with subject)	Bricklen	14:11
Re: Adding MERGE to the TODO list (resend with subject)	Hannu Krosing	21:23
Re: Adding MERGE to the TODO list (resend with subject)	Bruce Momjian	21:26
Re: Trigger function to know which fields are being updated	Jeff Eckermann	21:38
Re: update table where rows are selected by inner join?	Stephan Szabo	22:09
update table where rows are selected by inner join?	Jeff Kowalczyk	22:13

May 11, 2004

Thread	Author	Time
Subqueries returning more than one value?	Adam Witney	00:09
Re: Subqueries returning more than one value?	CoL	01:43
Re: Exceptions when 0 rows affected.	Andrei Bintintan	06:02
Re: Adding MERGE to the TODO list (resend with subject)	Hannu Krosing	06:59
Re: Trigger function to know which fields are being updated	Bernard Cheung	07:09
Re: Trigger function to know which fields are being updated	Riccardo Facchini	07:46
Seconds To Time	Willem de Jong	08:08
Re: Adding MERGE to the TODO list (resend with subject)	Bruce Momjian	13:44
Re: Trigger function to know which fields are being updated	Jeff Eckermann	13:59
Re: Adding MERGE to the TODO list (resend with subject)	Bruce Momjian	20:23
\set	Jie Liang	23:07

May 12, 2004

Thread	Author	Time
view problem - too many rows out	Gary Stainburn	10:02
Re: [SQL] \set	Christian Kratzer	10:13
Re: working with schema	William Anthony Lim	10:19
How do i extract a certain bit from a bigint column 📎	Mats Sjöberg	11:05
Re: How do i extract a certain bit from a bigint column	Mike Rylander	12:17
Re: How do i extract a certain bit from a bigint column	Tom Lane	12:55
Re: working with schema	scott.marlowe	13:59
solved Re: view problem - too many rows out	Gary Stainburn	14:06
where is this problem (trigger)	Theodore Petrosky	17:57
Re: How do i extract a certain bit from a bigint column	Bruno Wolff III	18:16
Re: [SQL] \set	Jie Liang	21:59
Re: [SQL] \set	Tom Lane	23:05
Re: [SQL] \set	Jie Liang	23:40

May 13, 2004

Thread	Author	Time
Re: working with schema	William Anthony Lim	05:25
Re: a wierd query	Achilleus Mantzios	07:34
Re: a wierd query	sad	07:34
a wierd query	[email protected]	08:07
Re: a wierd query	Silke Trißl	08:41
Re: a wierd query	Peter Childs	09:17
Re: a wierd query	Yasir Malik	13:24
Re: Exceptions when 0 rows affected.	Stef	14:49
Re: a wierd query	Edmund Bacon	15:27
isolation level	Jaime Casanova	18:13
Re: isolation level	Bruno Wolff III	18:24
\d in 7.4.2	Jaime Casanova	21:15
Ignore my last message	Jaime Casanova	21:18
\d in 7.4	Jaime Casanova	21:19

May 14, 2004

Thread	Author	Time
Re: a wierd query	sad	03:45
Re: a wierd query	Stephan Szabo	05:24
Re: isolation level	Greg Stark	05:26
Re: Multiple outer join on same table	Greg Stark	05:40
Re: where is this problem (trigger)	Stephan Szabo	15:06
Re: where is this problem (trigger)	Christoph Haller	16:44
view running query	Eric Anderson Vianet SAO	17:17
Re: [HACKERS] MERGE-esque Functionallity (was: Adding MERGE to the TODO list (resend with subject)) 📎	Mike Rylander	18:04

May 15, 2004

Thread	Author	Time
Re: where is this problem (trigger)	Theodore Petrosky	13:42
Re: where is this problem (trigger)	Jean-Luc Lachance	14:27
Re: where is this problem (trigger)	Theodore Petrosky	14:28

May 16, 2004

Thread	Author	Time
Re: How to speed up a time dimension query	Gaetano Mendola	11:42

May 17, 2004

Thread	Author	Time
Re: a wierd query	sad	07:12
Re: a wierd query	Stijn Vanroye	07:25
Re: a wierd query	Stijn Vanroye	07:31
problem with spanish characters	Freddy Villalba Arias	08:02
Re: a wierd query	Stijn Vanroye	09:24
Re: [JDBC] problem with spanish characters	nahum castro	14:05
Re: view running query	Andrew Hammond	14:32
Replace function ...	Kornelije	14:58
Re: a wierd query	Stephan Szabo	15:01
Max Columns in a SQL Select	PS PS	16:37
Re: Unique Constraint with foreign Key	Karsten Hilbert	16:51
Re: Max Columns in a SQL Select	Richard Huxton	18:06
Re: Replace function ...	Yasir Malik	19:34

May 18, 2004

Thread	Author	Time
Re: a wierd query	Stijn Vanroye	07:56
Any sql repository	T Ullas	08:26
Opening and Fetching from a refcursor inside a function	kumar	12:18
Very slow search using basic pattern matching	Dan Field	15:47
Re: Very slow search using basic pattern matching	Bruno Wolff III	16:12
I'm baffled	hook	16:19
Re: How to speed up a time dimension query	Hans de Bruin	16:56
Re: Very slow search using basic pattern matching	Karsten Hilbert	17:15
Re: I'M Sorry!	Ricardo Maia	18:30
Using "Without OIDs"	Richard Huxton	18:56

May 19, 2004

Thread	Author	Time
Re: Replace function ...	Benoît BOURNON	10:24
Re: a wierd query	Christoph Haller	10:55
Re: Very slow search using basic pattern matching	Dan Field	11:33
Re: Very slow search using basic pattern matching	Raphael A. Bauer	11:51
Preventing Deletions with triggers	Jeff Post	14:19
Function valid only for one table	Martin Knipper	14:42
Re: Function valid only for one table	Richard Huxton	16:33
SCHEMA's the easy way?	Chris Gamache	16:38
Re: SCHEMA's the easy way?	Tom Lane	17:00
Re: Function valid only for one table	Martin Knipper	17:09
rules	Jie Liang	17:20
Re: Replace function ...	Kornelije Rabuzin	17:30
Re: Replace function ...	Kornelije Rabuzin	17:31
Re: Function valid only for one table	Tom Lane	17:33
Re: Function valid only for one table	Martin Knipper	17:41
Re: rules	Jie Liang	17:41
Re: [SQL] rules	Stephan Szabo	17:50

May 20, 2004

Thread	Author	Time
where to start with this procedure ?	Andreas	00:33
Re: where to start with this procedure ?	Andrei Bintintan	07:17
Re: where to start with this procedure ?	Andreas	14:46
Re: where to start with this procedure ?	Stephan Szabo	15:01
XML data field	LSanchez	15:58
OR clause causing strange index performance	Doug Y	17:32
Simple view confuses PostgreSQL query planning	Manuel Sugawara	17:33
Re: OR clause causing strange index performance	Doug Y	17:46
v7.2 triggers and foreign keys	Paul Gimpelj	18:32
Re: Simple view confuses PostgreSQL query planning	Tom Lane	19:06
Re: Simple view confuses PostgreSQL query planning	Manuel Sugawara	21:43

May 21, 2004

Thread	Author	Time
Re: OR clause causing strange index performance	Tom Lane	06:53
Problem with JOINS	Charlie Clark	07:28
Re: v7.2 triggers and foreign keys	Richard Huxton	08:11

Browse Archives

Prev | Next