Home > mailing lists

Mailing lists [pgsql-sql]

1 April 2009

14:57 Re: Add: Special sort querstion Dirk Jagdmann
14:58 Re: Add: Special sort querstion Dirk Jagdmann
15:08 Re: Add: Special sort querstion Scott Marlowe
18:27 Stored function not accepting null value? Deirdre Hall
19:02 Re: Stored function not accepting null value? Tom Lane
19:21 Re: Stored function not accepting null value? Deirdre Hall
23:32 FUNCTION problem Peter Willis
23:56 Re: FUNCTION problem Adrian Klaver

2 April 2009

12:37 Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps James Kitambara
13:56 Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps Alvaro Herrera
14:02 ibatis with overlaps query Emi Lu
14:22 Performance problem with row count trigger Tony Cebzanov
15:00 Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps Tom Lane
15:10 Re: ibatis with overlaps query Tom Lane
16:10 Re: FUNCTION problem Peter Willis
16:44 Re: Performance problem with row count trigger Craig Ringer
17:41 Re: Performance problem with row count trigger Tony Cebzanov
19:32 Re: Performance problem with row count trigger Tom Lane
20:47 Re: Performance problem with row count trigger Wei Weng
20:56 Re: Performance problem with row count trigger Greg Sabino Mullane
21:33 How would I get rid of trailing blank line? Tena Sakai
22:20 Re: FUNCTION problem Adrian Klaver
23:02 Re: How would I get rid of trailing blank line? Tom Lane
23:22 Re: FUNCTION problem Peter Willis

3 April 2009

01:16 Re: FUNCTION problem Adrian Klaver
01:25 Re: How would I get rid of trailing blank line? Tena Sakai
02:53 Re: How would I get rid of trailing blank line? Scott Marlowe
05:56 Re: [HACKERS] How would I get rid of trailing blank line? Tena Sakai
13:14 Text cast problem Volkmar Herbst
13:29 Re: Text cast problem Adrian Klaver
13:51 Re: FUNCTION problem Adrian Klaver
14:12 Re: FUNCTION problem Adrian Klaver
15:29 Re: FUNCTION problem Peter Willis
16:59 Re: FUNCTION problem Adrian Klaver
18:22 Re: Performance problem with row count trigger Tony Cebzanov
19:10 Re: FUNCTION problem Peter Willis
21:03 pl/pgsql or control structures outside of a function? Peter Koczan

4 April 2009

04:28 Re: pl/pgsql or control structures outside of a function? John DeSoi

6 April 2009

02:22 Re: How would I get rid of trailing blank line? Greg Sabino Mullane
14:29 Re: Performance problem with row count trigger Greg Sabino Mullane
16:42 Re: pl/pgsql or control structures outside of a function? Peter Koczan

8 April 2009

02:34 Nested selects Glenn Maynard
03:08 changing multiple pk's in one update Stuart McGraw
17:09 ENUM vs DOMAIN vs FKyed loookup table Mario Splivalo
19:42 Re: ENUM vs DOMAIN vs FKyed loookup table Peter Eisentraut
20:17 join help Kashmir

9 April 2009

01:38 Re: join help Justin
03:28 Re: join help Kashmir
15:14 Re: Nested selects Steve Midgley

10 April 2009

14:40 Re: changing multiple pk's in one update Jasen Betts
15:09 Re: How would I get rid of trailing blank line? Jasen Betts
18:20 Re: changing multiple pk's in one update Scott Marlowe
22:47 Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps Jasen Betts

12 April 2009

06:06 ERROR: operator does not exist: date ~~ unknown Rohit Suman
08:53 Re: ERROR: operator does not exist: date ~~ unknown Pavel Stehule
09:50 Fw: ERROR: operator does not exist: date ~~ unknown Rohit Suman
15:16 Re: Fw: ERROR: operator does not exist: date ~~ unknown Tom Lane
18:08 Re: ENUM vs DOMAIN vs FKyed loookup table Dirk Jagdmann

13 April 2009

16:53 Re: changing multiple pk's in one update Stuart McGraw
17:02 Re: changing multiple pk's in one update Richard Broersma
17:20 Re: changing multiple pk's in one update Stuart McGraw
21:09 Re: changing multiple pk's in one update Glenn Maynard
21:18 Re: changing multiple pk's in one update Richard Broersma
21:34 Re: changing multiple pk's in one update Glenn Maynard
21:43 Re: changing multiple pk's in one update Richard Broersma
22:01 Re: changing multiple pk's in one update Glenn Maynard

14 April 2009

02:27 Re: changing multiple pk's in one update Stuart McGraw
07:08 Postgres entering zombie state once a week in production evnvironment Bryce Nesbitt
07:29 Re: Postgres entering zombie state once a week in production evnvironment Achilleas Mantzios
07:59 Re: Postgres entering zombie state once a week in production evnvironment Scott Marlowe
13:43 Re: ENUM vs DOMAIN vs FKyed loookup table Mario Splivalo
20:20 Re: Postgres entering zombie state once a week in production evnvironment Bryce Nesbitt
20:21 Re: changing multiple pk's in one update Steve Midgley
20:58 Re: Postgres entering zombie state once a week in production evnvironment Bryce Nesbitt
21:05 Re: Postgres entering zombie state once a week in production evnvironment Scott Marlowe

