Home > mailing lists

Mailing lists [pgsql-sql]

1 October 2007

15:24 Populate unique column with default value Jon Horsman
15:33 Re: Populate unique column with default value Jon Horsman
15:40 Re: Populate unique column with default value Rodrigo De Le�
15:51 Re: Populate unique column with default value Jon Horsman

2 October 2007

20:30 Finding broken regex'es Enrico Weigelt

3 October 2007

00:43 Re: Finding broken regex'es Erik Jones
03:48 Re: Finding broken regex'es Tom Lane
05:43 Re: Finding broken regex'es Erik Jones
06:03 Re: Finding broken regex'es Tom Lane
13:36 Re: Finding broken regex'es Dawid Kuroczko
14:40 Re: Finding broken regex'es Filip Rembiałkowski
15:41 Re: Finding broken regex'es Dawid Kuroczko
16:44 Need help with CASE statement in Function Hengky Lie
17:04 Re: Need help with CASE statement in Function Dawid Kuroczko
17:07 Re: Need help with CASE statement in Function Richard Broersma Jr

4 October 2007

00:13 field separator problem Tena Sakai
00:20 Why does the sequence skip a number with generate_series? Jeff Frost
00:54 Re: field separator problem Michael Fuhr
01:33 Re: Why does the sequence skip a number with generate_series? Stephan Szabo
02:25 Re: field separator problem Tena Sakai
11:23 Rule Error Hengky Lie
12:53 Re: Rule Error Richard Huxton
12:57 Re: Rule Error Bart Degryse
13:01 Re: Rule Error A. Kretschmer
14:25 Re: Why does the sequence skip a number with generate_series? Shane Ambler
14:48 Re: [HACKERS] Why does the sequence skip a number with generate_series? Alvaro Herrera
15:19 Re: [HACKERS] Why does the sequence skip a number with generate_series? Tom Lane
17:54 What SQL is running against my DB? Tore Lukashaugen
18:13 Re: What SQL is running against my DB? Andreas Kretschmer

5 October 2007

00:00 Re: Rule Error Hengky Lie
04:56 Re: Rule Error A. Kretschmer
08:56 Re: [ADMIN] Postgres Array Traversing Problem Dawid Kuroczko
19:56 pg_dump question Judith
21:12 Re: pg_dump question Erik Jones
22:05 valid query runs forever? Aroon Pahwa

7 October 2007

19:25 Re: SQL query question Rodrigo De León

8 October 2007

10:49 Get different sums from the same table in one query Dani Castaños
10:54 Re: Get different sums from the same table in one query A. Kretschmer
11:33 Re: Get different sums from the same table in one query Peter Childs
11:37 Re: Get different sums from the same table in one query Richard Huxton
11:59 Re: Get different sums from the same table in one query A. Kretschmer
14:55 Re: UNIQUEness and time interval Rodrigo De León

9 October 2007

14:02 array handling on 8.0.3 Daniel Drotos
19:06 Re: finding unused indexes? George Pavlov
19:29 Re: array handling on 8.0.3 Daniel Drotos
19:36 Re: array handling on 8.0.3 Daniel Drotos

10 October 2007

13:36 Re: finding unused indexes? Tom Lane
17:19 Re: finding unused indexes? George Pavlov
17:59 Computed table name in function Ray Madigan
18:10 Re: Computed table name in function Scott Marlowe
18:20 Re: Computed table name in function Ray Madigan
18:50 Re: Computed table name in function Daniel Drotos
18:52 Re: Computed table name in function Richard Huxton
23:27 Refactored queries needing validation of syntactic equivalence Mike Adams

11 October 2007

05:14 seg data type TJ O'Donnell
07:25 Re: Refactored queries needing validation of syntactic equivalence Richard Huxton
12:17 Accessing field of OLD in trigger Daniel Drotos

12 October 2007

10:02 Accessing field of OLD in trigger Daniel Drotos
13:18 Re: Accessing field of OLD in trigger Josh Trutwin
14:07 How to escape a memo field as a binary value in postgresql rdyes@monroehosp.org
14:17 OT: array_accum equivalent in Oracle Andreas Joseph Krogh
15:02 Re: OT: array_accum equivalent in Oracle Jonah H. Harris
15:44 Re: OT: array_accum equivalent in Oracle Andreas Joseph Krogh
15:56 Re: OT: array_accum equivalent in Oracle Jonah H. Harris
16:18 Re: Accessing field of OLD in trigger Erik Jones

13 October 2007

17:46 Re: Refactored queries needing validation of syntactic equivalence Mike Adams

16 October 2007

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

17 October 2007

07:09 when inserting to table, text type parameter become NULL (after big assignment to this parameter) Sofer, Yuval
08:05 Re: Having difficulty writing a "best-fit" query.. Harald Fuchs
12:37 two queryes in a single tablescan Stefano Dal Pra
13:22 Re: [PERFORM] two queryes in a single tablescan Stefano Dal Pra
18:59 Boergesson, Cheryl

20 October 2007

02:11 backup database tablespace with rsync? chester c young
13:59 Re: Refactored queries needing validation of syntactic equivalence Mike Adams
14:52 Re: backup database tablespace with rsync? Scott Marlowe
16:31 Re: two queryes in a single tablescan Markus Schaber
17:14 Re: [PERFORM] two queryes in a single tablescan Andreas Kretschmer
22:02 Re: [PERFORM] two queryes in a single tablescan Erik Jones

23 October 2007

16:25 request for help with COPY syntax Chuck D.
16:47 Re: request for help with COPY syntax Andrew Sullivan
16:58 Re: request for help with COPY syntax Fernando Hevia

24 October 2007

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

25 October 2007

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

26 October 2007

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

28 October 2007

11:21 Removing whitespace using regexp_replace Thomas Kellerer
11:42 Re: Removing whitespace using regexp_replace Andreas Kretschmer
12:15 Re: Removing whitespace using regexp_replace Thomas Kellerer
12:33 Re: Removing whitespace using regexp_replace Andreas Kretschmer
14:39 Re: Removing whitespace using regexp_replace Thomas Kellerer
23:11 Select into with dynamic criteria in a plpgsql function Paul Lambert
23:20 Re: Select into with dynamic criteria in a plpgsql function Paul Lambert

29 October 2007

09:18 update from select
10:45 Re: update from select A. Kretschmer
11:03 Re: update from select Pavel Stehule
14:30 Re: update from select Tom Lane
15:28 Re: update from select
15:46 Re: update from select Pavel Stehule
18:43 Re: update from select Tom Lane

30 October 2007

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

31 October 2007

14:28 Re: puzzled by SELECT INTO Gerardo Herzig
16:46 Returning the total number of rows as a separate column when using limit Andreas Joseph Krogh
18:28 Backup Database Joanne Salerno
20:41 Re: Backup Database Andrew Sullivan