HI All, This for the help plpgsql and rest everything just move under declare and now everything works fine. Thanks for the help.
On Tue, Feb 28, 2023 at 2:10 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Mon, Feb 27, 2023 at 1:17 PM nikhil raj <nikhilraj...@gmail.com> wrote: > >> >> 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. >> >>> >>> > What Tom said is that in the following change 'sql' to plpgsql and move > on. Your function is not capable of being executed in an SQL language > function. > > CREATE OR REPLACE FUNCTION api."post_publish_Roster"( > ) > RETURNS void > LANGUAGE 'sql' > COST 100 > VOLATILE PARALLEL UNSAFE > AS $BODY$ > > David J. > >
