Home > mailing lists

Mailing lists [pgsql-sql]

1 February 2007

14:48 Re: Compilation Error AIX Andrew Sullivan
17:06 Insert Data and autonumeric field André José Guergolet
17:13 Re: Insert Data and autonumeric field Andrew Sullivan
17:32 Re: Insert Data and autonumeric field Tom Lane
17:53 Re: Differentiate Between Zero-Length String and NULLColumn Values Andrew Sullivan
22:04 Re: Index Anding Chris Browne

2 February 2007

12:08 Insert into a date field Ezequias Rodrigues da Rocha
12:12 Re: Insert into a date field Richard Huxton
12:45 Re: Insert into a date field Shoaib Mir
12:49 Duplicate records Ezequias Rodrigues da Rocha
12:50 Re: Insert into a date field Ezequias Rodrigues da Rocha
12:55 Re: Duplicate records Shoaib Mir
12:55 Re: Duplicate records Bart Degryse
12:59 Re: Duplicate records Ezequias Rodrigues da Rocha
13:03 Re: Duplicate records Shoaib Mir
13:13 Re: Duplicate records Bart Degryse
13:29 Re: Duplicate records Mezei Zoltán
14:01 Re: Duplicate records Ezequias Rodrigues da Rocha
14:17 Re: Duplicate records Andrew Sullivan
16:49 Nocount and scope_identity() Demel, Jeff
17:11 to_chat(bigint) Ezequias Rodrigues da Rocha
17:15 Re: to_chat(bigint) Bricklen Anderson
17:18 Re: Nocount and scope_identity() Andrew Sullivan
18:38 Re: Nocount and scope_identity() Demel, Jeff
18:51 Question regarding multibyte. Karthikeyan Sundaram
18:57 Re: Nocount and scope_identity() Andrew Sullivan
19:28 Re: Nocount and scope_identity() Tom Lane

4 February 2007

20:34 Re: Question regarding multibyte. Karthikeyan Sundaram
21:30 Re: [PHP] Question regarding multibyte. Michael Fuhr

5 February 2007

20:37 Symbol lookup error Karthikeyan Sundaram
20:49 Re: [ADMIN] Symbol lookup error Tom Lane

6 February 2007

02:29 Re: Differentiate Between Zero-Length String and NULLColumn Values Jamie A Lawrence
02:29 Index ANDing & Index ORing Hiltibidal, Robert
02:29 Re: Index Anding Hiltibidal, Robert
02:29 Index Anding Hiltibidal, Robert
02:29 Re: Differentiate Between Zero-Length String and NULLColumn Values BillR
02:29 Compilation errors Hiltibidal, Robert
02:29 Compilation Error AIX Hiltibidal, Robert
02:30 Search a range of cases/records Wei ZOU
02:30 Re: Index Anding Hiltibidal, Robert
02:30 sql Shyju Narayanan
02:30 Re: Insert into a date field Hiltibidal, Robert
02:30 Getting associated columns with max() without subquery César Antonio León Mansilla
02:30 PL/pgsql declaration of string / bit / number with given (variable!) length sneumann
05:41 Re: sql A. Kretschmer
05:58 Re: Search a range of cases/records A. Kretschmer
06:16 Re: sql Karthikeyan Sundaram
08:11 Re: sql Penchalaiah P.
09:15 Re: Index ANDing & Index ORing Richard Huxton
09:15 Re: Compilation errors Richard Huxton
09:17 Re: PL/pgsql declaration of string / bit / number with given (variable!) length Richard Huxton
12:45 Re: Index ANDing & Index ORing Richard Huxton
13:08 Re: Compilation Error AIX Alvaro Herrera
13:45 Re: Index ANDing & Index ORing Richard Huxton
21:16 Removing duplicate rows Paul Lambert
21:22 Re: Removing duplicate rows Andrew Sullivan
21:45 Re: Removing duplicate rows Paul Lambert
21:49 Re: Removing duplicate rows Hélder M. Vieira
22:15 Re: Removing duplicate rows Thomas Kellerer

7 February 2007

16:22 interval as hours or minutes ? Aarni Ruuhimäki
16:33 Re: interval as hours or minutes ? Bricklen Anderson
16:44 Re: interval as hours or minutes ? A. Kretschmer
18:47 metaphone and nysiis in postgres Demel, Jeff
19:09 Re: metaphone and nysiis in postgres Tom Lane
19:13 Re: metaphone and nysiis in postgres Demel, Jeff
19:32 Re: metaphone and nysiis in postgres Demel, Jeff
20:26 Re: interval as hours or minutes ? Bruno Wolff III
21:10 Re: interval as hours or minutes ? Jan Muszynski
21:50 Seeking quick way to clone a row, but give it a new pk. Bryce Nesbitt
22:06 Odd PL/PgSQL Error -- relation "X" does not exist when using index expression Greg Wittel
23:30 Re: Seeking quick way to clone a row, but give it a new pk. Philip Hallstrom
23:50 question on passing parameter in sql query Karthikeyan Sundaram

