Merlin Moncure wrote:
> Well, yes :) Just to be absolutely clear what I mean, the following
> will fail (pseudocode, but you get the idea):
>
> char stmt[] = "prepare X as select 0()";
> PQexec(c, "execute X"); <-- works
> PQexecPrepared(c, "X" [...]); <-- fails
>
> You are saying this is the correct and expected behavior?
Yes, because part of those syntax rules is that in SQL, unquoted
identifiers are folded to lower case, but in C they are not.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/