pgsql-sql since 2007-10-11 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

Oct. 11, 2007

Thread	Author	Time
seg data type	TJ O'Donnell	04:59
Re: Refactored queries needing validation of syntactic equivalence	Richard Huxton	07:24
Accessing field of OLD in trigger	Daniel Drotos	12:17

Oct. 12, 2007

Thread	Author	Time
Accessing field of OLD in trigger	Daniel Drotos	10:00
Re: Accessing field of OLD in trigger	Josh Trutwin	13:18
How to escape a memo field as a binary value in postgresql	rdyes	14:06
OT: array_accum equivalent in Oracle	Andreas Joseph Krogh	14:16
Re: OT: array_accum equivalent in Oracle	Jonah H. Harris	15:02
Re: OT: array_accum equivalent in Oracle	Andreas Joseph Krogh	15:43
Re: OT: array_accum equivalent in Oracle	Jonah H. Harris	15:55
Re: Accessing field of OLD in trigger	Erik Jones	16:17

Oct. 13, 2007

Thread	Author	Time
Re: Refactored queries needing validation of syntactic equivalence	Mike Adams	17:44

Oct. 16, 2007

Thread	Author	Time
Re: Refactored queries needing validation of syntactic equivalence	Richard Huxton	08:27
Inconsistent sql result	Patrick De Zlio	10:00
Re: Inconsistent sql result	Gerardo Herzig	16:32
Having difficulty writing a "best-fit" query..	Jamie Tufnell	16:46
Re: Having difficulty writing a "best-fit" query..	Rodrigo De León	17:11
Re: Having difficulty writing a "best-fit" query..	Richard Broersma Jr	17:14
Re: Having difficulty writing a "best-fit" query..	Harald Fuchs	17:32
Re: Having difficulty writing a "best-fit" query..	Michael Glaesemann	17:34
what's wrong with my date comparison?	Tena Sakai	17:57
Re: what's wrong with my date comparison?	Tena Sakai	18:00
Re: what's wrong with my date comparison?	Andrew Sullivan	18:04
Re: what's wrong with my date comparison?	Michael Glaesemann	18:09
Re: what's wrong with my date comparison?	Tom Lane	20:53

Oct. 17, 2007

Thread	Author	Time
when inserting to table, text type parameter become NULL (after big assignment to this parameter)	Sofer, Yuval	07:09
two queryes in a single tablescan	Stefano Dal Pra	12:30
Re: two queryes in a single tablescan	Heikki Linnakangas	13:00
Re: two queryes in a single tablescan	Steinar H. Gunderson	13:15
Re: two queryes in a single tablescan	Stefano Dal Pra	13:21
Re: two queryes in a single tablescan	Heikki Linnakangas	13:39
[No subject]	Boergesson, Cheryl	18:49

Oct. 18, 2007

Thread	Author	Time
Re: two queryes in a single tablescan	李彦 Ian Li	02:24

Oct. 20, 2007

Thread	Author	Time
backup database tablespace with rsync?	chester c young	02:11
Re: Refactored queries needing validation of syntactic equivalence	Mike Adams	05:45
Re: backup database tablespace with rsync?	Scott Marlowe	09:01
Re: [SQL] two queryes in a single tablescan	Markus Schaber	10:58
Re: [SQL] two queryes in a single tablescan	Andreas Kretschmer	17:19
Re: [SQL] two queryes in a single tablescan	Erik Jones	22:02

Oct. 23, 2007

Thread	Author	Time
request for help with COPY syntax	Chuck D.	16:19
Re: request for help with COPY syntax	Fernando Hevia	16:44
Re: request for help with COPY syntax	Andrew Sullivan	16:46

Oct. 24, 2007

