Postgres Pro
Downloads
Home   >   mailing lists

Problem with perl / postgres - Mailing list pgsql-general

From Chris Bitmead
Subject Problem with perl / postgres
Date
Msg-id 3768ABAD.F85AAD0F@bigfoot.com
Whole thread Raw
In response to Two questions about 6.5  (Christian Ullrich <ChrUllrich@gmx.de>)
Responses Re: [GENERAL] Problem with perl / postgres  (Stuart Rison <stuart@ludwig.ucl.ac.uk>)
List pgsql-general
Tree view 
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:chris@tech.com.au
http://www.techphoto.org - Photography News, Stuff that Matters

pgsql-general by date:

Previous
From: Christian Ullrich
Date:
Subject: Two questions about 6.5
Next
From: Michael
Date:
Subject: Re: [GENERAL] PL/pgsql problem in 6.5