Daniel John Debrunner wrote:
Why string constants for derivation though, why not integer values?Also there's no constant for error, though I would not recommend having an error value. Why not just use none as the default value? That will lead to the same behaviour, no collation suppported. Adding an error state is something that is not in the SQL standard.
sorry misread error as explicit since I was expecting an explicit type to be defined. Still, not sure why an "error" state is needed.
Dan.
