Forum OpenACS Q&A: Re: Too stupid to work this out for myself!

Collapse
Posted by Robert Locke on
Hi Bruno,

You're right that integers do not *require* quotes.  However, you can db_quote a constant value of any type, and I think that is what is done with all bind variables.

Collapse
Posted by Dirk Gomez on
Why are bind variables always quoted?!
Collapse
Posted by Jeff Davis on
because in postgres they are not bind variables, they are
really just quoted and interpolated.  There isn't really any
way (short of writing a sql parser and looking at the backend)
to know what the actual datatype is.