Thread	Author	Time
Quick question re foreign keys.	Paul Lambert	02:03
Re: Quick question re foreign keys.	Phillip Smith	02:14
Re: Quick question re foreign keys.	Tom Lane	02:44
Re: request for help with COPY syntax	Adrian Klaver	02:51
Re: Quick question re foreign keys.	Paul Lambert	03:00
Re: Quick question re foreign keys.	Paul Lambert	03:09
Re: Quick question re foreign keys.	D'Arcy J.M. Cain	05:27
Re: request for help with COPY syntax	Chuck D.	06:59
Re: request for help with COPY syntax	Chuck D.	07:02
Re: request for help with COPY syntax	Paul Lambert	07:10
Re: Quick question re foreign keys.	Nis Jørgensen	07:43
Re: request for help with COPY syntax	Harald Fuchs	09:19
get only rows for latest version of contents	Sébastien Meudec	09:29
Re: get only rows for latest version of contents	Christian Kindler	09:55
Re: request for help with COPY syntax	Fernando Hevia	13:56
Re: Quick question re foreign keys.	Robins Tharakan	14:27
Re: Quick question re foreign keys.	D'Arcy J.M. Cain	14:53

Oct. 25, 2007

Thread	Author	Time
ERROR: failed to re-find parent key in "pk_ep07"	Otniel Michael	02:31
Re: ERROR: failed to re-find parent key in "pk_ep07"	Tom Lane	04:45
Re: get only rows for latest version of contents	Sébastien Meudec	06:50
Re: ERROR: failed to re-find parent key in "pk_ep07"	Otniel Michael	08:26
Re: ERROR: failed to re-find parent key in "pk_ep07"	Gregory Stark	08:42
Re: ERROR: failed to re-find parent key in "pk_ep07"	Filip Rembiałkowski	08:50
Re: get only rows for latest version of contents	Erik Jones	14:34
Re: request for help with COPY syntax	Chuck D.	15:35
Re: request for help with COPY syntax	Chuck D.	16:16
(repost) Help understanding expressions in order by clause	Steve Midgley	16:44
Re: request for help with COPY syntax	Bricklen Anderson	16:57
Re: (repost) Help understanding expressions in order by clause	Tom Lane	17:03
JOINing based on whether an IP address is contained within a CIDR range?	Jamie Tufnell	18:22
Re: request for help with COPY syntax	Chuck D.	19:13
Re: JOINing based on whether an IP address is contained within a CIDR range?	Erik Jones	19:21
hidden versioning system	Darnell Brawner	19:32
Re: JOINing based on whether an IP address is contained within a CIDR range?	Tom Lane	19:32
Re: request for help with COPY syntax	Fernando Hevia	21:16

Oct. 26, 2007

Thread	Author	Time
Re: request for help with COPY syntax	Chuck D.	02:16
Re: request for help with COPY syntax	Tom Lane	03:22
Re: request for help with COPY syntax	Chuck D.	04:26
Re: get only rows for latest version of contents	Sébastien Meudec	07:59
Re: JOINing based on whether an IP address is contained within a CIDR range?	Harald Fuchs	11:44
Re: JOINing based on whether an IP address is contained within a CIDR range?	Jonah H. Harris	12:03
Re: request for help with COPY syntax	Chuck D.	16:29

Oct. 28, 2007

Thread	Author	Time
Removing whitespace using regexp_replace	Thomas Kellerer	11:20
Re: Removing whitespace using regexp_replace	Andreas Kretschmer	11:42
Re: Removing whitespace using regexp_replace	Thomas Kellerer	12:15
Re: Removing whitespace using regexp_replace	Andreas Kretschmer	12:32
Re: Removing whitespace using regexp_replace	Thomas Kellerer	14:35
Select into with dynamic criteria in a plpgsql function	Paul Lambert	23:11
Re: Select into with dynamic criteria in a plpgsql function	Paul Lambert	23:19

Oct. 29, 2007

Thread	Author	Time
update from select	dev	09:18
Re: update from select	A. Kretschmer	10:45
Re: update from select	Pavel Stehule	11:03
Re: update from select	Tom Lane	14:30
Re: update from select	dev	15:28
Re: update from select	Pavel Stehule	15:46
Re: update from select	Tom Lane	18:42

Oct. 30, 2007

