"Alexander Zhiltsov" <[EMAIL PROTECTED]> writes:
> "Tom Lane" <[EMAIL PROTECTED]> wrote:
>> I'm not convinced this is really a bug, because pg_index.indexprs is not
>> an expression (it's a list of expressions) and so it's not clear that
>> pg_get_expr should be expected to work on it. What result
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
"Alexander Zhiltsov" <[EMAIL PROTECTED]> writes:
> Executing the following query return an error 'ERROR: unrecognized node ty=
> pe: 656'.
> SELECT pg_get_expr(i.indexprs, i.indrelid) AS expr
> FROM pg_index i
> INNER JOIN pg_class c ON i.indrelid =3D c.oid
> WHERE c.relname =3D 'art'
I'm not c
Hello,
I downloaded and install postgresql-8.0.0beta3.tar.gz
I create the following table:
CREATE OR REPLACE FUNCTION "ayz"."my_lower" (text)
RETURNS text AS'BEGIN return lower($1);END;'LANGUAGE
'plpgsql' IMMUTABLE RETURNS NULL ON NULL INPUT SECURITY INVOKER;
CREATE TABLE public.art( a
