Re: check constriaint for BLOB

From: "Aasmund Midttun Godal" <postgresql(at)envisity(dot)com>
To: howieshouse(at)home(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: check constriaint for BLOB
Date: 2001-11-27 01:02:10
Message-ID: 20011127010210.23147.qmail@ns.krot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)home(dot)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(at)godal(dot)com - http://www.godal.com/
+47 40 45 20 46

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-27 01:25:06 Re: Row Limit?
Previous Message Roderick A. Anderson 2001-11-27 00:08:51 Row Limit?