Re: SQL keywords are suddenly case sensitive - Mailing list pgsql-general

From Adrian Klaver
Subject Re: SQL keywords are suddenly case sensitive
Date
Msg-id 516DE001.7070002@gmail.com
Whole thread Raw
In response to SQL keywords are suddenly case sensitive  (Lee Hachadoorian <Lee.Hachadoorian+L@gmail.com>)
Responses Re: SQL keywords are suddenly case sensitive
List pgsql-general
On 04/16/2013 02:46 PM, Lee Hachadoorian wrote:
> List,
>
> SQL seems to be behaving in a case-sensitive manner:
>
> universe=# select 1;
>   ?column?
> ----------
>          1
> (1 row)
>
> universe=# SELECT 1;
> ERROR:  syntax error at or near "SELECT 1"
> LINE 1: SELECT 1;
>          ^
> I cannot figure out how this happened, and Google is not helping because
> all I'm getting is information about case-sensitivity in identifiers or
> in string comparison. I didn't even think this was possible, as I've
> always switched between lower case and upper case keywords, usually
> using lower case while testing and upper case to prettify scripts that I
> will be saving for reuse.

Another question:

Are the psql and Postgres versions the same?

> Regards,
> --Lee
>


--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: SQL keywords are suddenly case sensitive
Next
From: Lee Hachadoorian
Date:
Subject: Re: SQL keywords are suddenly case sensitive