> CREATE OR REPLACE FUNCTION emptystr(text) > RETURNS bool AS $$ > SELECT $1 <> ''; -- it is SQL not C > $$ LANGUAGE sql; > > CREATE TABLE users( > username TEXT CHECK (NOT emptystr(username)),
although I'm not going to continue discussing the request. this code as the opposite desired effect. it should be SELECT $1 = ''; -- you have a double negative -- Caleb Cushing http://xenoterracide.blogspot.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
