pgsql-sql since 2003-04-02 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 2, 2003

Thread Author Time
Rows as Columns James Taylor 00:17
Re: How can I quit this: "Unique " to my table? David Witham 00:18
Re: How can I quit this: "Unique " to my table? chester c young 01:17
Re: Rows as Columns chester c young 02:42
pesky plpgsql Walter McGinnis 04:31
pesky plpgsql Walter McGinnis 04:37
Re: pesky plpgsql Tom Lane 06:03
Re: Rows as Columns Joe Conway 06:26
Finding if a temp table exists in the current connection Mike Papper 08:09
string variable with spaces in psql AndreT 10:53
error: lost syncronization with server Jeff Lu 15:19
Re: [SQL] error: lost syncronization with server Tom Lane 15:35
Re: pesky plpgsql Walter McGinnis 17:35

April 3, 2003

Thread Author Time
simple trigger question ... Marc G. Fournier 02:41
Re: simple trigger question ... Tom Lane 03:44
Re: simple trigger question ... Marc G. Fournier 04:06
Re: simple trigger question ... Tom Lane 04:16
Re: simple trigger question ... Marc G. Fournier 04:31
Re: simple trigger question ... Tom Lane 04:33
auto-commit Hugh Krenske 07:23
Syntax problem! mohamed imdadullah 07:55
Re: Syntax problem! Christoph Haller 08:40
Foreign key from another database =?ISO-8859-1?Q?Antti_Ij=E4s?= 09:16
Re: simple trigger question ... Marc G. Fournier 10:12
unsubscribe Jose Luis LG 11:21
Re: Syntax problem! mohamed imdadullah 14:23
Re: simple trigger question ... Rod Taylor 14:26
Re: simple trigger question ... Tom Lane 14:38
Re: pesky plpgsql Walter McGinnis 14:47
Re: auto-commit chester c young 17:09
Re: auto-commit Victor Yegorov 17:34
Re: Foreign key from another database Joe Conway 18:01
Re: pesky plpgsql Josh Berkus 18:01
Re: auto-commit Victor Yegorov 18:38
Re: Foreign key from another database Rod Taylor 18:42
Re: pesky plpgsql Jan Wieck 18:54
Re: pesky plpgsql Josh Berkus 20:00
Re: pesky plpgsql Roberto Mello 20:10
PowerBuilder and identity column Stefan 20:48
can i make this sql query more efficiant? Robert Treat 21:02
Re: PowerBuilder and identity column Dan Langille 21:07
Re: Foreign key from another database CoL 22:09
Re: can i make this sql query more efficiant? Franco Bruno Borghesi 22:15
Re: simple trigger question ... Marc G. Fournier 23:00
Re: can i make this sql query more efficiant? Tomasz Myrta 23:02
Re: can i make this sql query more efficiant? Manfred Koizar 23:13

April 4, 2003

Thread Author Time
More wacky grouping James Taylor 00:29
Re: More wacky grouping Josh Berkus 00:42
Re: pesky plpgsql Walter McGinnis 01:10
Re: pesky plpgsql Roberto Mello 02:09
Re: More wacky grouping Joe Conway 05:58
Re: More wacky grouping Manfred Koizar 07:20
Re: string variable with spaces in psql Christoph Haller 09:21
help yourself by helping others Ali Adams 11:10
Re: Finding if a temp table exists in the current connection Christoph Haller 11:16
Re: Finding if a temp table exists in the current connection Tom Lane 14:58
Re: can i make this sql query more efficiant? Josh Berkus 16:16
Re: [SQL] can i make this sql query more efficiant? Manfred Koizar 19:03
Re: [SQL] can i make this sql query more efficiant? Josh Berkus 19:26
unsubscribe Raj Arya 19:57
Difficult query (for me) Stephane 20:06
timestamp with postgresql 7.3 Claude 20:18
Re: timestamp with postgresql 7.3 Dan Langille 22:01
Re: timestamp with postgresql 7.3 Stephan Szabo 22:05
Re: Difficult query (for me) Lee Harr 22:58

April 5, 2003

Thread Author Time
Re: timestamp with postgresql 7.3 Claude 00:21
UNION and ORDER BY ... IS NULL ASC A.M. 01:58
Re: [SQL] can i make this sql query more efficiant? Manfred Koizar 02:08
Re: UNION and ORDER BY ... IS NULL ASC Stephan Szabo 02:49
Re: UNION and ORDER BY ... IS NULL ASC Josh Berkus 02:52
Re: UNION and ORDER BY ... IS NULL ASC Tom Lane 04:17
unscribe CIC mail 20:47
Re: unsubscribe CIC mail 20:48

