pgsql-sql since 2006-11-07 00:00

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. 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
How convert UNICODE lms 17:09
query faster using LEFT OUTER join? Drew 21:16
Re: How convert UNICODE Drew 21:17
Re: How convert UNICODE lms 23:00
Re: sql problem with join Aaron Bono 23:04
Re: How convert UNICODE lms 23:10
Re: Random() Aaron Bono 23:14

Nov. 18, 2006

Thread Author Time
transactional shared variable in postgresql Rajesh Kumar Mallah 12:30
Re: transactional shared variable in postgresql imad 13:46
Re: transactional shared variable in postgresql Rajesh Kumar Mallah 15:01
Re: Random() Rajesh Kumar Mallah 17:32
Re: transactional shared variable in postgresql Volkan YAZICI 17:36
Re: Random() A. Kretschmer 17:52
Re: transactional shared variable in postgresql Rajesh Kumar Mallah 17:58
Re: transactional shared variable in postgresql Volkan YAZICI 18:34
Re: transactional shared variable in postgresql Tom Lane 18:40
Re: Random() Rajesh Kumar Mallah 18:45
Re: transactional shared variable in postgresql Rajesh Kumar Mallah 19:15
Re: transactional shared variable in postgresql imad 19:45

Nov. 19, 2006

Thread Author Time
Re: How convert UNICODE lms 00:33
planner used functional index in 7.3.6, now does a seq scan in 7.4.7 after upgrade Chris Tennant 06:10
Re: planner used functional index in 7.3.6, now does a seq scan in 7.4.7 after upgrade Tom Lane 07:28
Re: planner used functional index in 7.3.6, now does a seq Chris Tennant 16:44
Re: planner used functional index in 7.3.6, now does a seq Tom Lane 19:00
Re: planner used functional index in 7.3.6, now does a seq Chris Tennant 23:20

Nov. 20, 2006

Thread Author Time
Re: query faster using LEFT OUTER join? Richard Huxton 08:29
tsvector_eq appears to be inconsistent. Rajesh Kumar Mallah 09:09
Re: planner used functional index in 7.3.6, now does a seq Dimitri Fontaine 09:16
Re: transactional shared variable in postgresql Rajesh Kumar Mallah 10:37
Re: tsvector_eq appears to be inconsistent. Tom Lane 16:50
How to find out top 3 records in each location wen tseng 17:09
Re: How to find out top 3 records in each location Andrew Sullivan 17:48
Re: How to find out top 3 records in each location Richard Broersma Jr 17:49
Re: How to find out top 3 records in each location Richard Broersma Jr 17:57
Re: How convert UNICODE lms 18:28

Nov. 21, 2006

Thread Author Time
Embedded mySQL Abdul Wahab Dahalan 01:35
LOG: logger shutting down anil maran 01:59
Re: Embedded mySQL Richard Broersma Jr 06:02
Re: tsvector_eq appears to be inconsistent. [ SOLVED (upgrade to 8.1.5) ] Rajesh Kumar Mallah 06:09
Re: Embedded mySQL Richard Broersma Jr 06:18
"Copy from" omit source columns? Steve Midgley 19:13
Re: "Copy from" omit source columns? Richard Broersma Jr 22:38
Re: "Copy from" omit source columns? Aaron Bono 23:42

Nov. 22, 2006

Thread Author Time
select into Mulham freshcode 08:28
Re: select into A. Kretschmer 15:47
Re: select into Richard Broersma Jr 15:55
Re: select into Andreas Kretschmer 16:07
Re: select into Tom Lane 16:14
Re: select into Richard Broersma Jr 17:26
Regular Expressions, LIKE, and indexes Travis Whitton 19:10
Re: Regular Expressions, LIKE, and indexes Richard Huxton 19:20
How to check coding lms 20:54

Nov. 23, 2006

Thread Author Time
Re: select into Mulham freshcode 17:19
Re: select into Adrian Klaver 18:35

Nov. 24, 2006

Thread Author Time
Re: select into Mulham freshcode 04:21
Re: select into Tom Lane 04:45
Re: select into Mulham freshcode 06:54
Numbers Ezequias Rodrigues da Rocha 13:07
Re: Numbers Achilleas Mantzios 13:49
Re: Numbers Joe 14:35
PgAgent [where is it?] Ezequias Rodrigues da Rocha 14:35
Re: select into Adrian Klaver 14:45
Re: select into Andreas Kretschmer 14:55
Re: select into Adrian Klaver 15:26
Re: select into Adrian Klaver 15:30
Re: select into Tom Lane 16:02

Nov. 25, 2006

Thread Author Time
Re: select into Mulham freshcode 04:17

Nov. 26, 2006

Thread Author Time
Re: select into Adrian Klaver 22:45

Nov. 27, 2006

Thread Author Time
Re: select into Adrian Klaver 02:23
UNICODE and PL/PGSQL Bart Degryse 10:52
Re: [SQL] PgAgent [where is it?] Markus Schaber 13:48
Re: UNICODE and PL/PGSQL Ragnar 14:37
Re: UNICODE and PL/PGSQL Bart Degryse 14:54
Re: UNICODE and PL/PGSQL Markus Schaber 15:16
Auto-Response: Re: UNICODE and PL/PGSQL atrentacost 15:17
Re: UNICODE and PL/PGSQL Bart Degryse 15:32
Re: UNICODE and PL/PGSQL Markus Schaber 15:53
Re: UNICODE and PL/PGSQL Richard Huxton 15:53
Auto-Response: Re: UNICODE and PL/PGSQL atrentacost 15:54
Re: UNICODE and PL/PGSQL Ragnar 15:57
Re: UNICODE and PL/PGSQL Bart Degryse 16:05
Re: UNICODE and PL/PGSQL Bart Degryse 16:10
Re: UNICODE and PL/PGSQL Markus Schaber 16:34
Re: UNICODE and PL/PGSQL Richard Huxton 16:34

Nov. 28, 2006

Thread Author Time
Re: select into Mulham freshcode 02:31
Re: select into Adrian Klaver 03:00
Re: UNICODE and PL/PGSQL Bart Degryse 08:14
Re: UNICODE and PL/PGSQL Bart Degryse 08:16
Re: UNICODE and PL/PGSQL Ragnar 09:28

Nov. 29, 2006

Thread Author Time
consistent random order Jeff Herrin 16:38
Subselects in CHECK clause ... James Robinson 17:08
Re: consistent random order Aaron Bono 17:23
Re: consistent random order Andreas Kretschmer 17:27
Re: consistent random order Jeff Herrin 17:30
Re: consistent random order Jeff Herrin 17:32
Re: Subselects in CHECK clause ... Stephan Szabo 17:53
Re: Subselects in CHECK clause ... James Robinson 17:59

Nov. 30, 2006

Thread Author Time
SQL command join question Ehab Galal 00:41
Re: SQL command join question Phillip Smith 00:46
Re: SQL command join question Stephan Szabo 00:57
Re: SQL command join question Richard Broersma Jr 00:57
Re: SQL command join question Tom Lane 01:02
Re: consistent random order Michael Fuhr 07:58
Re: UNICODE and PL/PGSQL Bart Degryse 08:15
Re: consistent random order Shane Ambler 10:04

Browse Archives

Prev | Next