On Sat, Mar 6, 2010 at 9:40 AM, Marijn Haverbeke marijnh@gmail.com wrote:
Hi Daniel,
Thanks for the code. However, :coerce is already there, named :type, and the way to-sql-string is currently used, it should A) not use S-SQL functions, since cl-postgres does not depend on S-SQL, and B) serialise to a format that can also be used to pass parameters to prepared queries. I'm not that knowledgeable about Postgres' textual formats, but it appears that a value like ARRAY[1, 2, 3] can not be written as a parameter:
Database error 22P02: array value must start with "{" or dimension information
Pardon a vague response, but in my crack t postgres recently I do remember a minor aggravation with the two ways of saying "array". Probably just need to sort out which syntax to use when.
kt