[GENERAL] Problem with perl / postgres

[Anonymous]

I've got this simple query...

SELECT id, title, summary, datetime, datetime::date AS date FROM poll
WHERE id = ?

which works from psql but fails with "bad parameter" from perl. If I
take out the "datetime::date AS date" bit it starts working.

Why would a query work in psql but not perl?

-- 
Chris Bitmead
mailto:[EMAIL PROTECTED]
http://www.techphoto.org - Photography News, Stuff that Matters