April 6, 2003

Thread Author Time
Extraordinary Full Join CN 05:50
UNSCRIBE Hanan Harush 06:04
Re: Extraordinary Full Join Josh Berkus 17:05
Unsubscribe Charles McClain 18:37
Re: Difficult query (for me) Stephane 21:09
Creating a foreign key on the Union of two tables Saad Saeed 21:53

April 7, 2003

Thread Author Time
Re: Extraordinary Full Join CN 04:00
DBD::Pg transaction issues Raj Mathur 04:31
Re: DBD::Pg transaction issues Rajesh Kumar Mallah 07:15
Re: DBD::Pg transaction issues Rajesh Kumar Mallah 07:38
Re: DBD::Pg transaction issues Raj Mathur 08:38
Re: DBD::Pg transaction issues patrick 08:59
Re: DBD::Pg transaction issues Rajesh Kumar Mallah 14:27
Re: Difficult query (for me) David Olbersen 16:32
Re: Difficult query (for me) David Olbersen 16:33
Re: Creating a foreign key on the Union of two tables Rod Taylor 16:48
Re: Creating a foreign key on the Union of two tables Bruno Wolff III 16:50
Re: Creating a foreign key on the Union of two tables Josh Berkus 18:27
Re: Creating a foreign key on the Union of two tables Jan Wieck 21:41

April 8, 2003

Thread Author Time
CASE Rudi Starcevic 08:29
Re: CASE Victor Yegorov 09:40
Language SQL, But Need Return PlPgSql Yudha Setiawan 09:52
create databases with plpgsql sirius 09:54
unsubscribe 2000info 10:51
Re: CASE Rudi Starcevic 10:57
Re: CASE Victor Yegorov 11:09
Re: CASE Rudi Starcevic 11:20
Problem about Triggers and Function Ramesh PAtel 11:22
Re: CASE Greg Stark 12:06
Re: CASE Victor Yegorov 12:13
Re: CASE Tom Lane 14:30
Re: Language SQL, But Need Return PlPgSql Christoph Haller 14:37
help need it rute solipa 14:58
Re: help need it Stephan Szabo 15:16
unsubscribe Antony Gubert 15:41
label rute solipa 15:58
Re: Problem about Triggers and Function Josh Berkus 19:29
Re: help need it Achilleus Mantzios 19:40
Re: [GENERAL] Problem about Triggers and Function Dennis Gearon 19:55
Yet Another (Simple) Case of Index not used Denis 19:57
Re: Yet Another (Simple) Case of Index not used Dennis Gearon 20:25
Re: Yet Another (Simple) Case of Index not used Dann Corbit 20:26
Re: Yet Another (Simple) Case of Index not used Dennis Gearon 20:43
Re: [SQL] Yet Another (Simple) Case of Index not used Josh Berkus 21:52
Re: CASE Rudi Starcevic 23:13
Re: Yet Another (Simple) Case of Index not used Martijn van Oosterhout 23:46

April 9, 2003

Thread Author Time
Re: [GENERAL] Yet Another (Simple) Case of Index not used Denis @ Next2Me 00:10
Re: [SQL] Yet Another (Simple) Case of Index not used Denis @ Next2Me 00:21
Re: Yet Another (Simple) Case of Index not used Brent Wood 00:44
Re: [SQL] Yet Another (Simple) Case of Index not used Stephan Szabo 01:59
Re: [SQL] Yet Another (Simple) Case of Index not used Christopher Kings-Lynne 02:35
Re: [GENERAL] Yet Another (Simple) Case of Index not used Martijn van Oosterhout 03:18
Re: CASE Tom Lane 04:47
Re: CASE Rudi Starcevic 04:59
Re: [GENERAL] Yet Another (Simple) Case of Index not used Denis @ Next2Me 05:54
question about visibilty while updating multiple rows . Rajesh Kumar Mallah 07:17
Getting NEW and OLD in ordinary functions. Rajesh Kumar Mallah 10:21
Re: Getting NEW and OLD in ordinary functions. Rajesh Kumar Mallah 11:12
Re: Language SQL, But Need Return PlPgSql Rajesh Kumar Mallah 11:23
Re: DBD::Pg transaction issues Chris Gamache 12:46
unsubscribe Charles McClain 13:28
Concatenating does not work properly Michal Taborsky 14:14
Concatenating not working properly Michal Taborsky 14:54
Re: question about visibilty while updating multiple rows . Tom Lane 15:12
Re: Concatenating not working properly Tomasz Myrta 15:17
Re: Concatenating not working properly Joe Conway 15:18
Re: [SQL] Yet Another (Simple) Case of Index not used Josh Berkus 16:18
Re: Getting NEW and OLD in ordinary functions. Josh Berkus 16:45
Re: Getting NEW and OLD in ordinary functions. mallah 18:03
Re: Getting NEW and OLD in ordinary functions. Josh Berkus 18:23
Re: Getting NEW and OLD in ordinary functions. mallah 19:09
Re: Getting NEW and OLD in ordinary functions. Josh Berkus 19:13
asymetric cryptography Franco Bruno Borghesi 21:43

