On 7/20/22 00:08, Rama Krishnan wrote:
> Hi All,
>
> I am doing purge activity my sales table contains 5M records I am going to
> delete more than 1 year data (which was 3M) records so it was running more
> so I want to do batch wise deletion through plsql
>
>
>
>
> 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;
>
>
> Kindly guide me
Why not just DELETE FROM sales WHERE bill_date<NOW() -INTERVAL '1 year';?
--
Angular momentum makes the world go 'round.