From: | "Klaus P(dot) Pieper" <kpi6288(at)gmail(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Allow disabling folding of unquoted identifiers to lowercase |
Date: | 2016-05-08 09:41:03 |
Message-ID: | 00b501d1a90d$bd6755b0$38360110$@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Ursprüngliche Nachricht-----
>
> What exactly is the problem you are trying to solve?
>
> If you and your users are consistent about never using quotes, your users
can
> write:
>
> SELECT MyColumn FROM MyTable ORDER BY MyColumn;
>
> It will select mycolumn from mytable, but that doesn't matter, since you
> created the table with
>
> CREATE MyTable (MyColumn varchar);
>
> so you really have a table mytable with a column mycolumn, not a table
> MyTable with a column MyColumn.
I use 50% of my time Sybase and 50% PostgreSQL.
For me is the way Sybase works is just more convenient:
CREATE MyTable (MyColumn varchar);
creates a camel cased table MyType and field MyColumn.
SELECT * FROM SYSCATALOG gives MyTable.
This is better readable when you use long table / fiel names.
The user can then use whatever he wants: mytable, MyTable, myTABLE, ...
Klaus
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2016-05-08 19:12:00 | Re: Allow disabling folding of unquoted identifiers to lowercase |
Previous Message | Peter J. Holzer | 2016-05-08 09:26:53 | Re: Allow disabling folding of unquoted identifiers to lowercase |