Parser doesn't grok unqualified array element - Mailing list pgsql-hackers

From Tom Lane
Subject Parser doesn't grok unqualified array element
Date
Msg-id 11136.922594604@sss.pgh.pa.us
Whole thread Raw
Responses Re: [HACKERS] Parser doesn't grok unqualified array element
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Speedup idea: avoid using SQL procedures as aliases
Next
From: Michael Contzen
Date:
Subject: Memory grows without bounds in aggregates!