type casting a subselect as an interval

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Subject: type casting a subselect as an interval
Date: 2003-02-21 10:59:19
Message-ID: 3E560687.5060903@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How can I cast the return value of a sub-select as an interval?

Something like:

select current_timestamp - interval '(select days from T) days'

Thanks!

Jc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-02-21 11:01:56 Re: cursors and column names
Previous Message Richard Huxton 2003-02-21 10:50:17 Re: max connections