> 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