"Pit Mueller" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]