Mario Splivalo <[EMAIL PROTECTED]> writes: > On Thu, 2007-01-25 at 11:09 -0500, Tom Lane wrote: >> 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.
> Having two function complicates, a bit, interface between applicaation > and the database. But, then again, If I split it in two functions, then > one with the UPDATE still can't find temp table referenced in other > function, right? It can as long as the table already exists when the function is entered. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly