Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL Join - MySQL/PostgreSQL difference? - Mailing list pgsql-sql

From Tom Lane
Subject Re: SQL Join - MySQL/PostgreSQL difference?
Date
Msg-id 28158.981558648@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL Join - MySQL/PostgreSQL difference?  (Brice Ruth <brice@webprojkt.com>)
List pgsql-sql
Tree view 
Brice Ruth <brice@webprojkt.com> writes:
> About the case-sensitivity, I was under the impression that PostgreSQL
> was case-insensitive unless things were explicitly put in quotes.

Names in queries (of tables, fields, functions, etc) are
case-insensitive.  This has nothing to do with the behavior of data
comparisons, however.
        regards, tom lane

pgsql-sql by date:

Previous
From: Michael Fork
Date:
Subject: Re: Re: SQL Join - MySQL/PostgreSQL difference?
Next
From: Brice Ruth
Date:
Subject: Re: SQL Join - MySQL/PostgreSQL difference?