Re: check constriaint for BLOB - Mailing list pgsql-general

From Aasmund Midttun Godal
Subject Re: check constriaint for BLOB
Date
Msg-id 20011127010210.23147.qmail@ns.krot.org
Whole thread Raw
In response to check constriaint for BLOB  ("news.postgresql.org" <howieshouse@home.com>)
Responses Re: check constriaint for BLOB  ("Howard Williams" <howieshouse@home.com>)
List pgsql-general
CREATE TABLE testus (
    data BYTEA CHECK (octet_length(data) > 10000)
);
Perhaps?

Regards,

Aasmund.

On Mon, 26 Nov 2001 15:36:28 -0800, "news.postgresql.org" <howieshouse@home.com> wrote:
> Is it possible to add a constraint during "CREATE TABLE" that guarantees
> objects in a certain field will be greater than zero size?
>
> Thanks,
>
> Howie
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46

pgsql-general by date:

Previous
From: "Roderick A. Anderson"
Date:
Subject: Row Limit?
Next
From: Tom Lane
Date:
Subject: Re: Row Limit?