pgsql-sql since 2006-11-17 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

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
Autovaccum Ezequias Rodrigues da Rocha 14:02
Re: Autovaccum Alvaro Herrera 14:24
Re: Autovaccum Peter Childs 14:56
Re: Autovaccum Ezequias Rodrigues da Rocha 15:03
Re: Autovaccum Shane Ambler 15:10
pg_xlog on separate drive Travis Whitton 15:50
Re: consistent random order Jeff Herrin 16:02
Re: pg_xlog on separate drive Tom Lane 16:45
Re: Autovaccum Matthew T. O'Connor 18:08
Re: Autovaccum Ezequias Rodrigues da Rocha 18:11
Select (1-3) Ezequias Rodrigues da Rocha 18:30
Re: Select (1-3) Aaron Bono 18:35
Re: Select (1-3) Alvaro Herrera 18:36
Re: Select (1-3) Ezequias Rodrigues da Rocha 18:43
Grants 📎 Ezequias Rodrigues da Rocha 19:41
Re: [SQL] Grants imad 20:24

Dec. 1, 2006

Thread Author Time
retrieve row number Pascal Tufenkji 06:31
Re: retrieve row number A. Kretschmer 06:56
Set binary column dependent on cumulative value of integer column Markus Juenemann 13:37
Setting boolean column based on cumulative integer value Markus Juenemann 13:50
Re: [SQL] Grants Ezequias Rodrigues da Rocha 14:03
Re: Setting boolean column based on cumulative integer value A. Kretschmer 14:44
Re: Setting boolean column based on cumulative integer value Richard Broersma Jr 14:48
Re: [SQL] Grants Adrian Klaver 15:42
calling elog possibly causing problem in DirectFunctionCall1 Rajesh Kumar Mallah 16:40
Re: Autovaccum Shane Ambler 17:06
Re: calling elog possibly causing problem in DirectFunctionCall1 Tom Lane 17:47
Re: calling elog possibly causing problem in DirectFunctionCall1 Rajesh Kumar Mallah 17:59
Re: calling elog possibly causing problem in DirectFunctionCall1 Rajesh Kumar Mallah 18:58
Problem inserting composite type values Chris Dunworth 19:15
Re: Problem inserting composite type values Stephan Szabo 23:53

Dec. 2, 2006

Thread Author Time
Re: Setting boolean column based on cumulative integer value Aaron Bono 00:43
Re: Problem inserting composite type values Aaron Bono 00:56
Re: Problem inserting composite type values Chris Dunworth 03:49
Re: Problem inserting composite type values Chris Dunworth 04:02
Re: Problem inserting composite type values Aaron Bono 04:20
Tracking Down Error in Stored Procedure Aaron Bono 05:48
Re: Tracking Down Error in Stored Procedure Tom Lane 06:20
Re: Tracking Down Error in Stored Procedure Aaron Bono 07:19
Re: [HACKERS] Case Preservation disregarding case Ken Johanson 07:41
Re: [SQL] Case Preservation disregarding case Martijn van Oosterhout 13:35
Re: [HACKERS] Case Preservation disregarding case Ken Johanson 15:21
Re: [HACKERS] Case Preservation disregarding case Dennis Bjorklund 16:02
Re: [HACKERS] Case Preservation disregarding case Ken Johanson 16:48
Re: [HACKERS] Case Preservation disregarding case Dennis Bjorklund 17:10
Re: [HACKERS] Case Preservation disregarding case Ken Johanson 18:08
Re: [SQL] Grants Melvin Davidson 20:31

Dec. 3, 2006

Thread Author Time
Re: [HACKERS] Case Preservation disregarding case Ken Johanson 04:57
Re: [HACKERS] Case Preservation disregarding case Tom Lane 05:55
Re: [HACKERS] Case Preservation disregarding case Ken Johanson 07:32
hi any one can help me Penchalaiah P. 10:33
Re: hi any one can help me Jeff Lu 15:46
Re: hi any one can help me Aaron Bono 15:54
Re: [HACKERS] Case Preservation disregarding case Ken Johanson 16:00
Re: [HACKERS] Case Preservation disregarding case Bruce Momjian 16:57
Query for block updates Amit Shah 22:19
Re: Query for block updates Tom Lane 22:22

Dec. 4, 2006

Thread Author Time
Re: pg_xlog on separate drive Markus Schaber 10:56
Re: pg_xlog on separate drive Travis Whitton 14:04
Using Control Flow Functions in a SELECT Statement Ashish Ahlawat 16:21
Re: Using Control Flow Functions in a SELECT Statement Richard Broersma Jr 16:30
Re: Using Control Flow Functions in a SELECT Statement Bricklen Anderson 16:32
Re: Using Control Flow Functions in a SELECT Statement Ashish Ahlawat 16:42
Re: Using Control Flow Functions in a SELECT Statement Richard Broersma Jr 16:48
Re: [SQL] Grants Ezequias Rodrigues da Rocha 17:08

Dec. 5, 2006

Thread Author Time
null values in non-nullable column George Pavlov 00:33
Re: null values in non-nullable column Tom Lane 02:52
Re: null values in non-nullable column Michael Glaesemann 03:30
Re: null values in non-nullable column Tom Lane 03:49
Re: null values in non-nullable column Michael Glaesemann 04:05
transaction in function Marian POPESCU 15:25
Re: transaction in function A. Kretschmer 16:23
Re: transaction in function Tom Lane 16:57
Question about "AT TIME ZONE" Collin Peters 20:29
Re: transaction in function Din Adrian 20:32
Can someone explain the problem with this select Richard Ray 20:33
Re: Question about "AT TIME ZONE" Tom Lane 21:06
Re: Can someone explain the problem with this select Ted Allen 21:14
Re: Can someone explain the problem with this select Tom Lane 21:14
Re: Can someone explain the problem with this select Richard Broersma Jr 21:15
Re: Can someone explain the problem with this select Richard Ray 21:21
Re: Using Control Flow Functions in a SELECT Statement Ragnar 23:07
I don't want receive more emails Eliana Gutierrez 23:11

Dec. 6, 2006

Thread Author Time
Re: I don't want receive more emails Richard Broersma Jr 01:02
Re: [HACKERS] Case Preservation disregarding case Ken Johanson 04:28
Proper way of iterating over the column names in a trigger function. Rajesh Kumar Mallah 12:30
Count field in query lucas 12:32
Re: Proper way of iterating over the column names in a trigger function. Tom Lane 15:02
Query is fast and function is slow Richard Ray 15:44
Re: Proper way of iterating over the column names in a trigger function. [ SOLVED] Rajesh Kumar Mallah 17:39
INSERT DELETE RETURNING Phillip Smith 23:02

Browse Archives

Prev | Next