Re: SQLState

Am Mittwoch, 12. Mai 2004 04:07 schrieb Mahesh Swamy:
> 2/ If there is no convention is it ok to use the letter 'x' for all our
> State codes? eg. if we want to add a state under the "53" class, we would
> use "53x001", "53x002" and so on.

That doesn't work, because sqlstate values have to be exactly 5 characters.

In addition to the conventions that you were already told, classes starting
with Y are reserved for PostgreSQL clients.