pgsql-sql - April 2009

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 6 8 9 10 12 13 14 15 16 17 20 21 23 24 25 27 28 29 30

April 1, 2009

Thread Author Time
Re: Add: Special sort querstion Dirk Jagdmann 14:57
Re: Add: Special sort querstion Dirk Jagdmann 14:57
Re: Add: Special sort querstion Scott Marlowe 15:08
Stored function not accepting null value? Deirdre Hall 18:17
Re: Stored function not accepting null value? Tom Lane 19:01
Re: Stored function not accepting null value? Deirdre Hall 19:20
FUNCTION problem Peter Willis 23:31
Re: FUNCTION problem Adrian Klaver 23:55

April 2, 2009

Thread Author Time
Text cast problem Volkmar Herbst 09:51
Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps James Kitambara 12:31
Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps Alvaro Herrera 13:54
ibatis with overlaps query Emi Lu 14:01
Performance problem with row count trigger Tony Cebzanov 14:22
Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps Tom Lane 15:00
Re: ibatis with overlaps query Tom Lane 15:09
Re: FUNCTION problem Peter Willis 16:09
Re: Performance problem with row count trigger Craig Ringer 16:44
Re: Performance problem with row count trigger Tony Cebzanov 17:40
Re: Performance problem with row count trigger Tom Lane 19:32
Re: Performance problem with row count trigger 📎 Wei Weng 20:17
Re: Performance problem with row count trigger Greg Sabino Mullane 20:56
How would I get rid of trailing blank line? Tena Sakai 21:33
Re: FUNCTION problem Adrian Klaver 22:20
Re: How would I get rid of trailing blank line? Tom Lane 23:01
Re: FUNCTION problem Peter Willis 23:22

April 3, 2009

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

April 4, 2009

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

April 6, 2009

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

April 8, 2009

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

April 9, 2009

Thread Author Time
Re: join help 📎 Justin 01:38
Re: join help Kashmir 03:28
Re: Nested selects Steve Midgley 15:13

April 10, 2009

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

April 12, 2009

Thread Author Time
ERROR: operator does not exist: date ~~ unknown Rohit Suman 05:58
Re: ERROR: operator does not exist: date ~~ unknown Pavel Stehule 07:36
Fw: ERROR: operator does not exist: date ~~ unknown Rohit Suman 09:50
Re: Fw: ERROR: operator does not exist: date ~~ unknown Tom Lane 15:16
Re: ENUM vs DOMAIN vs FKyed loookup table Dirk Jagdmann 18:08

April 13, 2009

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

April 14, 2009

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

April 15, 2009

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

April 16, 2009

Thread Author Time
Re: How to count from a second table in an aggregate query? Erik Jones 00:02
Re: How to count from a second table in an aggregate query? Steve Midgley 04:23
Re: Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps Andreas Joseph Krogh 10:21
Ordering a name list and ignoring whitespace Mikel Lindsaar 10:51
Re: Ordering a name list and ignoring whitespace Mario Splivalo 11:02
Need a script that bakes INSERT script from SELECT results ShuA 11:29
Re: Need a script that bakes INSERT script from SELECT results John DeSoi 12:25
Re[2]: Need a script that bakes INSERT script from SELECT results ShuA 13:24
Re: Ordering a name list and ignoring whitespace Tom Lane 14:13
how to set the value to the column DM 19:00
Re: 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: finding UNIQUES in information_schema Tom Lane 19:12
finding UNIQUES in information_schema Gerardo Herzig 19:33
Re: finding UNIQUES in information_schema Tom Lane 20:09
Re: finding UNIQUES in information_schema Gerardo Herzig 20:44

April 17, 2009

Thread Author Time
Problemas com Procedure no PostgreSQL Paulo (O2 Tecnologia) 11:38
Re: Problemas com Procedure no PostgreSQL Hélder M. Vieira 12:27
Re: Problemas com Procedure no PostgreSQL Hélder M. Vieira 13:53
Re: Problemas com Procedure no PostgreSQL Paulo (O2 Tecnologia) 15:08
Re: Problemas com Procedure no PostgreSQL Paulo (O2 Tecnologia) 15:13
Re: How to count from a second table in an aggregate query? Steve Midgley 18:36

April 20, 2009

Thread Author Time
Frequently unable connecting to db "server doesn't listen" Net Tree Inc. 02:10
Re: Frequently unable connecting to db "server doesn't listen" Scott Marlowe 03:20
Re: Re: [GENERAL] Frequently unable connecting to db "server doesn't listen" Rohit Suman 06:31
Re: Frequently unable connecting to db "server doesn't listen" Alban Hertroys 08:53

April 21, 2009

Thread Author Time
trigger before delete question Sigrid Thijs 12:03
Re: trigger before delete question Tom Lane 14:13

April 23, 2009

Thread Author Time
Re[3]: Need a script that bakes INSERT script from SELECT results ShuA 08:34
[No subject] Adam Ruth 22:51

April 24, 2009

Thread Author Time
varchar value comparisons not working? Shawn Tayler 13:59
Re: varchar value comparisons not working? Tom Lane 14:32

April 25, 2009

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

April 27, 2009

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

April 28, 2009

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

April 29, 2009

Thread Author Time
Comparing two tables of different database Nicholas I 06:39
Re: Comparing two tables of different database Pavel Stehule 12:15
Re: Comparing two tables of different database Pawel Socha 12:33
Re: Comparing two tables of different database Osvaldo Kussama 12:48
Re: Comparing two tables of different database Thomas Kellerer 13:12
freeing memory after fetch all Chris Bovitz 22:18
Re: Comparing two tables of different database Adam Ruth 22:20

April 30, 2009

Thread Author Time
Re: Comparing two tables of different database Joshua Tolley 03:37
Re: Comparing two tables of different database Nicholas I 10:12
Re: Comparing two tables of different database Jasen Betts 12:05
Re: Comparing two tables of different database Jasen Betts 12:08
Re: Comparing two tables of different database Edward W. Rouse 22:07

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 8 9 10 12 13 14 15 16 17 20 21 23 24 25 27 28 29 30