X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 318EC30F1D3 for ; Sat, 21 Jun 2003 22:18:13 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 01473-05 for ; Sat, 21 Jun 2003 19:18:02 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 67BD130F14E for ; Sat, 21 Jun 2003 19:18:02 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h5LMI2U6029698; Sat, 21 Jun 2003 18:18:02 -0400 (EDT) To: "Knut P. Lehre" Cc: pgsql-sql@postgresql.org Subject: Re: plpgsql, double quoted column names containing spaces/hyphens In-reply-to: <5.1.0.14.2.20030620214454.00c200e0@uio-pop.uio.no> References: <5.1.0.14.2.20030620214454.00c200e0@uio-pop.uio.no> Comments: In-reply-to "Knut P. Lehre" message dated "Fri, 20 Jun 2003 22:24:07 +0200" Date: Sat, 21 Jun 2003 18:18:01 -0400 Message-ID: <29697.1056233881@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200306/239 X-Sequence-Number: 13997 "Knut P. Lehre" 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