Re: Bug in PostrgeSQL 8.0beta

On Fri, Oct 01, 2004 at 02:46:33PM +0600, Alexander Zhiltsov wrote:

> Executing the following query return an error 'ERROR:  unrecognized node type: 656'.
> SELECT pg_get_expr(i.indexprs, i.indrelid) AS expr
> FROM pg_index i
>   INNER JOIN pg_class c ON i.indrelid = c.oid
> WHERE c.relname = 'art'
>
> Expression tree is
> ({FUNCEXPR :funcid 4061872 :funcresulttype 25 :funcretset false :funcformat 0 :args ({RELABELTYPE :arg {VAR :varno 1
:varattno2 :vartype 1043 :vartypmod 64 :varlevelsup 0 :varnoold 1 :varoattno 2} :resulttype 25 :resulttypmod -1
:relabelformat1})}) 

pg_get_expr() in PostgreSQL 8.0.0beta3 doesn't like the parentheses
that surround the expression.  This query works for me:

SELECT pg_get_expr(trim(BOTH '()' FROM i.indexprs), i.indrelid) AS expr
FROM pg_index i
  INNER JOIN pg_class c ON i.indrelid = c.oid
WHERE c.relname = 'art';

pg_get_expr() in PostgreSQL 7.4.5 works both ways.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/