Parser doesn't grok unqualified array element

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Parser doesn't grok unqualified array element
Дата
Msg-id 11136.922594604@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: [HACKERS] Parser doesn't grok unqualified array element  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
Has this come up before?  6.4.2 and current sources both have
this problem:
select count(*) from pg_proc where pg_proc.proargtypes[0] = 701;
works, butselect count(*) from pg_proc where proargtypes[0] = 701;
fails with ERROR: Unable to locate type name 'proargtypes' in catalog

The grammar doesn't seem to have a case that allows for a subscripted
attribute name without a relation name in front of it.

It looks like fixing this might be as easy as making the "ColId"
cases in a_expr, b_expr, possibly other places include an
opt_indirection item like columnElem does.  But maybe there's
more to it than meets the eye?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Speedup idea: avoid using SQL procedures as aliases
Следующее
От: Michael Contzen
Дата:
Сообщение: Memory grows without bounds in aggregates!