Oleg Broytmann wrote:
>> create table tmp (v1 date, v2 datetime);
>> insert into tmp values ('06-01-1999', '06-01-1999');
>> select date_part('month', v1) as m1, date_part('month', v2) as m2 from
>> tmp;
>>
>> I see the following results:
>>
>> m1|m2
>> --+--
>> 5| 6
>> (1 row)
...
> I tried this and it works pretty good for me on Solaris.
> It looks like an error in postgres on glibc2-based linux platform. It is
>discussing now on pgsql-hackers list. The solution is not ready yet. I am
>working on this with a good deal of help from other people...
Not all glibc2: I run glibc2 Debian Linux and do not see this problem.
I was wondering if it was libc5 that was giving trouble...
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"In the beginning was the Word, and the Word was with
God, and the Word was God. The same was in the
beginning with God. All things were made by him; and
without him was not any thing made that was made."
John 1:1-3