How can I test that a text variable has a value that represents a valid data type, other than writing something like: variable IN ('integer', 'text', 'float'...)?
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html