Re: Create table in functions

Поиск
Список
Период
Сортировка
От hlefebvre
Тема Re: Create table in functions
Дата
Msg-id 39A4EC81.BF9ECFC5@lexbase.net
обсуждение исходный текст
Ответ на Create table in functions  (Andreas Tille <tillea@rki.de>)
Список 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 по дате отправления: