Re: Unable to use '-' in column names in PLPGSQL - Mailing list pgsql-sql

From Tom Lane
Subject Re: Unable to use '-' in column names in PLPGSQL
Date
Msg-id 12557.1005840391@sss.pgh.pa.us
Whole thread Raw
In response to Unable to use '-' in column names in PLPGSQL  ("Aasmund Midttun Godal" <postgresql@envisity.com>)
List pgsql-sql
"Aasmund Midttun Godal" <postgresql@envisity.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


pgsql-sql by date:

Previous
From: Roland Roberts
Date:
Subject: Re: problem: index on number not honoured
Next
From: "Bryan White"
Date:
Subject: How to best grab a chunk of Ids from a sequence