Postgres Pro
Downloads
Home   >   mailing lists

Re: Convert INT to INTERVAL? - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Convert INT to INTERVAL?
Date
Msg-id 20040227174059.GB18900@wolff.to
Whole thread Raw
In response to Convert INT to INTERVAL?  (Brian Knox <laotse@aol.net>)
List pgsql-sql
Tree view 
On Fri, Feb 27, 2004 at 11:54:04 -0500, Brian Knox <laotse@aol.net> wrote:
> Is it possible within pl/pgsql, to convert an integer to an interval in 
> months? IE, if num_months is an INT set to 48, can it be converted to an 
> interval?

Can you use num_months * '1 month'::interval ?

pgsql-sql by date:

Previous
From: "David"
Date:
Subject: Re: searching polygons
Next
From: Michael Chaney
Date:
Subject: Re: Convert INT to INTERVAL?