Function inside query status

[Rama Krishnan <raghuldrag@xxxxxxxxx>]

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<now() -interval '1 year';

Delete table sales where sales_id in (select sales_id from test_old;

End;

$$ language plpgsql;