Re: [ADMIN] OT: using column in an interval

2006-03-24 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Thu, 23 Mar 2006, Bradley Kieser wrote: >> last_backup: timestamp >> backup_unit: integer - Represents day, week, quarter, annual, etc. The >> text is stored in backup_code (e.g. 'days', 'months') >> backup_period: integer - Represents the skip factor.

Re: [ADMIN] OT: using column in an interval

2006-03-24 Thread Stephan Szabo
On Thu, 23 Mar 2006, Bradley Kieser wrote: > All, > > I know that this isn't strictly an admin question but please forgive me > for asking. > I am writing a (admin) job which does a select off a PG database based > on three columns: > > last_backup: timestamp > backup_unit: integer - Represents d

[ADMIN] OT: using column in an interval

2006-03-24 Thread Bradley Kieser
All, I know that this isn't strictly an admin question but please forgive me for asking. I am writing a (admin) job which does a select off a PG database based on three columns: last_backup: timestamp backup_unit: integer - Represents day, week, quarter, annual, etc. The text is stored in ba