Thanks for the response, but...
I'm using data type oid - as far as I know, that's not the same thing as
byteA. Please correct me if I'm wrong.
Howie
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Aasmund Midttun
Godal
Sent: Monday, November 26, 2001 5:02 PM
To: howieshouse@home.com
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] check constriaint for BLOB
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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org