Greg Stark <[EMAIL PROTECTED]> writes: > Maybe my conception of enums is different from yours. My conception is > basically that of C enums. Where they're purely a creature of the syntax and > type system. At run-time they don't make any effort to prevent you from > treating them as integers.
Well, C is notorious for its weak notions of type, so I hardly think that counts as precedent for what we should do in SQL ;-) I don't mind offering a cast from enum to integer, at all, but I think it needs to be explicit-only. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org