Thread: 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