8 February 2007

00:56 Re: question on passing parameter in sql query Chad Wagner
06:16 Re: Seeking quick way to clone a row, but give it a new pk. Bryce Nesbitt
06:19 Re: Seeking quick way to clone a row, but give it a new pk. Bryce Nesbitt
06:58 Re: Seeking quick way to clone a row, but give it a new pk. Achilleas Mantzios
08:05 Re: metaphone and nysiis in postgres Richard Huxton
08:33 Re: Seeking quick way to clone a row, but give it a new pk. Aarni Ruuhimäki
09:01 Re: interval as hours or minutes ? Aarni Ruuhimäki
09:06 Re: interval as hours or minutes ? Bart Degryse
10:18 Re: interval as hours or minutes ? Aarni Ruuhimäki
10:23 Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression Michael Fuhr
12:30 unsubscribe oliverp21@free.fr
13:06 unsubscribe Susan Evans
13:15 Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression Alvaro Herrera
14:07 Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression Michael Fuhr
14:09 unsubscribe Wilkinson, Jim
14:12 unsubscribe Adrien Lebre
14:33 Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression Tom Lane
14:55 Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression Michael Fuhr
14:59 Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression Tom Lane
15:15 Re: Seeking quick way to clone a row, but give it a new pk. Greg Sabino Mullane
15:50 Open a Transaction Ezequias Rodrigues da Rocha
15:57 Re: Open a Transaction Joe
16:04 Re: metaphone and nysiis in postgres Demel, Jeff
16:23 Re: Open a Transaction Ezequias Rodrigues da Rocha
16:26 Re: Open a Transaction Roberto Fichera
16:27 Re: Open a Transaction Andrew Sullivan
16:34 Re: Open a Transaction Tom Lane
16:42 Re: Open a Transaction Ezequias Rodrigues da Rocha
18:13 COPY FROM - force a value Demel, Jeff
18:19 unsubscribe David Klugmann
18:22 Re: COPY FROM - force a value Alvaro Herrera
18:31 Re: Differentiate Between Zero-Length String and NULLColumn Values Jan Wieck
18:55 Re: COPY FROM - force a value Demel, Jeff
19:49 Re: metaphone and nysiis in postgres Jan Muszynski
22:56 huge disparities in =/IN/BETWEEN performance George Pavlov
23:09 Re: Seeking quick way to clone a row, but give it a new pk. John DeSoi

9 February 2007

00:54 Re: huge disparities in =/IN/BETWEEN performance Tom Lane
01:03 Re: huge disparities in =/IN/BETWEEN performance George Pavlov
01:14 Re: huge disparities in =/IN/BETWEEN performance Alvaro Herrera
02:50 Re: huge disparities in =/IN/BETWEEN performance Tom Lane
03:12 Re: huge disparities in =/IN/BETWEEN performance Joe
03:24 Re: huge disparities in =/IN/BETWEEN performance Tom Lane
03:26 unsubscribe Arulmani V A
04:21 Re: huge disparities in =/IN/BETWEEN performance Joe
10:34 unsubscribe Patrice Oliver
13:37 dynamic sql Gabriel Adolfo Sirni
13:37 Re: huge disparities in =/IN/BETWEEN performance Tom Lane
14:24 Re: dynamic sql Tom Lane
15:04 alias not applied Sabin Coanda
15:20 Re: alias not applied Frank Bax
15:25 Re: alias not applied Tom Lane
15:35 Re: alias not applied Sabin Coanda
17:50 Have anyone this man e-mail ? Ezequias Rodrigues da Rocha
18:22 Re: huge disparities in =/IN/BETWEEN performance George Pavlov
21:38 Re: huge disparities in =/IN/BETWEEN performance Tom Lane

10 February 2007

12:23 unsubscribe Franz Stuetzle
18:55 Password Policy Ezequias Rodrigues da Rocha

11 February 2007

22:20 COPY FROM query. Paul Lambert
22:28 Re: COPY FROM query. Paul Lambert
22:55 Re: COPY FROM query. Joe
23:10 Re: COPY FROM query. Paul Lambert
23:47 Re: COPY FROM query. Phillip Smith
23:52 Re: COPY FROM query. Paul Lambert

12 February 2007

