From: | nikhil raj <nikhilraj474(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Tempory table is not getting created inside Function in postgres. |
Date: | 2023-02-28 09:54:13 |
Message-ID: | CAG1ps1yu8ZwyoJncDzvjyHmfB_hPVFVHECRJntVuKw47vp6whQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Mon, Feb 27, 2023 at 1:17 PM nikhil raj <nikhilraj474(at)gmail(dot)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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Albert Cornelius | 2023-02-28 10:53:33 | Quit currently running query |
Previous Message | Alban Hertroys | 2023-02-28 08:10:54 | Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y |