New business validation SQL-functions: is_email (email), is_iban (IBAN) and is_uri (URI)

Wiki (en)
1

The amount of data validation of business data varies per platform. For instance, marketing systems typically less strict check naming and identifiers such as bank accounts.

With increasing use of Invantive SQL for data-integration tasks between and within platforms, the need arose to simplify validation of business data in source platforms.

The following three SQL-functions ease validating source data:

  • is_email: is the email address valid according to RFC 822? By specifying additional boolean parameter, the use of ‘+’ in the name component is enabled.
  • is_uri: is the URI valid?
  • is_iban: is the IBAN-account valid? By specifying additional boolean parameter, the use of spaces (’ ') in the account component is enabled.

IBAN SQL-validation Sample

The following code returns true or false depending whether the IBAN-number could be valid:

select is_iban('NL42 RABO 0123 4097 80', true)

These new SQL-functions for email, URI and IBAN-account validation are available in release 22.0.407 and newer.