2009/7/1 Murray Cumming
<murrayc murrayc com>
On Wed, 2009-07-01 at 10:19 +0200, Vivien Malerba wrote:
> For SQL identifiers you don't care how they are represented as long
> as they represent the correct object: for example the *myTable* object
> is
> the same as the *mytable* object (I used asterixes to avoid any
> confusion
> with double quotes).
Are you sure? Is this specified somewhere?
Surely these refer to different tables?
SELECT * FROM "mytable"
SELECT * FROM "MyTable"
I used asterixes, not double quotes, so I was saying that
SELECT * FROM mytable
SELECT * FROM MyTable
are the same