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.
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