Re: Using Temporary Tables in postgres functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mario(dot)splivalo(at)mobart(dot)hr
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Using Temporary Tables in postgres functions
Date: 2007-01-25 16:09:33
Message-ID: 20030.1169741373@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr> writes:
> Am I doing something wrong here, or there is no way of using temporary
> tables within 'sql' written functions?

I believe the problem is that for a SQL function we parse the whole
function body before executing any of it. So you'd need to split this
into two separate functions.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Neil Bibbins 2007-01-25 16:53:41 Windows 2K Installation difficulties...
Previous Message Stephan Szabo 2007-01-25 16:03:51 Re: Using Temporary Tables in postgres functions