Re: Programmatic access to interval units

On Tue, Dec 2, 2014 at 3:48 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

> On Tue, Dec 2, 2014 at 12:40 PM, Nelson Green <nelsongreen84(at)gmail(dot)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
>

But you took time to work with me, and I appreciate that.

Thanks,
Nelson