pgsql-sql since 2007-02-21 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. 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
Re: PRIMARY KEY Richard Huxton 11:51
Re: PRIMARY KEY M.P.Dankoor 11:57
[Re: PRIMARY KEY] Phillip Smith 12:20
Re: PRIMARY KEY M.P.Dankoor 12:50
Re: PRIMARY KEY Shavonne Marietta Wijesinghe 13:16
tesearch2 question Sumeet 15:46
Re: best index for ~ ordering? Andrew Sullivan 18:32
Re: tesearch2 question Oleg Bartunov 19:02
SHA-1 vs MD5 Ezequias Rodrigues da Rocha 20:04
Re: SHA-1 vs MD5 Andrew Sullivan 20:17
Re: SHA-1 vs MD5 Andrej Ricnik-Bay 20:31
Re: tesearch2 question Sumeet 20:40
Re: tesearch2 question Oleg Bartunov 20:49
Re: SHA-1 vs MD5 Chad Wagner 21:44

March 8, 2007

Thread Author Time
Re: SHA-1 vs MD5 Ezequias Rodrigues da Rocha 11:39
Re: SHA-1 vs MD5 Chad Wagner 14:52
A form of inheritance with PostgreSQL 📎 Greg Toombs 18:01
Re: A form of inheritance with PostgreSQL Richard Huxton 19:58
Re: A form of inheritance with PostgreSQL Richard Broersma Jr 20:05
Re: inheritance chester c young 20:25
Re: inheritance Shane Ambler 21:46
Re: inheritance Richard Broersma Jr 22:11
Re: inheritance chester c young 22:20
Re: inheritance Richard Broersma Jr 22:27

March 9, 2007

Thread Author Time
Re: inheritance Shane Ambler 00:50
Re: Select when table have missing data Rodrigo De León 01:30
Creating views Kashmira Patel (kupatel) 02:03
Re: A form of inheritance with PostgreSQL Bart Degryse 08:28
Re: Creating views Richard Huxton 08:34
Table inherit & foreign key problem Moritz Kobel 11:43
Re: SHA-1 vs MD5 Ezequias Rodrigues da Rocha 12:34
Re: Table inherit & foreign key problem Richard Huxton 12:35
Re: SHA-1 vs MD5 Chad Wagner 13:14

Browse Archives

Prev | Next