pgsql-sql since 2009-12-09 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

Dec. 9, 2009

Thread Author Time
constants in 2-column foreign keys or how to design a storage for text-groups ? Andreas 00:20
Re: Stalled post to pgsql-sql sergey kapustin 10:30
Re: Stalled post to pgsql-sql Pavel Stehule 10:33
SQL state 58P01 triggered by a database script execution aymen marouani 13:10
Re: SQL state 58P01 triggered by a database script execution A. Kretschmer 13:24
Re: SQL state 58P01 triggered by a database script execution aymen marouani 13:33
Re: SQL state 58P01 triggered by a database script execution A. Kretschmer 13:46

Dec. 10, 2009

Thread Author Time
Window function trouble Harald Fuchs 17:00
Re: Window function trouble Harald Fuchs 17:49
Re: Window function trouble Tom Lane 18:09
Re: Window function trouble Harald Fuchs 21:02
Re: Window function trouble Tom Lane 23:08

Dec. 11, 2009

Thread Author Time
FIND_IN_SET Michael Eshom 06:22
Re: constants in 2-column foreign keys or how to design a storage for text-groups ? Jasen Betts 08:39
Re: FIND_IN_SET Pavel Stehule 08:48
Re: Re: constants in 2-column foreign keys or how to design a storage for text-groups ? Andreas 10:20
Re: Window function trouble Harald Fuchs 15:40
Is there any function to test for numeric ips? Oliveiros C, 16:05
Re: Is there any function to test for numeric ips? Fernando Hevia 16:20
Re: Is there any function to test for numeric ips? Harald Fuchs 16:23
Re: Is there any function to test for numeric ips? Fernando Hevia 16:26
Re: Is there any function to test for numeric ips? Alvaro Herrera 16:28
Re: Is there any function to test for numeric ips? Oliveiros C, 17:40

Dec. 16, 2009

Thread Author Time
8.3/8.4 SQL incompatibility? Britt Piehler 17:31
Re: 8.3/8.4 SQL incompatibility? Tom Lane 20:23

Dec. 17, 2009

Thread Author Time
get distinct + group by then filter Ivan Sergio Borgonovo 15:28

Dec. 18, 2009

Thread Author Time
Re: get distinct + group by then filter Filip Rembiałkowski 12:20
Re: get distinct + group by then filter Ivan Sergio Borgonovo 13:44

Dec. 21, 2009

Thread Author Time
8.4.1 distinct query WITHOUT order by Gary Chambers 22:15
Re: 8.4.1 distinct query WITHOUT order by Thomas Kellerer 22:38
Re: 8.4.1 distinct query WITHOUT order by Scott Marlowe 22:53

Dec. 22, 2009

Thread Author Time
Re: 8.4.1 distinct query WITHOUT order by Gary Chambers 03:45
Re: 8.4.1 distinct query WITHOUT order by Scott Marlowe 05:18
Re: 8.4.1 distinct query WITHOUT order by Scott Marlowe 05:23
Re: 8.4.1 distinct query WITHOUT order by msi77 07:11
Re: 8.4.1 distinct query WITHOUT order by Scott Marlowe 09:22
short-cutting if sum()>constant Ivan Sergio Borgonovo 12:35
Re: short-cutting if sum()>constant Filip Rembiałkowski 13:48
Re: short-cutting if sum()>constant Adam Tauno Williams 14:02
Re: short-cutting if sum()>constant A. Kretschmer 14:12
Re: short-cutting if sum()>constant msi77 15:11
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 17:20
Re: short-cutting if sum()>constant Andreas Kretschmer 17:30
Re: short-cutting if sum()>constant msi77 19:15
Re: short-cutting if sum()>constant Pavel Stehule 19:47
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 23:00

Dec. 23, 2009

Thread Author Time
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 00:09
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 01:46
Re: short-cutting if sum()>constant Pavel Stehule 07:38
Using || operator to fold multiple columns into one Bryce Nesbitt 08:34
Re: Using || operator to fold multiple columns into one Craig Ringer 08:44
Re: Using || operator to fold multiple columns into one A. Kretschmer 08:50
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 10:56
Re: short-cutting if sum()>constant Pavel Stehule 11:52
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 13:01
Re: short-cutting if sum()>constant Pavel Stehule 13:35
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 14:27
Re: short-cutting if sum()>constant Craig Ringer 16:02
Re: short-cutting if sum()>constant Pavel Stehule 16:04
Re: short-cutting if sum()>constant Tom Lane 16:36
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 17:43
Re: short-cutting if sum()>constant Pavel Stehule 18:53
Re: Using || operator to fold multiple columns into one Rosser Schwarz 21:04

Dec. 24, 2009

Thread Author Time
Re: Using || operator to fold multiple columns into one Craig Ringer 03:08

Dec. 28, 2009

Thread Author Time
Invitation to connect on LinkedIn Mina Waheeb 16:57

Dec. 29, 2009

Thread Author Time
Foreign key - Indexing & Deadlocking. Andrew Hall 22:59
Re: Using || operator to fold multiple columns into one Bryce Nesbitt 23:44

Dec. 30, 2009

Thread Author Time
Re: Foreign key - Indexing & Deadlocking. Craig Ringer 01:18
DataBase Problem Premila Devi 01:49
Re: DataBase Problem Craig Ringer 01:54
Re: DataBase Problem Joshua Tolley 11:42
Re: PSQL statement to delete 100 rows meeting certain criteria Chris Browne 21:20

Dec. 31, 2009

Thread Author Time
loading a file into a field Brian Sherwood 16:23
Re: Using || operator to fold multiple columns into one Rosser Schwarz 16:23
Proper case function Michael Gould 17:36
Re: Proper case function Gary Chambers 17:40
Re: loading a file into a field Tim Landscheidt 18:15
Re: Proper case function Michael Gould 18:17
Re: Proper case function Tim Landscheidt 19:27
Re: Proper case function Seth Gordon 19:30

Jan. 1, 2010

Thread Author Time
Re: Proper case function Jasen Betts 10:39

Jan. 6, 2010

Thread Author Time
getting extract to always return number of hours Chris 01:33
Re: getting extract to always return number of hours Rosser Schwarz 01:50
Re: getting extract to always return number of hours Chris 02:48
Re: Proper case function John Summerfield 15:42
Fwd: conditional rule not applied Seb 20:40
Re: Fwd: conditional rule not applied Richard Broersma 21:01
Re: Fwd: conditional rule not applied Seb 21:31

Jan. 7, 2010

Thread Author Time
Re: Fwd: conditional rule not applied Leo Mannhart 15:31

Jan. 8, 2010

Thread Author Time
Re: Fwd: conditional rule not applied Seb 03:43

Jan. 9, 2010

Thread Author Time
how to do this query Wes James 04:26
Re: how to do this query Ian Barwick 09:07
Re: how to do this query msi77 11:36
Re: how to do this query msi77 22:52

Jan. 11, 2010

Thread Author Time
problem using regexp_replace gherzig 00:29
Re: problem using regexp_replace Jasen Betts 08:28
Re: problem using regexp_replace gherzig 10:33
CHECK constraint removing brackets Andy Shellam 19:49
Re: CHECK constraint removing brackets Scott Marlowe 20:14
Re: CHECK constraint removing brackets Tom Lane 20:15
Re: CHECK constraint removing brackets Andy Shellam 23:27

Jan. 12, 2010

Thread Author Time
Re: CHECK constraint removing brackets Tom Lane 00:10
Re: problem using regexp_replace Jasen Betts 12:10
Re: problem using regexp_replace gherzig 16:17

Jan. 15, 2010

Thread Author Time
rename primary key Seb 03:28
Re: rename primary key Ian Barwick 03:34
Re: rename primary key Seb 03:39
Re: rename primary key Guillaume Lelarge 06:35
indexes Seb 16:04
Re: rename primary key Seb 16:13

Jan. 17, 2010

Thread Author Time
Re: indexes Chris 21:59

Jan. 18, 2010

Thread Author Time
Re: indexes Seb 01:10
Re: indexes Craig Ringer 01:22

Jan. 19, 2010

Thread Author Time
How to cascade information like the user roles ? Andreas 00:33
Re: How to cascade information like the user roles ? Filip Rembiałkowski 14:27
Re: How to cascade information like the user roles ? Andreas 16:47

Jan. 20, 2010

Thread Author Time
Re: How to cascade information like the user roles ? 📎 Gurjeet Singh 05:45
Re: How to cascade information like the user roles ? Gurjeet Singh 06:23
Re: How to cascade information like the user roles ? Andreas 16:43

Jan. 21, 2010

Thread Author Time
Error while vacuumdb Otniel Michael 05:05

Jan. 22, 2010

Thread Author Time
Re: How to cascade information like the user roles ? Gurjeet Singh 12:25

Jan. 23, 2010

Thread Author Time
clock command regression in pltcl? Kyle Bateman 04:41
Re: clock command regression in pltcl? Tom Lane 06:26
Re: clock command regression in pltcl? Tom Lane 06:50

Jan. 25, 2010

Thread Author Time
Re: clock command regression in pltcl? Tom Lane 02:17

Jan. 27, 2010

Thread Author Time
Re: rename primary key Guillaume Lelarge 14:19

Jan. 29, 2010

Thread Author Time
Partitioning by letter question John Lister 22:24
Re: Partitioning by letter question Scott Marlowe 23:50

Jan. 30, 2010

Thread Author Time
Re: Partitioning by letter question John Lister 15:04
Re: Partitioning by letter question Scott Marlowe 16:32

Jan. 31, 2010

Thread Author Time
Howto have a unique restraint on UPPER (textfield) Andreas 02:26
Re: Howto have a unique restraint on UPPER (textfield) Joshua Tolley 02:56
Re: Howto have a unique restraint on UPPER (textfield) msi77 08:02
Re: Howto have a unique restraint on UPPER (textfield) Andreas 20:48
Re: Howto have a unique restraint on UPPER (textfield) Tom Lane 21:07

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

Browse Archives

Prev | Next