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.