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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Unable to use '-' in column names in PLPGSQL
Дата
Msg-id 12557.1005840391@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Unable to use '-' in column names in PLPGSQL  ("Aasmund Midttun Godal" <postgresql@envisity.com>)
Список 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 по дате отправления:

Предыдущее
От: Roland Roberts
Дата:
Сообщение: Re: problem: index on number not honoured
Следующее
От: "Bryan White"
Дата:
Сообщение: How to best grab a chunk of Ids from a sequence