Re: Create table in functions - Mailing list pgsql-sql

From hlefebvre
Subject Re: Create table in functions
Date
Msg-id 39A4EC81.BF9ECFC5@lexbase.net
Whole thread Raw
In response to Create table in functions  (Andreas Tille <tillea@rki.de>)
List pgsql-sql
Andreas Tille wrote:
> What does this mean?  The ERROR is caused by the Create Table statement
> (when I removed it from my complex function it worked well).
> So why doesn't this work and what copy function fails here??

Maybe you can create your table using a select into statement :

something like :
SELECT int4(1) as Num INTO Temp_NumTable WHERE 1=2;

Should create your table without CREATE statement.


pgsql-sql by date:

Previous
From: tolik@aaanet.ru (Anatoly K. Lasareff)
Date:
Subject: Re: Null function parameters
Next
From: Alex Guryanow
Date:
Subject: sorting in UNICODE table