pgsql-sql - October 2007

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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 16 17 18 20 23 24 25 26 28 29 30 31

Oct. 1, 2007

Thread Author Time
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

Oct. 2, 2007

Thread Author Time
Finding broken regex'es Enrico Weigelt 20:23
Re: Finding broken regex'es Erik Jones 21:36

Oct. 3, 2007

Thread Author Time
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

Oct. 4, 2007

Thread Author Time
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 with generate_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

Oct. 5, 2007

Thread Author Time
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

Oct. 6, 2007

Thread Author Time
Re: [SQL] Why does the sequence skip a number with generate_series? Shane Ambler 00:50

Oct. 7, 2007

Thread Author Time
Re: SQL query question Rodrigo De León 19:16

Oct. 8, 2007

Thread Author Time
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

Oct. 9, 2007

Thread Author Time
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

Oct. 10, 2007

Thread Author Time
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

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 16 17 18 20 23 24 25 26 28 29 30 31