Re: Function inside query status

2022-06-30 Thread Adrian Klaver
On 6/29/22 23:57, Rama Krishnan wrote: Hi All, Is it possible to check the query execution status inside the function.  created or replace function data_purge() returns void as$$ Declare Begin Drop table test_old; Create table test_old as select * from sales where bill_date-interval '1 year

Function inside query status

2022-06-29 Thread Rama Krishnan
Hi All, Is it possible to check the query execution status inside the function. created or replace function data_purge() returns void as$$ Declare Begin Drop table test_old; Create table test_old as select * from sales where bill_date