Postgres Pro
Downloads
Home   >   mailing lists

Re: Using Temporary Tables in postgres functions - Mailing list pgsql-sql

From Tom Lane
Subject Re: Using Temporary Tables in postgres functions
Date
Msg-id 20030.1169741373@sss.pgh.pa.us
Whole thread Raw
In response to Using Temporary Tables in postgres functions  (Mario Splivalo <mario.splivalo@mobart.hr>)
Responses Re: Using Temporary Tables in postgres functions  (Mario Splivalo <mario.splivalo@mobart.hr>)
List pgsql-sql
Tree view 
Mario Splivalo <mario.splivalo@mobart.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

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Using Temporary Tables in postgres functions
Next
From: "Furesz Peter"
Date:
Subject: Looping recordset