pgsql-sql - October 2012

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

Oct. 2, 2012

Thread	Author	Time
[noob] How to optimize this double pivot query?	Robert Buck	00:47
Re: [noob] How to optimize this double pivot query?	David Johnston	01:07
Re: [noob] How to optimize this double pivot query?	Robert Buck	01:13
Re: [noob] How to optimize this double pivot query?	David Johnston	01:28
Re: [noob] How to optimize this double pivot query?	Thomas Kellerer	06:46
Re: [noob] How to optimize this double pivot query?	Samuel Gendler	09:21
Re: [noob] How to optimize this double pivot query?	Robert Buck	09:45
Re: Help in accessing array	David Johnston	13:53
Re: [noob] How to optimize this double pivot query?	Samuel Gendler	19:57
Re: [noob] How to optimize this double pivot query?	Samuel Gendler	20:09

Oct. 3, 2012

Thread	Author	Time
Re: [noob] How to optimize this double pivot query?	Robert Buck	16:23
Re: [noob] How to optimize this double pivot query?	Robert Buck	16:31
Re: [noob] How to optimize this double pivot query?	Samuel Gendler	20:05

Oct. 4, 2012

Thread	Author	Time
Calling the CTE for multiple inputs	air	19:31
String Search	Fabio Ebner - Dna Solution	19:40
Re: Calling the CTE for multiple inputs	David Johnston	19:51
Re: String Search	David Johnston	19:57

Oct. 5, 2012

Thread	Author	Time
Re: Calling the CTE for multiple inputs	Craig Ringer	03:34
checking the gaps in intervals	Anton Gavazuk	22:42

Oct. 6, 2012

Thread	Author	Time
Re: checking the gaps in intervals	Andreas Kretschmer	07:44
Re: checking the gaps in intervals	Andreas Kretschmer	07:55
Re: checking the gaps in intervals	Gavin Flower	08:04
How to make this CTE also print rows with 0 as count?	air	12:47
Re: Calling the CTE for multiple inputs	air	12:56
Re: How to make this CTE also print rows with 0 as count?	David Johnston	17:30
Re: checking the gaps in intervals	Gavin Flower	21:58

Oct. 7, 2012

Thread	Author	Time
Re: Calling the CTE for multiple inputs	Jasen Betts	01:02
Re: checking the gaps in intervals	Jasen Betts	01:30

Oct. 8, 2012

Thread	Author	Time
Error 42704	Kim Bisgaard	15:38

Oct. 11, 2012

Thread	Author	Time
Database object names and libpq in UTF-8 locale on Windows	Sebastien FLAESCH	08:56
Re: Database object names and libpq in UTF-8 locale on Windows	Tom Lane	14:03
Re: Database object names and libpq in UTF-8 locale on Windows	Sebastien FLAESCH	14:13
Re: checking the gaps in intervals	Gavin Flower	20:25

Oct. 14, 2012

Thread	Author	Time
rolling statistic probaply a window function?	Andreas	17:43

Oct. 19, 2012

Thread	Author	Time
Recursive temporal query	Liam Caffrey	15:40
Re: Recursive temporal query	Liam Caffrey	15:41
Re: Recursive temporal query	Liam Caffrey	15:46
Trigger triggered from a foreign key	Victor Sterpu	18:14
Re: Trigger triggered from a foreign key	David Johnston	18:24
Insert strings that contain colons into a table	lmagnell	20:24
Re: Insert strings that contain colons into a table	David Johnston	20:34
Re: Insert strings that contain colons into a table	lmagnell	20:49

Oct. 21, 2012

Thread	Author	Time
Partition database between users and implement disk quotas	Brice André	19:18

Oct. 22, 2012

Thread	Author	Time
Re: Trigger triggered from a foreign key	Jasen Betts	11:29

Oct. 26, 2012

Thread	Author	Time
pull in most recent record in a view	Gary Stainburn	09:02
Re: pull in most recent record in a view	Gary Stainburn	09:24

Oct. 28, 2012

Thread	Author	Time
complex query 📎	Mark Fenbers	00:01
Re: complex query	Scott Marlowe	00:24
Re: complex query 📎	Mark Fenbers	01:56
Re: complex query	Scott Marlowe	02:20
Re: complex query	Oliveiros d'Azevedo Cristina	11:15
Re: pull in most recent record in a view	David Johnston	14:54

Oct. 29, 2012

Thread	Author	Time
Fun with Dates 📎	Mark Fenbers	22:38
Re: Fun with Dates	Thomas Kellerer	22:44
Re: Fun with Dates 📎	Mark Fenbers	22:51

Oct. 30, 2012

Thread	Author	Time
replace text occurrences loaded from table	jan zimmek	11:45
Re: replace text occurrences loaded from table	David Johnston	15:08
Fwd: replace text occurrences loaded from table	jan zimmek	15:15

Browse Archives

Prev | Next