Thread	Author	Time
Perfomance benefit using Min() against order by & limit 1?	Fernando Hevia	20:42
puzzled by SELECT INTO	Gerardo Herzig	20:43
Re: puzzled by SELECT INTO	Rodrigo De León	20:57
Re: Perfomance benefit using Min() against order by & limit 1?	Fernando Hevia	21:00

Oct. 31, 2007

Thread	Author	Time
Re: puzzled by SELECT INTO	Gerardo Herzig	12:28
Returning the total number of rows as a separate column when using limit	Andreas Joseph Krogh	15:55
Backup Database	Joanne Salerno	17:14
Re: Backup Database	Andrew Sullivan	19:04

Nov. 1, 2007

Thread	Author	Time
Scrolling cursors in PL/PgSQL	Dawid Kuroczko	20:19
Re: Scrolling cursors in PL/PgSQL	Raymond O'Donnell	21:02
Re: Scrolling cursors in PL/PgSQL	Pavel Stehule	21:05
Re: Scrolling cursors in PL/PgSQL	Tom Lane	21:22

Nov. 4, 2007

Thread	Author	Time
omitting redundant join predicate	Ehab Galal	13:14
Re: omitting redundant join predicate	Tom Lane	16:35
SELECT DISTINCT ... ORDER BY UPPER(column_name) fails	Aymeric Levaux	16:49
Re: SELECT DISTINCT ... ORDER BY UPPER(column_name) fails	Tom Lane	17:12
Partitioning and Foreign Keys	Volkan YAZICI	17:57

Nov. 5, 2007

Thread	Author	Time
Returning the total number of rows as a separate column when using limit	Andreas Joseph Krogh	07:36
Re: Backup Database	Asko Oja	09:30
changing encoding of a postgres database	Kenneth Gonsalves	11:55
Re: Returning the total number of rows as a separate column when using limit	Tom Lane	14:18
Re: Returning the total number of rows as a separate column when using limit	Andreas Joseph Krogh	14:38
Re: Returning the total number of rows as a separate column when using limit	Tom Lane	15:00
Re: omitting redundant join predicate	Ehab Galal	15:15
Re: Returning the total number of rows as a separate column when using limit	Gregory Stark	15:27
Re: omitting redundant join predicate	Tom Lane	16:08
Re: Returning the total number of rows as a separate column when using limit	Andreas Joseph Krogh	16:33
Re: Returning the total number of rows as a separate column when using limit	Gregory Stark	18:54

Nov. 6, 2007

Thread	Author	Time
Re: Returning the total number of rows as a separate column when using limit	Gregory Stark	06:58
Treating result of subselect as row	Ottó Havasvölgyi	10:09
Bitemporal - problem with correalated subquery?	Keith Carr	12:51

Nov. 7, 2007

Thread	Author	Time
EPOCH TIMESTAMP Conversion Problem	Amitanand Chikorde	10:37
Temporal databases	Philippe Lang	13:22
Re: EPOCH TIMESTAMP Conversion Problem	Tom Lane	15:35

Nov. 8, 2007

Thread	Author	Time
Re: Partitioning and Foreign Keys	Vivek Khera	16:45
Obtaining the primary key of the record just inserted	Oliveiros Cristina	17:56
Re: Obtaining the primary key of the record just inserted	Scott Marlowe	18:03
Re: Obtaining the primary key of the record just inserted	Oliveiros Cristina	19:10
quote_nullable alternative?	Philippe Lang	20:05

Nov. 9, 2007

Thread	Author	Time
Re: quote_nullable alternative?	Philippe Lang	07:14
design of tables for sparse data	Andreas	13:39
Re: Temporal databases	Keith Carr	14:01
Select in From clause	Ray Madigan	17:21
Re: Select in From clause	Alvaro Herrera	18:35
functions are returns columns	Michele Petrazzo - Unipex srl	19:46
Re: functions are returns columns	Pavel Stehule	20:35

Nov. 10, 2007

Thread	Author	Time
Re: functions are returns columns	Michele Petrazzo - Unipex srl	17:37
Re: functions are returns columns	Gregory Stark	19:36
Re: functions are returns columns	Tom Lane	19:46
Re: functions are returns columns	Gregory Stark	21:04
Re: functions are returns columns	Tom Lane	23:14

