pgsql-sql since 2007-02-17 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. 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
Re: How to store a password encripted in a userdefinedtable Ezequias Rodrigues da Rocha 16:53
Re: How to store a password encripted in a userdefinedtable Shane Ambler 17:14
Re: How to store a password encripted in a userdefinedtable Adrian Klaver 17:19
Re: How to store a password encripted in a userdefinedtable Ezequias Rodrigues da Rocha 18:02
Re: How to store a password encripted in a user defined table Eugenio Flores 19:49

March 2, 2007

Thread Author Time
Re: [SQL] pg_dump error Tom Lane 06:12
Select when table have missing data Lars Gregersen 09:17

March 3, 2007

Thread Author Time
How to return a select query Eugenio Flores 22:08

March 4, 2007

Thread Author Time
Re: How to return a select query Rodrigo De León 06:44

March 5, 2007

Thread Author Time
GiST index question: performance Steve Midgley 19:12
Re: GiST index question: performance Oleg Bartunov 20:21
Re: GiST index question: performance Steve Midgley 21:23

March 6, 2007

Thread Author Time
Re: GiST index question: performance Peter Eisentraut 09:01
Time of executed query Ezequias Rodrigues da Rocha 13:20
Re: Time of executed query Bart Degryse 13:26
Re: Time of executed query Ezequias Rodrigues da Rocha 13:37
convert to a string Shavonne Marietta Wijesinghe 13:42
Re: Time of executed query Shoaib Mir 13:43
Re: Time of executed query Bart Degryse 13:45
Re: convert to a string Bart Degryse 13:54
Re: [SQL] Time of executed query Ezequias Rodrigues da Rocha 13:55
Re: convert to a string A. Kretschmer 13:56
Re: [SQL] Time of executed query Shoaib Mir 13:59
Re: Time of executed query Bart Degryse 14:01
Re: convert to a string Shavonne Marietta Wijesinghe 14:32
View Vs. Table Radhika Sambamurti 14:32
Re: convert to a string Bart Degryse 14:38
[Fwd: View Vs. Table] Radhika Sambamurti 14:40
Re: convert to a string Shavonne Marietta Wijesinghe 14:49
Selecting exactly one row for each column value Florian Weimer 15:03
Re: Selecting exactly one row for each column value A. Kretschmer 15:17
Re: Selecting exactly one row for each column value Tom Lane 15:32
Re: [SQL] Time of executed query Rodrigo De León 15:37
Re: [SQL] Time of executed query Rodrigo De León 15:39
Re: Selecting exactly one row for each column value Florian Weimer 15:46
Re: [Fwd: View Vs. Table] Andrew Sullivan 15:52
Inc Ezequias Rodrigues da Rocha 16:55
Re: Inc Richard Huxton 17:13
Re: Inc Ezequias Rodrigues da Rocha 17:29
Re: Inc Richard Broersma Jr 17:40
Re: GiST index question: performance Steve Midgley 17:43
Re: Inc Andreas Kretschmer 17:46
Re: Inc Andreas Kretschmer 17:54
Re: Inc Ezequias Rodrigues da Rocha 18:02
Re: Inc Richard Huxton 18:08
Re: Selecting exactly one row for each column value Stefan Becker 18:14
Re: GiST index question: performance Oleg Bartunov 18:57
Re: Inc Ezequias Rodrigues da Rocha 19:09
best index for ~ ordering? Gerardo Herzig 21:34
Re: best index for ~ ordering? Andrew Sullivan 22:28

March 7, 2007

Thread Author Time
Re: How to union table without union statement? calendarw 01:16
Re: best index for ~ ordering? gherzig 03:28
PRIMARY KEY Shavonne Marietta Wijesinghe 11:35

Browse Archives

Prev | Next