07:30 Re: Password Policy Richard Huxton
07:31 Re: COPY FROM query. Richard Huxton
14:41 Sum sets of records Ezequias Rodrigues da Rocha
14:47 Re: Sum sets of records Bart Degryse
16:40 RE : Sum sets of records Sylvain Barrette
16:43 Deadlock on transaction Ezequias Rodrigues da Rocha
16:51 Re: [ADMIN] Deadlock on transaction Scott Marlowe
17:08 Re: [ADMIN] Deadlock on transaction Ezequias Rodrigues da Rocha
17:44 Re: [ADMIN] Deadlock on transaction Richard Huxton
17:46 Re: [ADMIN] Deadlock on transaction Andreas Kretschmer
17:50 Re: [ADMIN] Deadlock on transaction Ezequias Rodrigues da Rocha
18:03 Re: [ADMIN] Deadlock on transaction Richard Huxton
18:20 Re: [ADMIN] Deadlock on transaction Ezequias Rodrigues da Rocha
18:21 Re: [ADMIN] Deadlock on transaction Scott Marlowe
18:22 Re: [ADMIN] Deadlock on transaction Reinoud van Leeuwen
18:27 Re: [ADMIN] Deadlock on transaction Ezequias Rodrigues da Rocha
18:55 Re: [ADMIN] Deadlock on transaction Richard Huxton
19:34 Re: COPY FROM query Steve Midgley

13 February 2007

19:16 ... Franz Stützle

14 February 2007

05:42 Re: Most efficient way to hard-sort records Michael Glaesemann
05:44 Regaring posting a query sahaanaa subha
18:31 can someone explain confusing array indexing nomenclature chrisj
21:29 problem with join Edward W. Rouse
21:34 Re: Regaring posting a query Phillip Smith

15 February 2007

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

16 February 2007

12:34 There is a different cast than ::MyOtherType() ? Ezequias Rodrigues da Rocha
12:52 Re: Retrieving 'Credit' when 'C' Ezequias Rodrigues da Rocha
13:31 Re: can someone explain confusing array indexing nomenclature Achilleas Mantzios
13:35 Re: There is a different cast than ::MyOtherType() ? A. Kretschmer
13:35 Re: There is a different cast than ::MyOtherType() ? Alvaro Herrera
17:35 Re: can someone explain confusing array indexing nomenclature chrisj
17:59 Debug (is it PostgreSQL?) Ezequias Rodrigues da Rocha

17 February 2007

08:32 ordering of selected rows from an ordered subselect Rajesh Kumar Mallah
11:56 sub-limiting a query Louis-David Mitterrand
14:00 Re: sub-limiting a query A. Kretschmer
14:24 Re: ordering of selected rows from an ordered subselect Andrew Sullivan
15:31 Re: ordering of selected rows from an ordered subselect Tom Lane
16:42 Re: sub-limiting a query M.P.Dankoor
16:47 Re: sub-limiting a query Andreas Kretschmer
17:22 Re: sub-limiting a query M.P.Dankoor
17:40 Re: sub-limiting a query Louis-David Mitterrand

18 February 2007

00:49 Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression Bruce Momjian
07:15 How to analyse the indexes in postgres? Karthikeyan Sundaram
07:21 Re: How to analyse the indexes in postgres? Thomas Kellerer
12:58 unsubscribe S.F. Lee

19 February 2007

14:22 Uppercase and Lowercase Shavonne Marietta Wijesinghe
14:26 Re: Uppercase and Lowercase Bart Degryse
14:30 Re: Uppercase and Lowercase Andrew Sullivan
14:39 Re: Uppercase and Lowercase Shavonne Marietta Wijesinghe
14:49 Re: Uppercase and Lowercase Bart Degryse
14:54 Re: Uppercase and Lowercase Alvaro Herrera
15:05 Re: Uppercase and Lowercase Bart Degryse
15:58 cartesian product Salman Tahir
17:07 Re: cartesian product Scott Marlowe
17:09 Re: cartesian product Scott Marlowe
17:41 Re: cartesian product Luiz K. Matsumura
21:25 DISTINCT ON not working...? Phillip Smith

20 February 2007

03:32 Re: DISTINCT ON not working...? Tom Lane
03:36 Re: DISTINCT ON not working...? Phillip Smith
06:42 Re: can someone explain confusing array indexing nomenclature Achilleas Mantzios
11:34 Re: DISTINCT ON not working...? Marcin Stępnicki
13:26 Re: can someone explain confusing array indexing nomenclature Bruce Momjian
21:12 Re: DISTINCT ON not working...? Phillip Smith

21 February 2007

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

22 February 2007

