Database Reference
In-Depth Information
WHEN SQLSTATE 'P9999' THEN RETURN 'Non-US Zip
Code';
WHEN SQLSTATE 'P9998' THEN RETURN 'Not enough
digits.';
WHEN SQLSTATE 'P9997' THEN RETURN 'Too many
digits.';
WHEN SQLSTATE 'P9996' THEN RETURN 'Between 6
and 8 digits.';
RAISE; -- Some other SQL error.
END;
$$
LANGUAGE 'plpgsql';
This code can be called as follows:
SELECT get_us_zip_validation_status('34955');
get_us_zip_validation_status
------------------------------
Passed Validation
(1 row)
root=# SELECT
get_us_zip_validation_status('349587');
get_us_zip_validation_status
------------------------------
Between 6 and 8 digits.
(1 row)
root=# SELECT
get_us_zip_validation_status('3495878977');
get_us_zip_validation_status
------------------------------
Too many digits.
(1 row)
root=# SELECT
get_us_zip_validation_status('BNHCGR');
