Re: plpgsql Field of Record issue - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: plpgsql Field of Record issue
Date
Msg-id 02ac01c1c2fc$4d136b70$8001a8c0@jester
Whole thread Raw
In response to plpgsql Field of Record issue  ("Rod Taylor" <rbt@zort.ca>)
List pgsql-hackers
> "Rod Taylor" <rbt@zort.ca> writes:
> > Is there any other way to accomplish NEW.TG_ARGV[0] in plpgsql,
>
> You could do something involving EXECUTE.

Then it tells me:: ERROR: NEW used in non-rule query

Tried a few other things, FOR .. IN EXECUTE .. which gives the same
error as above.

The below query gives me the same error as well -- though I'd be
surprised if it worked anyway:
CREATE TEMP TABLE test AS SELECT * FROM (NEW);

Creating a record and assigning NEW to it gives a parse error.



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Status of index location patch
Next
From: Bruce Momjian
Date:
Subject: Re: elog() patch