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

Feb. 5, 2007

Thread Author Time
PL/pgsql declaration of string / bit / number with given (variable!) length sneumann 16:02
Symbol lookup error Karthikeyan Sundaram 21:37
Re: Symbol lookup error Tom Lane 21:49

Feb. 6, 2007

Thread Author Time
Re: sql A. Kretschmer 06:41
Re: Search a range of cases/records A. Kretschmer 06:58
Re: sql Karthikeyan Sundaram 07:16
Re: sql Penchalaiah P. 08:41
Re: Index ANDing & Index ORing Richard Huxton 09:38
Re: Compilation errors Richard Huxton 09:39
Re: PL/pgsql declaration of string / bit / number with given (variable!) length Richard Huxton 09:45
Re: Index ANDing & Index ORing Richard Huxton 13:16
Re: Index ANDing & Index ORing Richard Huxton 14:05
Re: Compilation Error AIX Alvaro Herrera 14:07
Removing duplicate rows Paul Lambert 22:15
Re: Removing duplicate rows Andrew Sullivan 22:22
Re: Removing duplicate rows Paul Lambert 22:44
Re: Removing duplicate rows Hélder M. Vieira 22:49
Re: Removing duplicate rows Thomas Kellerer 23:15

Feb. 7, 2007

Thread Author Time
interval as hours or minutes ? Aarni Ruuhimäki 17:03
Re: interval as hours or minutes ? Bricklen Anderson 17:33
Re: interval as hours or minutes ? A. Kretschmer 17:44
metaphone and nysiis in postgres Demel, Jeff 19:46
Re: metaphone and nysiis in postgres Tom Lane 20:08
Re: metaphone and nysiis in postgres Demel, Jeff 20:13
Re: metaphone and nysiis in postgres Demel, Jeff 20:31
Re: interval as hours or minutes ? Bruno Wolff III 21:25
Re: interval as hours or minutes ? Jan Muszynski 22:09
Seeking quick way to clone a row, but give it a new pk. Bryce Nesbitt 22:21
Odd PL/PgSQL Error -- relation "X" does not exist when using index expression Greg Wittel 22:43

Feb. 8, 2007

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

Feb. 9, 2007

Thread Author Time
Re: Seeking quick way to clone a row, but give it a new pk. John DeSoi 00:09
Re: huge disparities in =/IN/BETWEEN performance Tom Lane 01:54
Re: huge disparities in =/IN/BETWEEN performance George Pavlov 02:03
Re: huge disparities in =/IN/BETWEEN performance Alvaro Herrera 02:14
Re: huge disparities in =/IN/BETWEEN performance Tom Lane 03:50
Re: huge disparities in =/IN/BETWEEN performance Joe 04:12
Re: huge disparities in =/IN/BETWEEN performance Tom Lane 04:24
unsubscribe Arulmani V A 04:25
Re: huge disparities in =/IN/BETWEEN performance Joe 05:01
unsubscribe Patrice Oliver 08:26
dynamic sql Gabriel Adolfo Sirni 14:15
Re: huge disparities in =/IN/BETWEEN performance Tom Lane 14:26
Re: dynamic sql Tom Lane 15:24
alias not applied Sabin Coanda 16:04
Re: alias not applied Frank Bax 16:19
Re: alias not applied Tom Lane 16:25
Re: alias not applied Sabin Coanda 16:35
Have anyone this man e-mail ? Ezequias Rodrigues da Rocha 18:50
Re: huge disparities in =/IN/BETWEEN performance George Pavlov 19:21
Re: huge disparities in =/IN/BETWEEN performance Tom Lane 22:38

Feb. 10, 2007

Thread Author Time
unsubscribe Franz Stuetzle 13:23
Password Policy Ezequias Rodrigues da Rocha 19:55
Re: Password Policy Clodoaldo 21:32
Re: Password Policy Andy Shellam (Mailing Lists) 21:46
Re: Password Policy Ezequias Rodrigues da Rocha 22:46

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

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