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

2003-06-21 Thread Tom Lane
"Knut P. Lehre" <[EMAIL PROTECTED]> 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 hyph

[SQL] plpgsql, double quoted column names containing spaces/hyphens

2003-06-21 Thread Knut P. Lehre
Using pgsql 7.2.1 (PeerDirect beta4) on WinXP Prof SP1. Client: MS VStudio2003 C++ -> ADO -> ODBC 7.03.01.00. 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