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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly