pgsql-sql - November 2006

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Nov. 1, 2006

Thread Author Time
Re: Add calculated fields from one table to other table roopa perumalraja 03:54
Re: Add calculated fields from one table to other table Richard Broersma Jr 05:51
Re: [HACKERS] Case Preservation disregarding case Tom Lane 06:38
Re: Add calculated fields from one table to other table roopa perumalraja 06:49
Re: Round Numeric Type Ezequias Rodrigues da Rocha 12:06
Re: record datatype comparisons Andrew Sullivan 14:28
Re: record datatype comparisons Andrew Sullivan 14:32
Distribution of results Raghuraman K 16:17
Re: [HACKERS] Case Preservation disregarding case Chuck McDevitt 16:31
Statement Triggers and access to other rows in the transaction Craig Servin 16:50
Re: record datatype comparisons Volkan YAZICI 21:00
Re: record datatype comparisons Andrew Sullivan 21:07

Nov. 2, 2006

Thread Author Time
Re: [HACKERS] Case Preservation disregarding case Simon Riggs 10:27
hi i am getting error...can u solve this Penchalaiah P. 12:49
Re: hi i am getting error...can u solve this Andrew Sullivan 13:39
Re: [HACKERS] Case Preservation disregarding case Tom Lane 15:51
Postgres-R Anton P. Linevich 17:16
Re: Postgres-R Andrew Sullivan 17:51
Is there anyway to... louis gonzales 18:14
Re: hi i am getting error...can u solve this Hector Villarreal 18:18
Re: Is there anyway to... A. Kretschmer 18:26
Re: Is there anyway to... brian 18:30
Re: Is there anyway to... louis gonzales 18:53
Re: Is there anyway to... Ian Harding 19:01
Re: Is there anyway to... Glen Parker 19:02
Re: [SQL] Is there anyway to... imad 19:04
Re: Is there anyway to... Andreas Kretschmer 19:09
Re: [GENERAL] Is there anyway to... A. Kretschmer 19:17
Re: Is there anyway to... louis gonzales 19:24
Re: [GENERAL] Is there anyway to... imad 19:32
Re: Is there anyway to... AgentM 19:37
Determining correct table order for insert or drop statements to satisfy foreign keys Peter Hanson 19:43
Re: Is there anyway to... louis gonzales 19:46
Re: Is there anyway to... A. Kretschmer 19:47
Re: Is there anyway to... Glen Parker 19:48
Re: [SQL] Is there anyway to... Dave Page 19:51
Re: Is there anyway to... AgentM 19:55
Re: Is there anyway to... Richard Troy 20:00
Re: Is there anyway to... Ron Johnson 20:28
Re: Is there anyway to... Andreas Kretschmer 20:49
The empty list? Jesper Krogh 21:38
Re: The empty list? Tom Lane 22:34
Re: Database recovery in postgres 7.2.4. Chris Browne 22:41
Re: The empty list? Aaron Bono 22:43
Re: Determining correct table order for insert or drop statements to satisfy foreign keys Aaron Bono 22:58
PLPGSQL question Sorin Schwimmer 23:06
Re: Determining correct table order for insert or drop statements to satisfy foreign keys Peter Hanson 23:16
delete and select with IN clause issues Jeff Frost 23:58

Nov. 3, 2006

Thread Author Time
Re: delete and select with IN clause issues Jeff Frost 00:08
Re: Is there anyway to... louis gonzales 02:10
Re: Is there anyway to... louis gonzales 02:24
Re: Is there anyway to... Wes Sheldahl 02:36
Re: Is there anyway to... louis gonzales 02:46
Re: Is there anyway to... Glen Parker 03:14
Re: Is there anyway to... louis gonzales 03:21
Re: delete and select with IN clause issues Tom Lane 03:50
Re: delete and select with IN clause issues Jeff Frost 04:37
show privileges Rares Vernica 05:29
Re: The empty list? Jesper Krogh 06:02
Re: Add calculated fields from one table to other table Richard Broersma Jr 06:03
Re: delete and select with IN clause issues Tom Lane 06:23
Re: The empty list? Tom Lane 06:36
Re: delete and select with IN clause issues Jeff Frost 06:42
Re: The empty list? Jesper Krogh 06:46
Re: delete and select with IN clause issues Tom Lane 06:58
Re: The empty list? Tom Lane 07:02
Re: delete and select with IN clause issues Jeff Frost 07:10
Re: delete and select with IN clause issues Tom Lane 17:26
Re: Determining correct table order for insert or drop statements to satisfy foreign keys Aaron Bono 18:04
Re: The empty list? Aaron Bono 18:26
Re: delete and select with IN clause issues Jeff Frost 18:36
Index + View Question Dylan Lorimer 19:17
Re: Index + View Question Andrew Sullivan 19:36
Re: Index + View Question imad 19:48
Long SQL Update Question Dylan Lorimer 22:21
Re: Function to reset sequence..... Anonymous 23:52

Nov. 4, 2006

Thread Author Time
Duplicate Fields + Views Questions Dylan Lorimer 00:07
Re: Duplicate Fields + Views Questions Richard Broersma Jr 00:18
Re: Duplicate Fields + Views Questions Dylan Lorimer 00:28
Re: Long SQL Update Question imad 09:08

Nov. 5, 2006

Thread Author Time
Create View Mark Simon 06:17
Create Function (SQL) Mark Simon 06:21
Re: Create View Peter Eisentraut 07:38
Re: Create Function (SQL) imad 11:59
a celko-puzzle from long time ago stig erikson 18:46

Nov. 6, 2006

Thread Author Time
Nested select Hubert Retif 11:08
Re: Nested select imad 19:07
Re: Composite Types Tom Lane 19:18
Groups and Roles and Users Ezequias Rodrigues da Rocha 19:18
Re: fetching unique pins in a high-transaction environment... Scott Marlowe 19:21
Re: Nested select Tom Lane 19:21
Re: Distribution of results Jorge Godoy 19:25
Re: Composite Types imad 19:34
Re: Distribution of results imad 19:43
Re: a celko-puzzle from long time ago Richard Broersma Jr 19:54
Re: Groups and Roles and Users Richard Broersma Jr 19:59
Re: fetching unique pins in a high-transaction environment... Richard Broersma Jr 20:04
Re: Database recovery in postgres 7.2.4. Scott Marlowe 20:08
Re: fetching unique pins in a high-transaction environment... Scott Marlowe 20:29
Requirement for PostgreSQL Database Developer Mark 21:49
Re: Requirement for PostgreSQL Database Developer Richard Broersma Jr 22:12
Fwd: refining view using temp tables Aaron Bono 22:51
Re: show privileges Aaron Bono 23:01
Re: a celko-puzzle from long time ago George Pavlov 23:47
Re: show privileges Joe 23:49

Nov. 7, 2006

Thread Author Time
converting Informix outer to Postgres gurkan 00:10
Re: converting Informix outer to Postgres George Pavlov 00:56
Re: converting Informix outer to Postgres Richard Broersma Jr 00:58
writing a simple sql parser and database program Peter Michaux 07:02
Re: writing a simple sql parser and database program Jonah H. Harris 12:32
Re: Nested select Aaron Bono 14:40
Re: Distribution of results Aaron Bono 14:59
Re: Nested select Scott Marlowe 18:03
Re: delete and select with IN clause issues Jeff Frost 23:08
Re: converting Informix outer to Postgres gurkan 23:49

Nov. 8, 2006

Thread Author Time
Re: Groups and Roles and Users Erwin Brandstetter 00:09
Re: Is there anyway to... Jim C. Nasby 06:13
Re: delete and select with IN clause issues Jeff Frost 08:23
unsubscribe Alejandro Fernandez 12:41

Nov. 9, 2006

Thread Author Time
Re: [SQL] [ADMIN] Is there anyway to... operationsengineer1 01:24
Re: [SQL] [ADMIN] Is there anyway to... Richard Huxton 10:19

Nov. 10, 2006

Thread Author Time
Constraint on multicolumn index Stuart Brooks 10:21
Between and miliseconds (timestamps) Ezequias Rodrigues da Rocha 14:28
Re: Between and miliseconds (timestamps) A. Kretschmer 14:44
Re: Constraint on multicolumn index Tom Lane 15:07
Wildcard LIKE and Sub-select Travis Whitton 15:23
Re: Between and miliseconds (timestamps) A. Kretschmer 15:24
Re: Wildcard LIKE and Sub-select Erik Jones 16:01
Re: Wildcard LIKE and Sub-select Travis Whitton 16:07
PostgesSQL equivalent of the Oracle 'contains' operator Wm.A.Stafford 16:10
Re: PostgesSQL equivalent of the Oracle 'contains' operator Richard Broersma Jr 17:27
Re: Between and miliseconds (timestamps) Ezequias Rodrigues da Rocha 18:34
Re: Between and miliseconds (timestamps) Joe 23:00

