I noticed a curious thing (not sure if by design or not).

While using the PQExecPrepared interface, the statement name passed to
the function (as a const char*) has to be in lower case to get it to
work.  I kind of understand why this is, but it is kind of weird that
passing the exact same statement name to PQExecPrepared and PREPARE does
not work if it contains any upper case characters.

Just FYI.
Merlin


Fri, 16 Jul 2004 15:56:32 -0400
"Merlin Moncure" <merlin.moncure@rcsonline.com>
case sensitivity in PQExecPrepared
Merlin Moncure wrote:
> While using the PQExecPrepared interface, the statement name passed
> to the function (as a const char*) has to be in lower case to get it
> to work.  I kind of understand why this is, but it is kind of weird
> that passing the exact same statement name to PQExecPrepared and
> PREPARE does not work if it contains any upper case characters.

PQExecPrepared is used in C programs, PREPARE is used in SQL programs.  
I think it's fairly obvious that those use different syntax rules.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


Fri, 16 Jul 2004 22:40:13 +0200
Peter Eisentraut <peter_e@gmx.net>
Re: case sensitivity in PQExecPrepared