Re: Problem with the use of Array and Loop - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with the use of Array and Loop
Date
Msg-id 3692.1050675074@sss.pgh.pa.us
Whole thread Raw
In response to Problem with the use of Array and Loop  ("Benjamin RICHARD" <benjamin@intradot.com>)
List pgsql-general
"Benjamin RICHARD" <benjamin@intradot.com> writes:
> To do this i create the following function which return me a parse error
> near '[' (in the Raise notice line)
> What mistake did i do ?

IIRC, the RAISE NOTICE command is incapable of evaluating expressions;
it can only handle trivial variable references.  Do something useful
with the array element instead of RAISE ...

            regards, tom lane


pgsql-general by date:

Previous
From: Patrick Welche
Date:
Subject: explain ?
Next
From: Tom Lane
Date:
Subject: Re: explain ?