Re: Unable to use '-' in column names in PLPGSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Aasmund Midttun Godal" <postgresql(at)envisity(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Unable to use '-' in column names in PLPGSQL
Date: 2001-11-15 16:06:31
Message-ID: 12557.1005840391@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Aasmund Midttun Godal" <postgresql(at)envisity(dot)com> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Roland Roberts 2001-11-15 16:11:30 Re: INSERT question
Previous Message Jeff Eckermann 2001-11-15 15:48:43 Re: Insert values from one existing table into a new table.