09:25 How compare current_setting(..) ? Sabin Coanda
10:04 Re: How compare current_setting(..) ? Michael Fuhr
10:27 Re: [GENERAL] Esay question, about the numeric format A. Kretschmer
10:47 pg_dump fails (timestamp out of range) T E Schmitz
11:28 Re: how to generate a list of distinct scalar values from a column which type is array A. Kretschmer
12:25 Re: how to generate a list of distinct scalar values from a column which type is array A. Kretschmer
12:34 Re: how to generate a list of distinct scalar values from a column which type is array A. Kretschmer
12:47 Re: How compare current_setting(..) ? Sabin Coanda
14:43 Re: pg_dump fails (timestamp out of range) Tom Lane
21:31 Re: DISTINCT ON not working... RESOLVED Phillip Smith

23 February 2007

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

24 February 2007

02:45 Re: selecting random row values in postgres Geoff Tolley
22:04 Re: can someone explain confusing array indexing nomenclature chrisj
22:37 Change a field to sequence (serial) Ezequias Rodrigues da Rocha
23:06 Insert based in a select Ezequias Rodrigues da Rocha

25 February 2007

00:18 Re: Insert based in a select Phillip Smith
05:07 Re: Change a field to sequence (serial) Rodrigo De León
11:39 Very large IN-clause is slow, but how to rewrite it? Richard Jones
13:41 Re: Very large IN-clause is slow, but how to rewrite it? Oleg Bartunov
15:56 Re: Very large IN-clause is slow, but how to rewrite it? Tom Lane
17:27 Re: Very large IN-clause is slow, but how to rewrite it? Joe Conway
17:34 Re: Very large IN-clause is slow, but how to rewrite it? Tom Lane
18:39 Re: Very large IN-clause is slow, but how to rewrite it? Richard Jones
21:17 Re: Insert based in a select Phillip Smith
22:57 Re: Insert based in a select Ezequias Rodrigues da Rocha
23:20 Re: Insert based in a select Phillip Smith
23:44 Re: Insert based in a select Ezequias Rodrigues da Rocha

26 February 2007

10:05 Re: pg_dump fails (timestamp out of range) T E Schmitz
11:41 Re: pg_dump fails (timestamp out of range) Andrew Sullivan
11:52 Re: pg_dump fails (timestamp out of range) T E Schmitz
15:54 Change Default Database Rommel the iCeMAn
16:04 Re: Change Default Database Richard Huxton
16:09 Re: Change Default Database Rodrigo De León
16:24 Re: Change Default Database Rommel the iCeMAn
17:15 getting at sequence previous/next values Louis-David Mitterrand
17:43 Re: Change Default Database Rodrigo De León
18:40 Re: Change Default Database Scott Marlowe
20:39 Re: Change Default Database Scott Marlowe
21:04 Re: Change Default Database Rommel the iCeMAn
21:09 Re: Change Default Database Scott Marlowe
21:15 Re: Change Default Database Rommel the iCeMAn

27 February 2007

02:04 Syntax Error in COPY when “create function” hongliu zou
10:51 Position of a field Ezequias Rodrigues da Rocha
11:17 Re: Position of a field A. Kretschmer
11:49 Re: Position of a field Ezequias Rodrigues da Rocha
12:08 Re: Position of a field A. Kretschmer
15:40 Re: Change the Default Database Steve Midgley
16:01 Re: Syntax Error in COPY when “create function” Osvaldo Rosario Kussama
16:18 Re: Change the Default Database Rommel the iCeMAn
16:26 Re: Syntax Error in COPY when “create function” Tom Lane

28 February 2007

00:56 unsubscribe S.F. Lee
09:33 How to union table without union statement? calendarw
09:51 Conditional NOT NULL constraint Andreas Joseph Krogh
10:05 Re: How to union table without union statement? Richard Huxton
10:07 Re: Conditional NOT NULL constraint Richard Huxton
10:24 Re: Conditional NOT NULL constraint Andreas Joseph Krogh
12:02 Case with Char(1) Ezequias Rodrigues da Rocha
12:18 Re: Case with Char(1) Andrew Sullivan
12:31 Re: Case with Char(1) Peter Eisentraut
13:10 Re: Case with Char(1) Ezequias Rodrigues da Rocha
17:19 system tables inquiry & db Link inquiry Karthikeyan Sundaram
17:29 Re: system tables inquiry & db Link inquir Gary Chambers
17:35 Re: system tables inquiry & db Link inquiry Scott Marlowe
18:17 pg_dump error Karthikeyan Sundaram
18:35 Re: [ADMIN] pg_dump error Karthikeyan Sundaram
20:02 unsubscribe Franz Stuetzle
21:57 pg_dump inquiry Karthikeyan Sundaram
23:54 what is the best way to get key information in postgres? Noura Elhawary