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

Collapse
5: Re: Too stupid to work this out for myself! (response to 3)
Posted by Bruno Mattarollo on 03/06/03 11:02 AM 
 > where p.product_id = '5963'

Excuse my ignorance, but isn't product_id supposed to be an integer? Maybe the problem is there?

Collapse
6: Re: Too stupid to work this out for myself! (response to 5)
Posted by Robert Locke on 03/06/03 11:11 AM
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
8: Re: Too stupid to work this out for myself! (response to 6)
Posted by Dirk Gomez on 03/11/03 08:48 AM
Why are bind variables always quoted?!
Collapse
9: Re: Too stupid to work this out for myself! (response to 8)
Posted by Jeff Davis on 03/11/03 09:15 AM
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.