[BUGS] Re: to_char miscalculation on April Fool's Day - the start of daylight savings

2001-04-06 Thread Thomas Lockhart
> It's April 3 and I'm developing an update routine to maintain expired > records, some of which expired on April 1. When these records didn't get > updated, I investigated and identified the alleged bug (which is > potentially devastating based on date intensive calculations in financial > appli

Re: [BUGS] Re: to_char miscalculation on April Fool's Day - the start of daylight savings

2001-04-06 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > Have you tried to use "date 'today'" rather than "now()"? As in > select to_char(date 'today' - 1, '-MM-DD'); That will still fail in 7.0.* when the selected date is a DST transition day, because of the bug in date-to-timestamp conversion (which

Re: [BUGS] Re: to_char miscalculation on April Fool's Day - the start of daylight savings

2001-04-06 Thread Thomas Lockhart
> > Have you tried to use "date 'today'" rather than "now()"? As in > > select to_char(date 'today' - 1, '-MM-DD'); > That will still fail in 7.0.* when the selected date is a DST transition > day, because of the bug in date-to-timestamp conversion (which will > happen at the input to to_cha

[BUGS] inet function return untestable texts

2001-04-06 Thread pgsql-bugs
Laurent Wacrenier ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description inet function return untestable texts Long Description I'm running 7.0.3 on FreeBSD host, netmask, etc.. inet function return unusable strings : for example, ho

Re: [BUGS] inet function return untestable texts

2001-04-06 Thread Tom Lane
[EMAIL PROTECTED] writes: > host, netmask, etc.. inet function return unusable strings : > for example, host('10.0.0.1') print '10.0.0.1' but > is you make a comparison with '=', the result is alway false. This is fixed in 7.1. Someone forgot that text values shouldn't have trailing nulls ...

Re: [BUGS] PostgreSQL 7.0.2 Date Miscalculation

2001-04-06 Thread Justin Clift
Hi Jay, Which OS are you using? Mandrake-Linux 7.2 is known to have bugs in the version of PostgreSQL they supply as RPM's. Regards and best wishes, Justin Clift [EMAIL PROTECTED] wrote: > > Jay Guerette ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more s