Re: [Fwd: Re: [Pljava-dev] char with trailing space, PreparedStatement.setObject

[Thomas Hallgren <thomas(at)tada(dot)se>]

Tom Lane wrote:
> The real point here is that the JDBC driver is doing something to prompt
> the parser to resolve the types of parameter symbols in particular ways,
> and (I gather) you're doing something different.  If you want to match
> the results they get, then you need to supply the same type information
> for parameter symbols to SPI_prepare as they put into Parse messages.
>
>   
My mistake. I thought that given a statement like:

 SELECT p.name FROM people p WHERE p.zipcode = ?

the actual type returned by SPI_getargtype would be inferred by the 
expression 'p.zipcode'. I guess that's not the case. Instead I need to 
provide the information earlier, like:

 SELECT p.name FROM people p WHERE p.zipcode = ?::varchar

is that correct? If so, is there any way that I can automatically infer 
the best type?

Regards,
Thomas Hallgren