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.
- [SQL] Create table in functions Andreas Tille
- Re: [SQL] Create table in functions Tom Lane
- RE: [SQL] Create table in functions Hiroshi Inoue
- Re: [SQL] Create table in functions Tom Lane
- RE: [SQL] Create table in functions Hiroshi Inoue
- [SQL] RE: Create table in functions Andreas Tille
- Re: [SQL] RE: Create table in functions Jan Wieck
- [SQL] Re: RE: Create table in function... Andreas Tille
- Re: [SQL] Create table in functions Jie Liang
- hlefebvre