Hi,
A colleague and I noticed that MySQL allows this:
CREATE TABLE ` ` ( ` ` INT NOT NULL );
A table with a space as its name and a space as a column name.
We were quite surprised by that and we tested it on postgresql at once
to see whether it was the only one to do so.
Now we were even more surprised that postgresql allows this aswell:
kb=# CREATE TABLE " " (" " int not null);
CREATE TABLE
kb=# \d " "
Table "public. "
Column | Type | Modifiers
--------+---------+-----------
| integer | not null
Is this per spec, a bug or intended behaviour?
Best regards,
Arjen van der Meijden