Re: [pgadmin-support] Add 'CHECK( length(fieldname) > 0 )' to a field

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Daniel Seichter > Sent: 21 June 2005 14:58 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Add 'CHECK( length(fieldname) > 0 > )' to a field > > Hello, > > I have to let postg

[pgadmin-support] Add 'CHECK( length(fieldname) > 0 )' to a field

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 pos

Re: [pgadmin-support] Scroll Cursor Bug?

Thanks for the response, Sim. - I forgot to include the BEGIN in the example I sent. Even with the BEGIN, I get the same error. - I tried this with psql and you are right, the server spits back the message. Therefore, I will move this to the postgres forum. Thanks! Sim Zacks wrote: 1