Hi. I have a table created like this:
CREATE TABLE dv.data ( vid bytea NOT NULL, providerid smallint NOT NULL, creationdate timestamp with time zone NOT NULL, payload bytea NOT NULL, duration smallint NOT NULL );
DURATION is a value in days after which an entry is considered expired (if not 0/Zero). Such entries should get deleted. Technically, I want to find out if the current timestamp
NOW() is bigger than
I tried several hacks with
INTERVAL, but I can not make the
DURATION column to work as a days value to calculate with.
Can someone point me to the right direction?