Nov. 12, 2006

Thread Author Time
Re: Between and miliseconds (timestamps) Ezequias Rodrigues da Rocha 14:03

Nov. 13, 2006

Thread Author Time
SQL - update table problem... Marko Rihtar 10:36
Re: Inserting data in composite types! Markus Schiltknecht 12:28
Inserting data in composite types! Rodrigo Sakai 12:37
Re: Inserting data in composite types! Shane Ambler 12:46
hiding column values for specific rows Luca Ferrari 13:11
Re: hiding column values for specific rows A. Kretschmer 13:22
max (timestamp,timestamp) T E Schmitz 13:46
Re: max (timestamp,timestamp) A. Kretschmer 14:08
Re: Inserting data in composite types! imad 14:09
Re: max (timestamp,timestamp) imad 14:29
Re: max (timestamp,timestamp) Michael Fuhr 15:06
drop a check ivan marchesini 16:32
COALESCE and GROUP BY and AGGREGATES Erik Jones 16:49
Re: COALESCE and GROUP BY and AGGREGATES Volkan YAZICI 17:03
Re: drop a check ivan marchesini 17:38
Re: drop a check Volkan YAZICI 17:41
Re: RES: Inserting data in composite types! Richard Broersma Jr 17:42
Re: Another question about composite types Richard Broersma Jr 17:46
Re: drop a check ivan marchesini 17:48
Re: COALESCE and GROUP BY and AGGREGATES Erik Jones 18:16
RES: Inserting data in composite types! Rodrigo Sakai 18:27
Another question about composite types Rodrigo Sakai 18:33
Re: drop a check Andreas Kretschmer 18:34
Re: drop a check Volkan YAZICI 19:01
Re: Another question about composite types imad 19:04
Re: drop a check Andreas Kretschmer 19:06
RES: Another question about composite types Rodrigo Sakai 19:13

Nov. 14, 2006

Thread Author Time
Re: Constraint on multicolumn index Stuart Brooks 12:50
Re: max (timestamp,timestamp) T E Schmitz 15:02
Re: hiding column values for specific rows Bricklen Anderson 18:43
Re: Case Preservation disregarding case sensitivity? Bruce Momjian 18:43
unexpected EOF within message length word Bryce Nesbitt 21:11
Re: [SQL] Case Preservation disregarding case Simon Riggs 21:42
Re: unexpected EOF within message length word Richard Broersma Jr 21:52

Nov. 15, 2006

Thread Author Time
Re: SQL - update table problem... Bruno Wolff III 06:50
sql problem with join Luca Ferrari 08:32
Re: sql problem with join Richard Broersma Jr 15:20
Re: [HACKERS] Case Preservation disregarding case Jim Nasby 15:47
Re: sql problem with join Luca Ferrari 16:59
Re: [SQL] Case Preservation disregarding case Andrew Dunstan 17:58
recursive SQL and with clause chrisj 18:45
Aggregate function to build 2-d array Steven Murdoch 20:42

Nov. 16, 2006

Thread Author Time
Re: Aggregate function to build 2-d array chrisj 00:32
Re: recursive SQL and with clause Christopher Browne 02:38
psql -F <TAB> T E Schmitz 11:18
Re: psql -F <TAB> Alvaro Herrera 11:58
Re: psql -F <TAB> T E Schmitz 12:09
Re: psql -F <TAB> Joe Conway 12:37
Re: recursive SQL and with clause Jonah H. Harris 13:18
Re: psql -F <TAB> Kazuyuki Maejima 14:31
Apoie o estudo das células tronco Ezequias Rodrigues da Rocha 14:54
Re: psql -F <TAB> T E Schmitz 15:36
Question about time Judith 16:14
Random() Ezequias Rodrigues da Rocha 18:31
Re: Random() A. Kretschmer 19:16
convert with libpq lms 19:53
Re: Random() Ezequias Rodrigues da Rocha 20:31
Re: Random() Ezequias Rodrigues da Rocha 20:54
Re: Random() Andrew Sullivan 21:20
Re: Question about time Joe 22:23
Re: Question about time Phillip Smith 22:27
Re: Question about time Hector Villarreal 23:19

Nov. 17, 2006

Thread Author Time
Re: [pgadmin-support] Groups and Roles and Users Jim Nasby 03:54
hi may i know y am i getting this error Penchalaiah P. 09:45
Re: hi may i know y am i getting this error Richard Huxton 11:04
Re: hi may i know y am i getting this error A. Kretschmer 11:07

Browse Archives

Prev | Next