Re: [gnome-db] Per-table meta-data with capital letters in the table name?

Vivien Malerba <[email protected]>
Newsgroups gmane.comp.gnome.db
Message-ID <[email protected]>
2009/7/1 Murray Cumming <[email protected]>

> 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

_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.