Re: Quotes in SQL

On Tue, 14 May 2002, Tom Lane wrote:

> Paul M Foster <paulf@quillandmouse.com> writes:
> >> That's normal. If you use quotes when you create the table, you (usually)
> >> need quotes when accessing the fields. If you don't use quotes when creating
> >> the table, you don't need them when accessing.
>
> > Huh? Doesn't the parser strip off the quotes? Are you saying it stores
> > the quotes and expects you to provide them when accessing the fields?
>
> No; the above is just a rule of thumb for staying out of case-folding
> trouble, which is what seems to be biting you.  See
>
> http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
>
> and pay particular attention to the footnote ...

The simple rule of thumb to prevent all this is just use lower case for
everything.  It sure makes my life easier.