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/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