April 10, 2003

Thread Author Time
Re: Concatenating does not work properly Lee Harr 01:00
unsubscrube dnaren 03:15
Re: question about visibilty while updating multiple rows . Rajesh Kumar Mallah 04:41
The need to know if a field is using/connected to a sequence Ries van Twisk 06:36
Re: The need to know if a field is using/connected to a sequence A.Bhuvaneswaran 08:25
Re: auto-commit Olleg Samojlov 09:12
Re: create databases with plpgsql Olleg Samojlov 09:14
estimates for nested loop very wrong? joostje 11:21
Re: The need to know if a field is using/connected to a sequence Ries van Twisk 12:24
Re: Extraordinary Full Join Christoph Haller 13:21
Re: estimates for nested loop very wrong? Stephan Szabo 14:17
Re: estimates for nested loop very wrong? Tom Lane 14:17
INSERT INTO ... SELECT (PostgreSQL vs. MySQL) Ian Barwick 14:27
Trigger Stefan Sturm 14:58
Re: INSERT INTO ... SELECT (PostgreSQL vs. MySQL) Stephan Szabo 15:01
Re: INSERT INTO ... SELECT (PostgreSQL vs. MySQL) Rod Taylor 15:10
Re: INSERT INTO ... SELECT (PostgreSQL vs. MySQL) Tom Lane 15:16
Re: INSERT INTO ... SELECT (PostgreSQL vs. MySQL) Rod Taylor 15:40
Re: Trigger A.Bhuvaneswaran 16:07
Re: INSERT INTO ... SELECT (PostgreSQL vs. MySQL) Jan Wieck 16:09
Re: Trigger Franco Bruno Borghesi 16:12
Re: estimates for nested loop very wrong? joostje 16:29
Re: estimates for nested loop very wrong? Tom Lane 16:44
Re: INSERT INTO ... SELECT (PostgreSQL vs. MySQL) Ian Barwick 17:35
Re: Trigger Richard Huxton 17:54
Re: estimates for nested loop very wrong? joostje 19:45
Re: estimates for nested loop very wrong? Tom Lane 20:23
Re: estimates for nested loop very wrong? Tom Lane 20:47
Re: estimates for nested loop very wrong? Antti Haapala 20:50
Re: estimates for nested loop very wrong? joostje 22:20

April 11, 2003

Thread Author Time
unsubscrube CIC mail 00:56
unsubscribe 2000info 04:16
count(*), EXISTS, indexes Itai Zukerman 20:39
Re: count(*), EXISTS, indexes Josh Berkus 20:53
Re: count(*), EXISTS, indexes Itai Zukerman 21:06
Re: count(*), EXISTS, indexes Tom Lane 21:10
Re: count(*), EXISTS, indexes Itai Zukerman 21:22
Re: count(*), EXISTS, indexes Itai Zukerman 21:32
Re: count(*), EXISTS, indexes Josh Berkus 21:42
Re: count(*), EXISTS, indexes Itai Zukerman 22:02
SELECT INTO TEMP in Trigger? Itai Zukerman 22:05
Re: count(*), EXISTS, indexes Tom Lane 22:11
Re: count(*), EXISTS, indexes Stephan Szabo 22:12
Re: SELECT INTO TEMP in Trigger? Dan Langille 22:15
Re: SELECT INTO TEMP in Trigger? Itai Zukerman 22:15
Re: count(*), EXISTS, indexes Itai Zukerman 22:18
Re: count(*), EXISTS, indexes Josh Berkus 22:36

April 12, 2003

Thread Author Time
Re: count(*), EXISTS, indexes Tom Lane 00:00
Re: count(*), EXISTS, indexes Itai Zukerman 04:01

April 13, 2003

Thread Author Time
sort up then down Randolph Jones 01:50
SELECT Blobs into Delphi program Daniel Seichter 19:50
SELECT Blobs into a delphi program Daniel Seichter 20:05
Re: sort up then down Tom Lane 23:01

April 14, 2003

Thread Author Time
How Do I Hide Trigger ?? Yudha Setiawan 01:36

Browse Archives

Prev | Next