pgsql-sql - February 2010

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 9 10 11 12 13 15 16 17 18 19 21 22 24 25 26 27

Feb. 1, 2010

Thread Author Time
Fwd: Help required on query performance Dave Clements 00:50
Re: Fwd: Help required on query performance Scott Marlowe 00:54
Re: Fwd: Help required on query performance Dave Clements 01:02
Re: Fwd: Help required on query performance Scott Marlowe 01:04
Re: Fwd: Help required on query performance Dave Clements 01:09
Re: Fwd: Help required on query performance Scott Marlowe 01:13
Re: Fwd: Help required on query performance Dave Clements 01:22
Re: Fwd: Help required on query performance Tom Lane 03:32
Re: Fwd: Help required on query performance Dave Clements 04:25
Re: Howto have a unique restraint on UPPER (textfield) Andreas 04:27
Re: Howto have a unique restraint on UPPER (textfield) Tom Lane 04:41
Re: Fwd: Help required on query performance Scott Marlowe 05:16
combine SQL SELECT statements into one Neil Stlyz 07:36
Re: combine SQL SELECT statements into one Florent THOMAS 08:35
Re: combine SQL SELECT statements into one A. Kretschmer 09:03
Re: combine SQL SELECT statements into one Chris.Ellis 09:08
Re: combine SQL SELECT statements into one msi77 10:10
Re: combine SQL SELECT statements into one msi77 10:11
Re: combine SQL SELECT statements into one Leo Mannhart 11:17
Re: combine SQL SELECT statements into one Sam Mason 12:08
selecting rows tagged with "a" but not "b" 8q5tmkyqry 13:31
Re: selecting rows tagged with "a" but not "b" Oliveiros C, 13:44
Re: selecting rows tagged with "a" but not "b" Andreas Gaab 13:50
Re: selecting rows tagged with "a" but not "b" Milen A. Radev 13:56
Re: selecting rows tagged with "a" but not "b" Andreas Kretschmer 14:14
Re: selecting rows tagged with "a" but not "b" Yeb Havinga 14:52
Crosstab Confusion Adam Sherman 15:03
Re: Crosstab Confusion Lee Hachadoorian 16:34
Re: Crosstab Confusion Adam Sherman 16:52
Re: combine SQL SELECT statements into one Igor Neyman 19:09
Re: Crosstab Confusion Lee Hachadoorian 19:22
Re: Crosstab Confusion Adam Sherman 20:11
Re: combine SQL SELECT statements into one Scott Marlowe 20:25
Re: combine SQL SELECT statements into one Chris.Ellis 20:39
Re: Crosstab Confusion Lee Hachadoorian 21:14

Feb. 2, 2010

Thread Author Time
please help me on regular expression Tena Sakai 19:22
Re: please help me on regular expression Pavel Stehule 20:38
Re: please help me on regular expression Tena Sakai 23:16

Feb. 3, 2010

Thread Author Time
Re: please help me on regular expression msi77 11:38
Re: please help me on regular expression Tena Sakai 16:35
Re: please help me on regular expression Dirk Jagdmann 19:43
Re: please help me on regular expression Tena Sakai 20:32
Re: please help me on regular expression Lars Gustafsson 21:33

Feb. 4, 2010

Thread Author Time
Partitioning improvements query John Lister 21:59

Feb. 5, 2010

Thread Author Time
Re: Howto have a unique restraint on UPPER (textfield) Yeb Havinga 20:57

Feb. 9, 2010

Thread Author Time
'image' table with relationships to different objects Louis-David Mitterrand 07:49
Re: 'image' table with relationships to different objects Michael Lourant 11:34
Re: 'image' table with relationships to different objects Richard Huxton 11:59
Re: 'image' table with relationships to different objects Rob Sargent 15:01
Re: 'image' table with relationships to different objects Louis-David Mitterrand 19:41

Feb. 10, 2010

Thread Author Time
plpgsql loop question Andrea Visinoni 16:29
Re: plpgsql loop question Justin Graf 17:16
Re: 'image' table with relationships to different objects Louis-David Mitterrand 17:29
Re: 'image' table with relationships to different objects Justin Graf 19:07
Re: plpgsql loop question Adrian Klaver 20:56

Feb. 11, 2010

Thread Author Time
Re: 'image' table with relationships to different objects Jasen Betts 11:05

Feb. 12, 2010

Thread Author Time
"left join" not working? Louis-David Mitterrand 11:14
Re: "left join" not working? Oliveiros C, 11:35
Re: "left join" not working? msi77 11:57
Re: "left join" not working? Louis-David Mitterrand 11:57
Re: "left join" not working? Oliveiros C, 12:17
complex join question Louis-David Mitterrand 22:32
Re: complex join question Tim Landscheidt 23:55

Feb. 13, 2010

Thread Author Time
Can i force deletion of dependent rows? Shruthi A 06:11
Re: Can i force deletion of dependent rows? Tim Landscheidt 07:05
Re: Can i force deletion of dependent rows? Wayne E. Seguin 11:23
Re: Can i force deletion of dependent rows? Shoaib Mir 11:32
Re: Can i force deletion of dependent rows? Shruthi A 17:25
Re: Can i force deletion of dependent rows? Tim Landscheidt 22:45

Feb. 15, 2010

Thread Author Time
Re: Can i force deletion of dependent rows? Rob Sargent 19:04

Feb. 16, 2010

Thread Author Time
UNION or LEFT JOIN? Louis-David Mitterrand 14:08
Re: UNION or LEFT JOIN? Oliveiros 15:33
Re: UNION or LEFT JOIN? Louis-David Mitterrand 21:02
Re: UNION or LEFT JOIN? Tim Landscheidt 21:38
Re: UNION or LEFT JOIN? Louis-David Mitterrand 21:43

Feb. 17, 2010

Thread Author Time
very frustrating feature-bug silly sad 07:20
Re: very frustrating feature-bug Jasen Betts 10:51
Re: very frustrating feature-bug silly sad 11:34
Re: very frustrating feature-bug Pavel Stehule 11:37
Referencing external table in update/insert triggers Amitabh Kant 15:18
Re: very frustrating feature-bug Tom Lane 15:27
Re: very frustrating feature-bug Achilleas Mantzios 15:33

Feb. 18, 2010

Thread Author Time
Re: Referencing external table in update/insert triggers Richard Huxton 09:23
Re: Referencing external table in update/insert triggers Amitabh Kant 09:33
Problem with batch insert zkn 12:53
Re: Problem with batch insert Tom Lane 15:32
Re: Problem with batch insert zkn 16:05

Feb. 19, 2010

Thread Author Time
sintax error iuri de araujo sampaio 07:52
Unable to get UPDATE ... FROM syntax correct Gordon Ross 09:25
Re: Unable to get UPDATE ... FROM syntax correct zkn 10:28
Re: Unable to get UPDATE ... FROM syntax correct Gordon Ross 10:32
Re: Unable to get UPDATE ... FROM syntax correct Richard Huxton 10:36
Re: sintax error Richard Huxton 10:56
Re: Unable to get UPDATE ... FROM syntax correct Gordon Ross 10:58
Re: Unable to get UPDATE ... FROM syntax correct Richard Huxton 11:33
Re: sintax error Tom Lane 14:28

Feb. 21, 2010

Thread Author Time
Join Advice and Assistance Gary Chambers 23:25

Feb. 22, 2010

Thread Author Time
Re: Join Advice and Assistance Rob Sargent 05:10
Re: Join Advice and Assistance Gary Chambers 15:51
Re: Join Advice and Assistance Rob Sargent 17:05
Re: Join Advice and Assistance Stephen Belcher 17:15
Re: Join Advice and Assistance Gary Chambers 22:43

Feb. 24, 2010

Thread Author Time
join with an array Louis-David Mitterrand 12:40
Re: join with an array A. Kretschmer 13:09
Re: join with an array Louis-David Mitterrand 13:34
Microsoft Sync Framework Ricardo S. Carvalho 13:42
Re: join with an array Achilleas Mantzios 14:39

Feb. 25, 2010

Thread Author Time
Using new.id in the WHERE condition of one UPDATE inside ON INSERT rule Aron 15:19
Re: Using new.id in the WHERE condition of one UPDATE inside ON INSERT rule Tom Lane 15:28

Feb. 26, 2010

Thread Author Time
what exactly is a query structure? silly sad 06:50
Re: what exactly is a query structure? A. Kretschmer 07:19
Re: what exactly is a query structure? silly sad 09:42
Re: what exactly is a query structure? silly sad 09:44
Re: what exactly is a query structure? A. Kretschmer 09:53
Re: what exactly is a query structure? Tom Lane 15:11

Feb. 27, 2010

Thread Author Time
Date comparison, user defined operators and magic Petru Ghita 03:08
Re: Date comparison, user defined operators and magic Tom Lane 03:32
Issue with insert Michael Gould 17:14
Re: Issue with insert Scott Marlowe 17:50
Re: Issue with insert Michael Gould 20:25
Re: Issue with insert Tom Lane 20:58
Re: Issue with insert Michael Gould 21:02

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 9 10 11 12 13 15 16 17 18 19 21 22 24 25 26 27