Add 'CHECK( length(fieldname) > 0 )' to a field

From: "Daniel Seichter" <dseichter(at)radiomatic(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Add 'CHECK( length(fieldname) > 0 )' to a field
Date: 2005-06-21 13:58:02
Message-ID: s2b83918.014@HBC-N4.hbccr.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,

I have to let postgreSQL check the length of some fields in a database.
So I want to add the SQL Code "CHECK( length(fieldname) > 0 )" to some
fields so that the check will be executed during INSERT statement.
With the properties dialog I can't add the CHECK statement, so maybe it
isn't possible or I have to take a look to something. But to what?

Thank you in advance

Daniel Seichter

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2005-06-21 14:13:07 Re: Add 'CHECK( length(fieldname) > 0 )' to a field
Previous Message Larry Morroni 2005-06-21 12:53:25 Re: Scroll Cursor Bug?