| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Messy Casts, Is there a better way? |
| Date: | 2002-10-18 00:13:47 |
| Message-ID: | 1034900027.386.2.camel@lerlaptop.lerctr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, 2002-10-17 at 17:50, Josh Berkus wrote:
> Larry,
>
> > If I do that, and enter '72 months' in the contract_term field, how
> > can
> > I convince PostgreSQL to output the interval back in months? It
> > wants
> > to give me '5 Years'.
>
> That's on the TODO list, I'm afraid. From the sound of it, you should
> stick with your current schema and custom function.
Thanks. At least I know I'm not missing something here.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Акулов Александр | 2002-10-18 05:06:03 | Can I create working trigger on view |
| Previous Message | Josh Berkus | 2002-10-17 22:50:47 | Re: Messy Casts, Is there a better way? |