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 wrote:
>
>>
>> The same query
On Mon, Feb 27, 2023 at 1:17 PM nikhil raj 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
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
creat
nikhil raj 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 r
On 2/27/23 11:52 AM, nikhil raj wrote:
Reply to list also
Ccing list.
HI Adrian,
Yes, I have tried it through the same error.
Orion_db=> select api."post_publish_Roster"()
Orion_db -> ;
ERROR: relation "roster_table" does not exist
LINE 94: ... interval '1 day')::date as d_date F
On 2/27/23 11:10 AM, nikhil raj wrote:
HI Team,
This is the Function I have created successfully but while executing it
throughs an error temp table doesn't exist.
But the same when I execute it not inside the function from **drop temp
table to end insert select ** it work fine
Please can
HI Team,
This is the Function I have created successfully but while executing it
throughs an error temp table doesn't exist.
But the same when I execute it not inside the function from **drop temp
table to end insert select ** it work fine
Please can any one help me why in the function i am not
