Hi All, I am new to postgreSQL and have a working experience with SQLite. While i am creating a table, i want to use constraints or more so - use checks to see that
1. the email address is valid [a basic check with no bells and whistles is good enuf for me]. 2. On a separate column entry, i would also want to check that the string is a valid hex string i.e no characters other than [0-9 and (A- F or a-f)] are present. What is the simplest and most efficient way to achieve this without having to re-invent the wheel. Should i trigger actions during "insert" process or should i use constraints/checks during "create" process?? TIA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
