type casting a subselect as an interval - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject type casting a subselect as an interval
Date
Msg-id 3E560687.5060903@mega-bucks.co.jp
Whole thread Raw
Responses Re: type casting a subselect as an interval  (Karel Zak <zakkr@zf.jcu.cz>)
List 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


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: cursors and column names
Next
From: Karel Zak
Date:
Subject: Re: type casting a subselect as an interval