Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAFG71m19125 for ; Thu, 15 Nov 2001 11:07:02 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fAFG6Vc12560; Thu, 15 Nov 2001 11:06:31 -0500 (EST) To: "Aasmund Midttun Godal" cc: pgsql-sql@postgresql.org Subject: Re: Unable to use '-' in column names in PLPGSQL In-reply-to: <20011115133813.8842.qmail@ns.krot.org> References: <20011115133813.8842.qmail@ns.krot.org> Comments: In-reply-to "Aasmund Midttun Godal" message dated "Thu, 15 Nov 2001 13:38:13 +0000" Date: Thu, 15 Nov 2001 11:06:31 -0500 Message-ID: <12557.1005840391@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/218 X-Sequence-Number: 5601 "Aasmund Midttun Godal" writes: > SELECT INTO kid "dir-id" FROM dir WHERE id = kid; plpgsql has a fairly brain-dead notion of what a double-quoted identifier can be: in fact, it really has *no* notion of it, but expects the same set of identifier characters that would be allowed in unquoted identifiers. I've had a TODO note to do something about that ... but not yet gotten to it. regards, tom lane