Re: plpgsql, double quoted column names containing spaces/hyphens

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Knut P(dot) Lehre" <k(dot)p(dot)lehre(at)tiscali(dot)no>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: plpgsql, double quoted column names containing spaces/hyphens
Date: 2003-06-21 22:18:01
Message-ID: 29697.1056233881@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Knut P. Lehre" <k(dot)p(dot)lehre(at)tiscali(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rudi Starcevic 2003-06-22 09:15:22 Delete duplicates
Previous Message Knut P. Lehre 2003-06-20 20:24:07 plpgsql, double quoted column names containing spaces/hyphens