Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-sql - October 2007
Prev | Next
2007-10-01
- Populate unique column with default value Jon Horsman (15:24)
- Re: Populate unique column with default value Jon Horsman (15:33)
- Re: Populate unique column with default value Rodrigo De Le� (15:39)
- Re: Populate unique column with default value Jon Horsman (15:51)
2007-10-02
- Finding broken regex'es Enrico Weigelt (20:23)
- Re: Finding broken regex'es Erik Jones (21:36)
2007-10-03
- Why does the sequence skip a number with generate_series? Jeff Frost (00:20)
- Re: Finding broken regex'es Tom Lane (03:48)
- Re: Finding broken regex'es Erik Jones (05:43)
- Re: Finding broken regex'es Tom Lane (06:03)
- Re: Finding broken regex'es Dawid Kuroczko (13:36)
- Re: Finding broken regex'es Filip Rembiałkowski (14:40)
- Re: Finding broken regex'es Dawid Kuroczko (15:41)
- Need help with CASE statement in Function Hengky Lie (16:44)
- Re: Need help with CASE statement in Function Dawid Kuroczko (17:04)
- Re: Need help with CASE statement in Function Richard Broersma Jr (17:07)
2007-10-04
- field separator problem Tena Sakai (00:13)
- Re: field separator problem Michael Fuhr (00:54)
- Re: Why does the sequence skip a number with generate_series? Stephan Szabo (01:06)
- Re: field separator problem Tena Sakai (02:25)
- Postgres Array Traversing Problem yogesh (09:26)
- Rule Error Hengky Lie (11:22)
- Re: Rule Error Richard Huxton (12:53)
- Re: Rule Error Bart Degryse (12:57)
- Re: Rule Error A. Kretschmer (13:00)
- Re: Why does the sequence skip a number with generate_series? Shane Ambler (14:25)
- Re: [HACKERS] Why does the sequence skip a number withgenerate_series? Alvaro Herrera (14:46)
- Re: [HACKERS] Why does the sequence skip a number with generate_series? Tom Lane (15:18)
- What SQL is running against my DB? Tore Lukashaugen (17:39)
- Re: What SQL is running against my DB? Andreas Kretschmer (18:18)
- Re: Rule Error Hengky Lie (23:59)
2007-10-05
- Re: Rule Error A. Kretschmer (04:56)
- Re: Postgres Array Traversing Problem Dawid Kuroczko (08:55)
- pg_dump question Judith (16:58)
- Re: pg_dump question Erik Jones (21:11)
- valid query runs forever? Aroon Pahwa (21:33)
2007-10-06
- Re: [SQL] Why does the sequence skip a number with generate_series? Shane Ambler (00:50)
2007-10-07
- Re: SQL query question Rodrigo De León (19:16)
2007-10-08
- Get different sums from the same table in one query Dani Castaños (10:49)
- Re: Get different sums from the same table in one query A. Kretschmer (10:54)
- Re: Get different sums from the same table in one query Peter Childs (11:32)
- Re: Get different sums from the same table in one query Richard Huxton (11:37)
- Re: Get different sums from the same table in one query A. Kretschmer (11:59)
- Re: UNIQUEness and time interval Rodrigo De León (14:46)
2007-10-09
- array handling on 8.0.3 Daniel Drotos (13:11)
- Re: finding unused indexes? George Pavlov (18:58)
- Re: array handling on 8.0.3 Daniel Drotos (19:28)
- Re: array handling on 8.0.3 Daniel Drotos (19:36)
2007-10-10
- Re: finding unused indexes? Tom Lane (13:35)
- Re: finding unused indexes? George Pavlov (17:13)
- Computed table name in function Ray Madigan (17:59)
- Re: Computed table name in function Scott Marlowe (18:10)
- Re: Computed table name in function Ray Madigan (18:19)
- Re: Computed table name in function Daniel Drotos (18:50)
- Re: Computed table name in function Richard Huxton (18:52)
- Refactored queries needing validation of syntactic equivalence Mike Adams (23:25)
2007-10-11
- 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)
2007-10-12
- 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)
2007-10-13
- Re: Refactored queries needing validation of syntactic equivalence Mike Adams (17:44)
2007-10-16
- 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)
2007-10-17
- 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)
2007-10-18
- Re: two queryes in a single tablescan 李彦 Ian Li (02:24)
2007-10-20
- 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)
2007-10-23
- 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)
2007-10-24
- 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)
2007-10-25
- 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)
2007-10-26
- 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)
2007-10-28
- 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)
2007-10-29
- 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)
2007-10-30
- 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)
2007-10-31
- 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)