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, 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', 
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 

      Get a sneak peak at messages with a handy reading pane with All new 
Yahoo! Mail:

Reply via email to