pgsql-sql since 2007-02-11 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

Feb. 11, 2007

Thread Author Time
Re: Password Policy Christopher Browne 05:18
COPY FROM query. Paul Lambert 23:19
Re: COPY FROM query. Paul Lambert 23:27
Re: COPY FROM query. Joe 23:55

Feb. 12, 2007

Thread Author Time
Re: COPY FROM query. Paul Lambert 00:09
Re: COPY FROM query. Phillip Smith 00:47
Re: COPY FROM query. Paul Lambert 00:51
Re: [SQL] Password Policy Richard Huxton 08:19
Re: COPY FROM query. Richard Huxton 08:21
Sum sets of records Ezequias Rodrigues da Rocha 15:41
Re: Sum sets of records Bart Degryse 15:46
RE : Sum sets of records Sylvain Barrette 15:59
Deadlock on transaction Ezequias Rodrigues da Rocha 17:43
Re: Deadlock on transaction Scott Marlowe 17:48
Re: Deadlock on transaction Ezequias Rodrigues da Rocha 18:08
Re: [SQL] Deadlock on transaction Richard Huxton 18:43
Re: [ADMIN] Deadlock on transaction Andreas Kretschmer 18:45
Re: [SQL] Deadlock on transaction Ezequias Rodrigues da Rocha 18:47
Re: [SQL] Deadlock on transaction Richard Huxton 18:57
Re: [ADMIN] Deadlock on transaction Reinoud van Leeuwen 18:59
Re: [SQL] Deadlock on transaction Ezequias Rodrigues da Rocha 19:20
Re: Deadlock on transaction Scott Marlowe 19:20
Re: [ADMIN] Deadlock on transaction Ezequias Rodrigues da Rocha 19:27
Re: [SQL] Deadlock on transaction Richard Huxton 19:50
Re: [SQL] Deadlock on transaction Scott Marlowe 19:56
Re: COPY FROM query Steve Midgley 20:24

Feb. 13, 2007

Thread Author Time
[No subject] Franz Stützle 20:16

Feb. 14, 2007

Thread Author Time
Regaring posting a query 📎 sahaanaa subha 06:44
can someone explain confusing array indexing nomenclature chrisj 19:31
problem with join Edward W. Rouse 22:21
Re: Regaring posting a query Phillip Smith 22:34

Feb. 15, 2007

Thread Author Time
Re: problem with join Bruno Wolff III 04:02
Re: can someone explain confusing array indexing nomenclature Achilleas Mantzios 10:24
"for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql? Walter Cruz 11:19
Re: "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql? Richard Huxton 13:35
Re: "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql? Michael Glaesemann 14:04
Retrieving 'Credit' when 'C' Ezequias Rodrigues da Rocha 16:17
Re: Retrieving 'Credit' when 'C' Rodrigo De León 16:28
Re: Retrieving 'Credit' when 'C' Alvaro Herrera 16:30
Re: Retrieving 'Credit' when 'C' Ezequias Rodrigues da Rocha 16:44
Re: can someone explain confusing array indexing nomenclature chrisj 16:55
Re: "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql? Tom Lane 17:10
Re: Retrieving 'Credit' when 'C' Phillip Smith 21:47
Re: "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql? Walter Cruz 22:59

Feb. 16, 2007

Thread Author Time
Re: can someone explain confusing array indexing nomenclature Achilleas Mantzios 08:34
Re: Retrieving 'Credit' when 'C' Ezequias Rodrigues da Rocha 12:09
There is a different cast than ::MyOtherType() ? Ezequias Rodrigues da Rocha 12:30
Re: There is a different cast than ::MyOtherType() ? Alvaro Herrera 14:34
Re: There is a different cast than ::MyOtherType() ? A. Kretschmer 14:34
Re: can someone explain confusing array indexing nomenclature chrisj 18:35
Debug (is it PostgreSQL?) Ezequias Rodrigues da Rocha 18:59
Re: Debug (is it PostgreSQL?) Andy Shellam (Mailing Lists) 19:04
Fwd: [ADMIN] Debug (is it PostgreSQL?) Ezequias Rodrigues da Rocha 19:11

Feb. 17, 2007

Thread Author Time
Re: Fwd: [ADMIN] Debug (is it PostgreSQL?) Hiroshi Saito 00:33
ordering of selected rows from an ordered subselect Rajesh Kumar Mallah 09:32
sub-limiting a query Louis-David Mitterrand 12:56
Re: sub-limiting a query A. Kretschmer 15:00
Re: ordering of selected rows from an ordered subselect Andrew Sullivan 15:24
Re: ordering of selected rows from an ordered subselect Tom Lane 16:31
Re: sub-limiting a query M.P.Dankoor 17:35
Re: sub-limiting a query Andreas Kretschmer 17:47
Re: sub-limiting a query M.P.Dankoor 18:21
Re: sub-limiting a query Louis-David Mitterrand 18:40

Feb. 18, 2007

Thread Author Time
Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression 📎 Bruce Momjian 01:47
How to analyse the indexes in postgres? Karthikeyan Sundaram 08:15
Re: How to analyse the indexes in postgres? Thomas Kellerer 08:21
Re: How to analyse the indexes in postgres? Charley Tiggs 12:59
unsubscribe S.F. Lee 13:58

Feb. 19, 2007

Thread Author Time
Uppercase and Lowercase Shavonne Marietta Wijesinghe 15:22
Re: Uppercase and Lowercase Bart Degryse 15:25
Re: Uppercase and Lowercase Andrew Sullivan 15:30
Re: Uppercase and Lowercase Shavonne Marietta Wijesinghe 15:39
Re: Uppercase and Lowercase Bart Degryse 15:48
Re: Uppercase and Lowercase Alvaro Herrera 15:54
Re: Uppercase and Lowercase Bart Degryse 16:05
cartesian product Salman Tahir 16:58
Re: cartesian product Luiz K. Matsumura 17:56
Re: cartesian product Scott Marlowe 18:07
Re: cartesian product Scott Marlowe 18:09
DISTINCT ON not working...? Phillip Smith 22:25

Feb. 20, 2007

Thread Author Time
Re: DISTINCT ON not working...? Tom Lane 04:32
Re: DISTINCT ON not working...? Phillip Smith 04:36
Re: can someone explain confusing array indexing nomenclature Achilleas Mantzios 07:42
Re: DISTINCT ON not working...? Marcin Stępnicki 12:33
Re: can someone explain confusing array indexing nomenclature 📎 Bruce Momjian 14:26
Re: DISTINCT ON not working...? Phillip Smith 22:12

Feb. 21, 2007

Thread Author Time
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Bruce Momjian 01:07
Problem with Temp Table and Result Set from PL Function... devil live 11:31
Re: Problem with Temp Table and Result Set from PL Function... devil live 11:52
how to generate a list of distinct scalar values from a column which type is array Sergio Andreozzi 18:21
Problems with temp table and PL Martin Marques 21:17
Re: Problems with temp table and PL Andrew Sullivan 21:34
Re: Problems with temp table and PL A. Kretschmer 21:37

Feb. 22, 2007

Thread Author Time
How compare current_setting(..) ? Sabin Coanda 10:25
Re: How compare current_setting(..) ? Michael Fuhr 11:03
Esay question, about the numeric format Rafa Comino 11:20
Re: Esay question, about the numeric format A. Kretschmer 11:27
how to generate a list of distinct scalar values from a column which type is array Sergio Andreozzi 11:38
pg_dump fails (timestamp out of range) T E Schmitz 11:46
Re: how to generate a list of distinct scalar values from a column which type is array A. Kretschmer 12:28
Re: how to generate a list of distinct scalar values from a column which type is array A. Kretschmer 13:25
Re: how to generate a list of distinct scalar values from a column which type is array A. Kretschmer 13:34
Re: How compare current_setting(..) ? Sabin Coanda 13:47
Re: pg_dump fails (timestamp out of range) Tom Lane 15:43
Re: how to generate a list of distinct scalar values from a column which type is array David Fetter 16:56
Re: DISTINCT ON not working... RESOLVED Phillip Smith 22:31

Feb. 23, 2007

Thread Author Time
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Jim C. Nasby 16:24
simple web search Louis-David Mitterrand 16:27
Re: simple web search chester c young 18:01
Re: simple web search Louis-David Mitterrand 18:07
Re: simple web search chester c young 18:20
how do I to generate a sequence Range or Set of integer constants Stefan Becker 18:25
Re: simple web search Oleg Bartunov 18:30
Re: simple web search Joe 18:31
Re: simple web search Louis-David Mitterrand 18:34
Re: simple web search Oleg Bartunov 18:50
selecting random row values in postgres Sumeet 19:29
Re: how do I to generate a sequence Range or Set of integer constants A. Kretschmer 19:31
Re: how do I to generate a sequence Range or Set of integer constants Scott Marlowe 19:32
Re: how do I to generate a sequence Range or Set of integer constants Joe 19:36
Re: selecting random row values in postgres Rajesh Kumar Mallah 19:42
Re: selecting random row values in postgres Sumeet 19:56
Re: selecting random row values in postgres Rajesh Kumar Mallah 20:07
Re: selecting random row values in postgres Tommy Gildseth 20:45

Feb. 24, 2007

Thread Author Time
Re: selecting random row values in postgres Geoff Tolley 03:33
Re: can someone explain confusing array indexing nomenclature chrisj 23:04
Change a field to sequence (serial) Ezequias Rodrigues da Rocha 23:37

Feb. 25, 2007

Thread Author Time
Insert based in a select Ezequias Rodrigues da Rocha 00:06
Re: Insert based in a select Phillip Smith 01:23
Re: [SQL] Change a field to sequence (serial) Rodrigo De León 06:07
Very large IN-clause is slow, but how to rewrite it? Richard Jones 12:39
Re: Very large IN-clause is slow, but how to rewrite it? Oleg Bartunov 14:40
Re: Very large IN-clause is slow, but how to rewrite it? Tom Lane 16:56
Re: Very large IN-clause is slow, but how to rewrite it? Joe Conway 18:27
Re: Very large IN-clause is slow, but how to rewrite it? Tom Lane 18:34
Re: Very large IN-clause is slow, but how to rewrite it? Richard Jones 19:39
Re: Insert based in a select Phillip Smith 22:17
Re: Insert based in a select Ezequias Rodrigues da Rocha 23:57

Feb. 26, 2007

Thread Author Time
Re: Insert based in a select Phillip Smith 00:20
Re: Insert based in a select Ezequias Rodrigues da Rocha 00:43
Re: pg_dump fails (timestamp out of range) T E Schmitz 11:05
Re: pg_dump fails (timestamp out of range) Andrew Sullivan 12:41
Re: pg_dump fails (timestamp out of range) T E Schmitz 12:52
Change Default Database Rommel the iCeMAn 16:52
Re: Change Default Database Richard Huxton 16:58
Re: Change Default Database Rodrigo De León 17:09
Re: Change Default Database Rommel the iCeMAn 17:22
getting at sequence previous/next values Louis-David Mitterrand 18:14
Re: Change Default Database Rodrigo De León 18:43
Re: Change Default Database Scott Marlowe 19:40
Re: Change Default Database Scott Marlowe 21:39
Re: Change Default Database Rommel the iCeMAn 22:02
Re: Change Default Database Scott Marlowe 22:09
Re: Change Default Database Rommel the iCeMAn 22:13

Feb. 27, 2007

Thread Author Time
Syntax Error in COPY when “create function” hongliu zou 03:04
Position of a field Ezequias Rodrigues da Rocha 11:51
Re: Position of a field A. Kretschmer 12:17
Re: Position of a field Ezequias Rodrigues da Rocha 12:48
Re: Position of a field A. Kretschmer 13:08
Re: Change the Default Database Steve Midgley 16:38
Re: Syntax Error in COPY when “create function” Osvaldo Rosario Kussama 17:04
Re: Change the Default Database Rommel the iCeMAn 17:16
Re: Syntax Error in COPY when “create function” Tom Lane 17:25

Feb. 28, 2007

Thread Author Time
unsubscribe S.F. Lee 01:56
Conditional NOT NULL constraint Andreas Joseph Krogh 10:30
How to union table without union statement? calendarw 10:33
Re: How to union table without union statement? Richard Huxton 11:05
Re: Conditional NOT NULL constraint Richard Huxton 11:07
Re: Conditional NOT NULL constraint Andreas Joseph Krogh 11:23
Case with Char(1) Ezequias Rodrigues da Rocha 13:02
Re: Case with Char(1) Andrew Sullivan 13:18
Re: Case with Char(1) Peter Eisentraut 13:30
Re: Case with Char(1) Ezequias Rodrigues da Rocha 14:10
system tables inquiry & db Link inquiry Karthikeyan Sundaram 18:19
Re: [SQL] system tables inquiry & db Link inquir Gary Chambers 18:29
Re: [SQL] system tables inquiry & db Link inquiry Scott Marlowe 18:35
pg_dump error Karthikeyan Sundaram 19:17
Re: pg_dump error Joshua D. Drake 19:31
Re: pg_dump error Karthikeyan Sundaram 19:35
unsubscribe Franz Stuetzle 21:02
pg_dump inquiry Karthikeyan Sundaram 22:57
Re: pg_dump inquiry Bricklen Anderson 23:05

March 1, 2007

Thread Author Time
what is the best way to get key information in postgres? Noura Elhawary 00:48
Re: Esay question, about the numeric format Bruno Wolff III 01:19
Re: How to union table without union statement? calendarw 01:52
How to store a password encripted in a user defined table Eugenio Flores 06:31
column definition list of a dynamic record argument Sabin Coanda 07:56
Re: How to store a password encripted in a user defined table Andrej Ricnik-Bay 08:21
Re: How to store a password encripted in a user defined table Eugenio Flores 11:06
Re: How to union table without union statement? Shane Ambler 11:38
Re: How to store a password encripted in a user defined table Shane Ambler 11:39
Re: How to store a password encripted in a user defined table John DeSoi 13:25
Re: How to store a password encripted in a user definedtable Bart Degryse 13:42
Re: How to store a password encripted in a user defined table Ezequias Rodrigues da Rocha 14:08
Re: How to store a password encripted in a user definedtable Bart Degryse 14:44
Re: How to store a password encripted in a user definedtable Ezequias Rodrigues da Rocha 14:58
Re: How to store a password encripted in a user definedtable Ezequias Rodrigues da Rocha 15:02
Re: How to store a password encripted in a userdefinedtable Bart Degryse 15:16
Re: pg_dump inquiry Osvaldo Rosario Kussama 15:30
Re: pg_dump inquiry Joe 15:49

Browse Archives

Prev | Next