Re: named generic constraints [feature request] - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: named generic constraints [feature request]
Date
Msg-id 162867790911232052j243f4c91hd72809ea59a6d266@mail.gmail.com
Whole thread Raw
In response to Re: named generic constraints [feature request]  (Caleb Cushing <xenoterracide@gmail.com>)
Responses Re: named generic constraints [feature request]
List pgsql-hackers
2009/11/24 Caleb Cushing <xenoterracide@gmail.com>:
>> 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

no -

"--" is line comment in SQL - it same like "//" in C++

Regards
Pavel Stehule

>
> --
> Caleb Cushing
>
> http://xenoterracide.blogspot.com
>


pgsql-hackers by date:

Previous
From: Itagaki Takahiro
Date:
Subject: Re: Partitioning option for COPY
Next
From: KaiGai Kohei
Date:
Subject: Re: SE-PgSQL patch review