BUG #1364: using field names or table names with blanks
The following bug has been logged online:
Bug reference: 1364
Logged by: Pit Mueller
Email address: fmi-soft@gmx.de
PostgreSQL version: 8.0
Operating system: WINXP
Description: using field names or table names with blanks
Details:
MS SQL Server uses a quite elegant method for using field names and table
names:
select [field] from [table]
f.ex. select [my field] from [the big table]
PostgreSQL 8.0 should support this notation too.
Brackets are not supported at the moment -> the SQL parser notifies an
syntax error
"Pit Mueller" <fmi-soft@gmx.de> writes:
MS SQL Server uses a quite elegant method for using field names and table
names:
select [field] from [table]
f.ex. select [my field] from [the big table]
One man's "elegant" is another's "ugly and nonstandard".
PostgreSQL 8.0 should support this notation too.
Not likely. Use double quotes like the SQL standard tells you to:
select "my field" from "the big table"
One would hope that SQL Server takes this too, since they claim some
amount of spec compliance.
regards, tom lane