Re: [GENERAL] date_part bug?

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