-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
> I am running a postgresql database and am finding that DBI is returning > the wrong data type for the postgresql DATE type. > ... > The problem lies with the birthdate column. In postgresql, the data > type is 'date'. When I run the above code it returns the DATA_TYPE as > 0, which is DBI::SQL_ALL_TYPES, not 9 which is DBI:SQL_DATE. > > So my questions are: > 1) Is this DBI's problem or Postgresql's problem? > 2) Why is it not returning DBI::SQL_DATE as the type for postgresql date > fields? Hard to day, as it "works for me". What version of DBI, DBD::Pg, and PostgreSQL are you using? Are you sure you are looking at the same table? (Your example uses both "_users" and "pp_users"). - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200505040726 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFCeLF8vJuQZxSWSsgRAmTFAKD9B+m1wdy9jB+WVJlGSmAm5mgTaQCggjNM wJpF8w9T2b6yk+8kNGK9DLE= =Fq+2 -----END PGP SIGNATURE-----
