Re: BUG #1364: using field names or table names with blanks - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1364: using field names or table names with blanks
Date
Msg-id 19451.1104366005@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1364: using field names or table names with blanks  ("Pit Mueller" <fmi-soft@gmx.de>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: function return type for triggers in postgresql 8.0 rc2
Next
From: "keith berrington"
Date:
Subject: BUG #1366: spam from yourselves