pgsql-sql - February 2007

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 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. 1, 2007

Thread Author Time
Compilation errors Hiltibidal, Robert 15:10
Compilation Error AIX Hiltibidal, Robert 15:33
Re: Compilation Error AIX Andrew Sullivan 15:48
Re: Insert Data and autonumeric field Andrew Sullivan 18:13
Re: Insert Data and autonumeric field Tom Lane 18:32
Re: Differentiate Between Zero-Length String and NULLColumn Values Andrew Sullivan 18:53
Insert Data and autonumeric field André José Guergolet 19:09
Search a range of cases/records Wei ZOU 20:56
Re: Index Anding Chris Browne 22:45
Re: Index Anding Hiltibidal, Robert 23:13

Feb. 2, 2007

Thread Author Time
sql Shyju Narayanan 07:39
Insert into a date field Ezequias Rodrigues da Rocha 13:08
Re: Insert into a date field Richard Huxton 13:12
Re: Insert into a date field Shoaib Mir 13:45
Duplicate records Ezequias Rodrigues da Rocha 13:48
Re: Insert into a date field Ezequias Rodrigues da Rocha 13:49
Re: Duplicate records Mezei Zoltán 13:54
Re: Duplicate records Shoaib Mir 13:55
Re: Duplicate records Bart Degryse 13:55
Re: Duplicate records Ezequias Rodrigues da Rocha 13:59
Re: Duplicate records Shoaib Mir 14:03
Re: Duplicate records Bart Degryse 14:13
Re: Insert into a date field Hiltibidal, Robert 14:56
Re: Duplicate records Ezequias Rodrigues da Rocha 15:00
Re: Duplicate records Andrew Sullivan 15:16
Nocount and scope_identity() Demel, Jeff 17:49
to_chat(bigint) Ezequias Rodrigues da Rocha 18:11
Re: to_chat(bigint) Bricklen Anderson 18:15
Re: Nocount and scope_identity() Andrew Sullivan 18:18
Re: Nocount and scope_identity() Demel, Jeff 19:38
Question regarding multibyte. Karthikeyan Sundaram 19:51
Re: Nocount and scope_identity() Andrew Sullivan 19:57
Re: Nocount and scope_identity() Tom Lane 20:28

Feb. 4, 2007

Thread Author Time
Re: [SQL] Question regarding multibyte. Karthikeyan Sundaram 21:34
Re: [PHP] [SQL] Question regarding multibyte. Michael Fuhr 22:30
Re: [SQL] Question regarding multibyte. Charley Tiggs 22:44
Re: [SQL] Question regarding multibyte. Ivo Rossacher 23:26
Getting associated columns with max() without subquery César Antonio León Mansilla 23:30

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

Browse Archives

Prev | Next
Jump to day: 1 2 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