Hi Tom, The same query is executed outside the function its working properly means just the qurey from drop temp table to insert but when i keep the query inside a function its through me the error an after temp ra how creation only i am using the select statment still its not exectuing the create statment or not storing the temp table.
On Tue, 28 Feb, 2023, 1:34 am Tom Lane, <t...@sss.pgh.pa.us> wrote: > nikhil raj <nikhilraj...@gmail.com> writes: > > This is the Function I have created successfully but while executing it > > throughs an error temp table doesn't exist. > > You won't be able to do it like that in a SQL-language function, because > the whole function body is parsed and parse-analyzed in one go. So the > later query referencing ROSTER_TABLE fails because it's parsed before > the CREATE TABLE executes. (Improving that has been on the to-do list > for a couple of decades, so don't hold your breath...) I suggest putting > the whole thing, not just part of it, into plpgsql. > > regards, tom lane >