15 April 2009

03:47 Postgres process resident size does not drop after killing statement Bryce Nesbitt
12:49 Re: changing multiple pk's in one update Jasen Betts
12:57 Re: ENUM vs DOMAIN vs FKyed loookup table Jasen Betts
13:58 Re: Postgres process resident size does not drop after killing statement Tom Lane
17:31 Re: ENUM vs DOMAIN vs FKyed loookup table Chris Browne
20:15 How to count from a second table in an aggregate query? Steve Midgley
20:26 Re: changing multiple pk's in one update Glenn Maynard

16 April 2009

00:03 Re: How to count from a second table in an aggregate query? Erik Jones
04:23 Re: How to count from a second table in an aggregate query? Steve Midgley
10:45 Re: Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps Andreas Joseph Krogh
10:51 Ordering a name list and ignoring whitespace Mikel Lindsaar
11:02 Re: Ordering a name list and ignoring whitespace Mario Splivalo
11:54 Need a script that bakes INSERT script from SELECT results ShuA
12:48 Re: Need a script that bakes INSERT script from SELECT results John DeSoi
14:03 Re[2]: Need a script that bakes INSERT script from SELECT results ShuA
14:13 Re: Ordering a name list and ignoring whitespace Tom Lane
18:50 finding UNIQUES in information_schema Gerardo Herzig
19:01 how to set the value to the column DM
19:11 Re: how to set the value to the column Andreas Kretschmer
19:11 Re: how to set the value to the column DM
19:12 Re: finding UNIQUES in information_schema Tom Lane
20:01 Re: finding UNIQUES in information_schema Gerardo Herzig
20:10 Re: finding UNIQUES in information_schema Tom Lane

17 April 2009

11:51 Problemas com Procedure no PostgreSQL Paulo (O2 Tecnologia)
12:34 Re: Problemas com Procedure no PostgreSQL Hélder M. Vieira
13:53 Re: Problemas com Procedure no PostgreSQL Hélder M. Vieira
15:05 Re: Problemas com Procedure no PostgreSQL Paulo (O2 Tecnologia)
15:10 Re: Problemas com Procedure no PostgreSQL Paulo (O2 Tecnologia)
18:36 Re: How to count from a second table in an aggregate query? Steve Midgley

20 April 2009

03:20 Re: [GENERAL] Frequently unable connecting to db "server doesn't listen" Scott Marlowe
11:03 Re: Re: [GENERAL] Frequently unable connecting to db "server doesn't listen" Rohit Suman

21 April 2009

12:04 trigger before delete question Sigrid Thijs
14:13 Re: trigger before delete question Tom Lane

23 April 2009

10:34 Re[3]: Need a script that bakes INSERT script from SELECT results ShuA
23:01 Adam Ruth

24 April 2009

14:16 varchar value comparisons not working? Shawn Tayler
14:32 Re: varchar value comparisons not working? Tom Lane

25 April 2009

02:47 Variable number or arguments to a function possible? Chris Ruprecht
03:08 Re: Variable number or arguments to a function possible? Milen A. Radev
03:09 Re: Variable number or arguments to a function possible? Tom Lane
11:06 Multiple return values and assignment Leif B. Kristensen

27 April 2009

00:21 Query with Parameters and Wildcards landsharkdaddy
02:12 Re: Query with Parameters and Wildcards Ries van Twisk
04:54 Re: Query with Parameters and Wildcards Scott Marlowe
05:01 Re: Query with Parameters and Wildcards landsharkdaddy
08:49 Re: Multiple return values and assignment Jasen Betts
08:54 Re: varchar value comparisons not working? Jasen Betts
11:41 Re: Query with Parameters and Wildcards Mario Splivalo
14:19 Re: Query with Parameters and Wildcards landsharkdaddy
14:48 Re: Query with Parameters and Wildcards dayat
16:36 Re: Query with Parameters and Wildcards Jure Kobal
17:11 Re: Query with Parameters and Wildcards landsharkdaddy
19:12 Re: Query with Parameters and Wildcards Jure Kobal
19:15 Storing null bytes in bytea Andy Shellam
19:37 Re: Multiple return values and assignment Leif B. Kristensen
20:29 Re: Storing null bytes in bytea Tom Lane

28 April 2009

15:43 pg_stat_activity return all connections Emi Lu
16:51 Re: Storing null bytes in bytea Andy Shellam
20:35 Re: pg_stat_activity return all connections Erik Jones

29 April 2009

12:10 Comparing two tables of different database Nicholas I
12:54 Re: Comparing two tables of different database Pawel Socha
14:19 Re: Comparing two tables of different database Thomas Kellerer
21:26 Re: Comparing two tables of different database Pavel Stehule

30 April 2009

02:21 Re: Comparing two tables of different database Adam Ruth
20:57 Re: Comparing two tables of different database Jasen Betts
21:11 Re: Comparing two tables of different database Nicholas I
21:45 Re: Comparing two tables of different database Osvaldo Kussama
21:59 Re: Comparing two tables of different database Joshua Tolley
22:30 Re: Comparing two tables of different database Edward W. Rouse