[HACKERS] Case Sensitivity

2005-04-10 Thread juan
Is there a way to set case sensitivity on? Thanks in advance juan

Re: [HACKERS] Case Sensitivity

2005-04-10 Thread Euler Taveira de Oliveira
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

Re: [HACKERS] Case Sensitivity

2005-04-10 Thread Bruno Wolff III
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

[HACKERS] case sensitivity in PQExecPrepared

2004-07-16 Thread Merlin Moncure
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

Re: [HACKERS] case sensitivity in PQExecPrepared

2004-07-16 Thread Peter Eisentraut
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

Re: [HACKERS] case sensitivity in PQExecPrepared

2004-07-16 Thread Merlin Moncure
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

Re: [HACKERS] case sensitivity in PQExecPrepared

2004-07-16 Thread Peter Eisentraut
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