Re: Programmatic access to interval units - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Programmatic access to interval units
Date
Msg-id CAHyXU0xxy6Qub7DudSnwrJyD--d15PQKDd=tt7X547kaz5SjmQ@mail.gmail.com
Whole thread Raw
In response to Re: Programmatic access to interval units  (Nelson Green <nelsongreen84@gmail.com>)
Responses Re: Programmatic access to interval units  (Nelson Green <nelsongreen84@gmail.com>)
List pgsql-general
On Tue, Dec 2, 2014 at 12:40 PM, Nelson Green <nelsongreen84@gmail.com> wrote:
> In the line: IF LOWER(_unit) NOT IN (SELECT interval_unit ..., I would
> rather
> query a catalog table for the interval unit names if possible. That would
> then
> compensate for any changes to those values in the future.
>
> When I meant do this in C, I was referring to rewriting this function in C
> instead of Pl/pgSQL.
>
> I hope this helps you understand what I am asking, and apologies for not
> being
> more specific up front.

I was the one that was confused -- heh.  I mis-understood the original
email and thought you were trying to validate interval output vs
interval input.

merlin


pgsql-general by date:

Previous
From: Nelson Green
Date:
Subject: Re: [Solved] Programmatic access to interval units
Next
From: Adrian Klaver
Date:
Subject: Re: Problem with pg_dump and decimal mark