Programmatic access to interval units - Mailing list pgsql-general

From Nelson Green
Subject Programmatic access to interval units
Date
Msg-id CAGo-KZ=-JZLK3C-BzZvOzq_23oJ_tnVHEH2JJLMLR3tPbnWSbQ@mail.gmail.com
Whole thread Raw
Responses Re: Programmatic access to interval units
List pgsql-general
Good morning list,

According to the documentation for interval data type inputs, the unit can be one of microsecond, millisecond, second, minute, hour, day, week, month, year, decade, century, or millennium. Are these units stored in a catalog somewhere? I would like to access them programmatically if possible, to validate input for a function I am developing.

Thanks,
Nelson

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Slow delete when many foreign tables are defined
Next
From: Andy Colson
Date:
Subject: Re: Slow delete when many foreign tables are defined