pgsql-sql since 2003-04-10 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
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 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
Re: What is the scope of a temp table? A.Bhuvaneswaran 05:21
Re: plpgsql Rajesh Kumar Mallah 05:26
Re: changing column size and type. Rudi Starcevic 05:57
Re: connecting to a differnt DB in PL/pgSQL friedrich nietzsche 07:54
Re: changing column size and type. pginfo 09:16
HELP rute solipa 10:28
Re: changing column size and type. pginfo 12:52
Re: changing column size and type. Rudi Starcevic 13:09
unsubscribe Ricardo Javier Aranibar León 22:20

April 17, 2003

Thread Author Time
Equivalent of inet type for phone number? David Stanaway 05:53
analyse question.. Rajesh Kumar Mallah 08:21
planner question.. Rajesh Kumar Mallah 08:34
Re: IN Qeury Problem Rajesh Kumar Mallah 10:00
getting rid of "Adding missing FROM-clause entry...." Rajesh Kumar Mallah 10:27
1st Posgresql Dump for Win ! Mr.F 11:15
Re: getting rid of "Adding missing FROM-clause entry...." Rajesh Kumar Mallah 12:18
Re: getting rid of "Adding missing FROM-clause entry...." Christoph Haller 13:20
Re: getting rid of "Adding missing FROM-clause entry...." Rajesh Kumar Mallah 13:45
Re: planner question.. Stephan Szabo 13:51
Re: planner question.. Rajesh Kumar Mallah 13:57
Re: getting rid of "Adding missing FROM-clause entry...." Christoph Haller 14:09
Re: planner question.. Stephan Szabo 14:12
Re: analyse question.. Tom Lane 14:17
OUTER JOIN Marco Roda 14:21
Re: planner question.. Tom Lane 14:26
OUTER JOIN Marco Roda 14:30
Re: OUTER JOIN Patrik Kudo 14:37
Re: getting rid of "Adding missing FROM-clause entry...." Rajesh Kumar Mallah 14:51
Re: analyse question.. Rajesh Kumar Mallah 14:56
Re: planner question.. Rajesh Kumar Mallah 15:10
Re: planner question.. Rajesh Kumar Mallah 15:12
Re: What is the scope of a temp table? Guy Fraser 15:18
Re: getting rid of "Adding missing FROM-clause entry...." Manfred Koizar 15:30
Re: getting rid of "Adding missing FROM-clause entry...." Rajesh Kumar Mallah 15:52
Re: getting rid of "Adding missing FROM-clause entry...." Manfred Koizar 16:02
Re: analyse question.. Tom Lane 16:04
Re: planner question.. Tom Lane 16:10
Re: getting rid of "Adding missing FROM-clause entry...." Manfred Koizar 16:52
Ordinal value of row within set returned by a query? Randall Lucas 18:01
Re: IN Qeury Problem Wei Weng 18:30
Re: reversion? Recursion question David Goodwin 19:08
IN Qeury Problem Sameer Maggon 19:27
Re: Ordinal value of row within set returned by a query? Tom Lane 19:35
Re: Ordinal value of row within set returned by a query? Randall Lucas 20:50

April 18, 2003

Thread Author Time
Deadlock problem Tzvetan Tzankov 09:06
converting from bigint to bit to use bitwise operators Aditya 19:11
How to retrieve object definition? Yudie 20:57
Suggestion: Need conversion-testing functions. Josh Berkus 21:07
Truly bizarre behavior with VACUUM FULL? Josh Berkus 22:25
New to SQL; hopefully simple question foo2 22:58

April 19, 2003

Thread Author Time
Re: Truly bizarre behavior with VACUUM FULL? Tom Lane 00:13
Re: Truly bizarre behavior with VACUUM FULL? Josh Berkus 01:49
Re: Truly bizarre behavior with VACUUM FULL? Tom Lane 01:54
apparent problem with a PL Rajesh Kumar Mallah 05:59
replicable problem with PL/Perl Rajesh Kumar Mallah 06:46
Re: apparent problem with a PL Stephan Szabo 06:50
Re: How to retrieve object definition? A.Bhuvaneswaran 06:55
Re: apparent problem with a PL Rajesh Kumar Mallah 07:08
Where is the sequence value? Edipo E. F. Melo 11:50
Where is the sequence value? Edipo E. F. Melo 11:50
Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown 13:01
Re: Where is the sequence value? Tom Lane 15:51
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 15:58
[REPOST] replicable problem with PL/Perl Rajesh Kumar Mallah 16:06
Re: apparent problem with a PL Stephan Szabo 16:30
Re: replicable problem with PL/Perl Tom Lane 16:34
Re: apparent problem with a PL Rajesh Kumar Mallah 16:42
Re: replicable problem with PL/Perl Rajesh Kumar Mallah 16:42
Re: [SQL] Yet Another (Simple) Case of Index not used Josh Berkus 19:03
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 20:26

April 20, 2003

Thread Author Time
Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown 01:13
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 03:34
Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown 06:28
Re: [SQL] Yet Another (Simple) Case of Index not used Andreas Pflug 10:07
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 15:21
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 15:25
Re: [SQL] Yet Another (Simple) Case of Index not used Andreas Pflug 15:37
Re: [SQL] Yet Another (Simple) Case of Index not used Andrew Sullivan 16:46
Re: replicable problem with PL/Perl Tom Lane 22:29

April 21, 2003

Thread Author Time
Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown 00:46
Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane 01:53
Ok,, what about cache for SEQUENCE - where? how? foo2 04:25
Re: New to SQL; hopefully simple question foo2 04:28
Optomizing left outer joins Lorraine Dewey 15:14
Re: [SQL] Yet Another (Simple) Case of Index not used Josh Berkus 16:14
functions problems Mario Alberto Soto Cordones 20:48
Re: functions problems Randall Lucas 21:24
PROBLEM WITH FUNCTIONS Mario Alberto Soto Cordones 21:38
Re: PROBLEM WITH FUNCTIONS Randall Lucas 21:46
converting from bigint to bit to use bitwise operators Aditya 21:50
Re: converting from bigint to bit to use bitwise operators Randall Lucas 21:55
Re: PROBLEM WITH FUNCTIONS Mario Alberto Soto Cordones 21:58

April 22, 2003

Thread Author Time
trouble creating trigger Sigi Jekabsons 02:28
Re: trouble creating trigger Stephan Szabo 03:58
Re: [SQL] Yet Another (Simple) Case of Index not used Jim C. Nasby 08:23
Re: [SQL] Yet Another (Simple) Case of Index not used Christopher Kings-Lynne 08:33
RelationForgetRelation error in postgres 7.2.2 Bharath Seshadri 10:00
Re: trouble creating trigger A.Bhuvaneswaran 12:20
SQL Reserved words DUDLEY,DONALD (HP-Boise,ex1) 15:57
FUNCTION ERROR Mario Alberto Soto Cordones 21:17
Re: FUNCTION ERROR Stephan Szabo 21:24

April 23, 2003

Thread Author Time
how to put an special code in a string jack 02:33

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