Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql, double quoted column names containing spaces/hyphens - Mailing list pgsql-sql

From Tom Lane
Subject Re: plpgsql, double quoted column names containing spaces/hyphens
Date
Msg-id 29697.1056233881@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql, double quoted column names containing spaces/hyphens  ("Knut P. Lehre" <k.p.lehre@tiscali.no>)
List pgsql-sql
Tree view 
"Knut P. Lehre" <k.p.lehre@tiscali.no> writes:
> Using pgsql 7.2.1 (PeerDirect beta4) on WinXP Prof SP1. Client: MS 

> In plpgsql, I can access columns with a name containing capital letters by 
> enclosing the name in double quotes: tbl."ColName"
> However, if the quoted name contains spaces or hyphens I get an error 
> message.

This is fixed in 7.3.
        regards, tom lane

pgsql-sql by date:

Previous
From: "Knut P. Lehre"
Date:
Subject: plpgsql, double quoted column names containing spaces/hyphens
Next
From: "Rudi Starcevic"
Date:
Subject: Delete duplicates