Suggestion for Enum Support Functions
| От | toronto programmer |
|---|---|
| Тема | Suggestion for Enum Support Functions |
| Дата | |
| Msg-id | 157876.1259.qm@web58601.mail.re3.yahoo.com обсуждение |
| Ответы |
Re: Suggestion for Enum Support Functions
|
| Список | pgsql-hackers |
Dear Postgres developers,
I have been working with Oracle for few years now in my work, and I tried some free databases for a project that I'm developing for my own use, I have tried H2,FireBird and postgres, and found the last to be the most stable and feature-rich, so thanks for all the good work.
I have read the 8.3 documentation, and with reference to Enum Support Functions found on http://developer.postgresql.org/pgdocs/postgres/functions-enum.html, i think it is useful to add 2 functions, enum_after(anyenum) and enum_before(anyenum), so having :
I have been working with Oracle for few years now in my work, and I tried some free databases for a project that I'm developing for my own use, I have tried H2,FireBird and postgres, and found the last to be the most stable and feature-rich, so thanks for all the good work.
I have read the 8.3 documentation, and with reference to Enum Support Functions found on http://developer.postgresql.org/pgdocs/postgres/functions-enum.html, i think it is useful to add 2 functions, enum_after(anyenum) and enum_before(anyenum), so having :
CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple');
enum_after('orange'::rainbow) will return 'yellow'
enum_after('purple'::rainbow) will return an error
enum_before('purple'::rainbow) will return 'blue'
a good to have function would be enum_size(anyenum) which would return 6 in the previous example
that will be helpful in dealing with enums
Best regards
Hashim Kubba
Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail
В списке pgsql-hackers по дате отправления: