Postgres Pro
Downloads
Home   >   mailing lists

Re: How to write a function that manipulates a set of results - Mailing list pgsql-general

From Tom Lane
Subject Re: How to write a function that manipulates a set of results
Date
Msg-id 27124.1173900315@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to write a function that manipulates a set of results  (Ashley Moran <work@ashleymoran.me.uk>)
Responses Re: How to write a function that manipulates a set of results  (Ashley Moran <work@ashleymoran.me.uk>)
List pgsql-general
Tree view 
Ashley Moran <work@ashleymoran.me.uk> writes:
> ... All of which is easy with table variable, but I can't see how to
> translate it to PL/pgsql.  Is there any way to manipulate result sets
> in a set-based manner like this?

Sure: use a table.  What was the objection to temp tables exactly?

            regards, tom lane

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: Multiple TRIGGERs and OLD versus NEW "records"
Next
From: Tom Lane
Date:
Subject: Re: grant permissions to set variable?