Is there a way to set case sensitivity
on?
Thanks in advance
juan
Ola' juan,
Is there a way to set case sensitivity on?
No. Discussions about this thread are in the archives
(http://archives.postgresql.org). Take a look at:
http://www.postgresql.org/docs/8.0/interactive/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
Euler Taveira de Oliveira
euler[at]yahoo_com_br
On Sat, Apr 09, 2005 at 21:02:34 +0200,
[EMAIL PROTECTED] wrote:
Is there a way to set case sensitivity on?
In what context?
If you are talking about mixed case table or column names, then you need
to quote them with double quotes ().
---(end of
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
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
Peter Eisentraut wrote:
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
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