From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] date_part bug? |
Date: | 1998-12-18 09:48:07 |
Message-ID: | 199812180948.JAA11873@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(dot)Elphick(at)lfix(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Valerio Santinelli | 1998-12-18 15:11:09 | Slow Searches using MSAccess and ODBC to a PostGreSQL database |
Previous Message | Vadim Mikheev | 1998-12-18 09:41:40 | Re: [GENERAL] Why PostgreSQL is better than other commerial softwares? |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-12-18 15:00:13 | Re: [HACKERS] CURRENT: crash in select_view regression test... |
Previous Message | Oleg Broytmann | 1998-12-18 08:41:34 | Re: [GENERAL] date_part bug? |