Nov. 11, 2007

Thread	Author	Time
general question on optimizer	chester c young	00:23

Nov. 12, 2007

Thread	Author	Time
Re: Select in From clause	Bart Degryse	08:23
Re: Temporal databases	Philippe Lang	09:07
show value of backslashes in string array argument	Sabin Coanda	09:15
Re: show value of backslashes in string array argument	Sabin Coanda	09:51
Re: show value of backslashes in string array argument	Achilleas Mantzios	09:58
plpgsql language not aware of standard_conforming_strings ?	Sabin Coanda	10:20
Re: show value of backslashes in string array argument	Achilleas Mantzios	10:20
Re: plpgsql language not aware of standard_conforming_strings ?	Sabin Coanda	11:10
Re: show value of backslashes in string array argument	Tom Lane	16:05
Re: plpgsql language not aware of standard_conforming_strings ?	Sabin Coanda	16:19
Re: show value of backslashes in string array argument	Sabin Coanda	17:12
Problem with UNION-queries	Andreas Joseph Krogh	20:27
Re: design of tables for sparse data	Fernando Hevia	21:48

Nov. 13, 2007

Thread	Author	Time
Re: design of tables for sparse data	Andreas	02:10
Re: design of tables for sparse data	Erik Jones	15:33

Nov. 14, 2007

Thread	Author	Time
Originally created and last_mod by whom and when ?	Aarni Ruuhimäki	11:06
Re: Originally created and last_mod by whom and when ?	Richard Huxton	11:28
Re: ALL() question	Richard Huxton	11:56
Re: Originally created and last_mod by whom and when ?	Aarni Ruuhimäki	12:39
Re: ALL() question	Bart Degryse	12:57
Re: ALL() question	Richard Huxton	13:20
Re: ALL() question	Richard Huxton	13:21
Re: ALL() question	hubert depesz lubaczewski	13:31
ALL() question	Julien Cigar	13:39
Re: Temporal databases	Philippe Lang	13:47
Re: ALL() question	Julien Cigar	14:50
Re: ALL() question	Julien Cigar	14:57
Re: ALL() question	Osvaldo Rosario Kussama	15:46
Re: ALL() question	Julien Cigar	15:50
postgres bogged down beyond tolerance	Tena Sakai	17:52
Re: postgres bogged down beyond tolerance	Richard Broersma Jr	18:35

Nov. 15, 2007

Thread	Author	Time
Re: postgres bogged down beyond tolerance	Gregory Stark	09:33
trap for any exception	Sabin Coanda	13:45
Re: trap for any exception	Sabin Coanda	13:52
Re: trap for any exception	Sabin Coanda	13:54
Re: trap for any exception	Stephan Szabo	15:35
Is there anything special about pg_dump's compression?	Jean-David Beyer	16:05
Re: Is there anything special about pg_dump's compression?	Andrew Sullivan	16:11
Re: trap for any exception	Stephan Szabo	18:36
Erlang & PostgreSQL native driver	Daniel Caune	19:06

Nov. 16, 2007

Thread	Author	Time
Re: Is there anything special about pg_dump's compression?	Jean-David Beyer	05:00
Re: Is there anything special about pg_dump's compression?	Tom Lane	05:29
Re: trap for any exception	Bart Degryse	07:56
Re: Is there anything special about pg_dump's compression?	Jean-David Beyer	12:54
Re: Is there anything special about pg_dump's compression?	Shane Ambler	16:40
Re: Is there anything special about pg_dump's compression?	Jean-David Beyer	20:36

Nov. 19, 2007

Thread	Author	Time
EXPLAIN ANALYZE inside functions	Sabin Coanda	13:17
Re: EXPLAIN ANALYZE inside functions	Sabin Coanda	14:48
Aggregate question (Sum)	Luiz K. Matsumura	20:46
Re: Aggregate question (Sum)	Rodrigo De León	21:11

Browse Archives

Prev | Next