Collin
Greg Sabino Mullane wrote:
-----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-----
