> 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
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
> > 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
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
[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 ...
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