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  (Andrew Dunstan <andrew@dunslane.net>)
Список 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 :

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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Maximum reasonable bgwriter_delay
Следующее
От: Chris Browne
Дата:
Сообщение: Re: PG-MQ?