Re: How to write a function that manipulates a set of results

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ashley Moran <work(at)ashleymoran(dot)me(dot)uk>
Cc: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to write a function that manipulates a set of results
Date: 2007-03-14 19:25:15
Message-ID: 27124.1173900315@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ashley Moran <work(at)ashleymoran(dot)me(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-03-14 19:27:26 Re: grant permissions to set variable?
Previous Message Jorge Godoy 2007-03-14 19:11:51 Re: Multiple TRIGGERs and OLD versus NEW "records"