Re: [SQL] Best way to delete time stamped data?

Josh,

Thanks, even my boss can read the new statement:

DELETE FROM ONLY richtable WHERE age(trxdate) > '90 days';

Your disparaging aside, that is exactly the kind of expression
compaction I was after! :)

And yeah, I have a deep PERL background, but that's not a bad thing.

-Kyle

Josh Berkus wrote:
> More compact than that ?!?!?!
> Maybe you should go into Perl, instead of SQL -- I think the one-liners would
> suit you.
>
> You can use the age() function, but all that funciton does is the same
> calculation you have above.