pgsql-sql since 2003-04-03 23:02

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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

April 3, 2003

Thread Author Time
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
Re: How Do I Hide Trigger ?? Christoph Haller 11:16
REPLACE Radovan Petrikí 12:50
REPLACE Rado Petrik 13:09
Re: How Do I Hide Trigger ?? Guy Fraser 14:30
Re: REPLACE Franco Bruno Borghesi 15:20
connecting to a differnt DB in PL/pgSQL friedrich nietzsche 15:29
Re: connecting to a differnt DB in PL/pgSQL Tomasz Myrta 15:45
Re: connecting to a differnt DB in PL/pgSQL Franco Bruno Borghesi 17:16
help with query!!! mdc@keko.com.ar 22:07
Re: help with query!!! Franco Bruno Borghesi 22:41
Re: help with query!!! Stephan Szabo 23:29
Re: help with query!!! Tom Lane 23:34

April 15, 2003

Thread Author Time
fast case-insensitive sort Sigi Jekabsons 00:49
Re: fast case-insensitive sort Stephan Szabo 02:21
Re: fast case-insensitive sort Sigi Jekabsons 02:40
Re: fast case-insensitive sort Tom Lane 05:54
Re: fast case-insensitive sort Sigi Jekabsons 06:28
Re: fast case-insensitive sort Tom Lane 06:38
atomatic insert date and time Rado Petrik 08:58
Re: atomatic insert date and time jasiek 09:50
ordering problems ... David Goodwin 10:33
Re: ordering problems ... David Goodwin 10:47
Re: help with query!!! mdc@keko.com.ar 13:03
Re: ordering problems ... Tom Lane 13:49
changing column size and type. pginfo 14:21
Re: [PERFORM] Yet Another (Simple) Case of Index not used Bruce Momjian 14:23
Percentage of Total Occurances Adam Sherman 14:53
help need it rute solipa 15:52
Re: [PERFORM] Yet Another (Simple) Case of Index not used Richard Huxton 16:29
accent problems Pedro Igor Craveiro e Silva 17:00
Re: Percentage of Total Occurances mallah 17:10
plpgsql Zodiac 17:32
Re: plpgsql mallah 17:37
Re: plpgsql Jan Wieck 17:52
What is the scope of a temp table? Guy Fraser 18:38
Re: Percentage of Total Occurances Adam Sherman 18:59
plpgsql slow in 7.3 ???? Fernando Eduardo Carvalho 19:29
Re: Percentage of Total Occurances mallah 19:41
Re: SELECT INTO TEMP in Trigger? Bruce Momjian 21:36
reversion? Recursion question Patrick Hatcher 22:41
Re: changing column size and type. George Weaver 23:13

April 16, 2003

Thread Author Time
Re: reversion? Recursion question Brad Hilton 00:00
Re: Percentage of Total Occurances Adam Sherman 04:38
Re: changing column size and type. pginfo 04:43

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30