Re: Restrict inserts to meet certain conditions?

2007-09-30 Thread David Christopher Zentgraf
That's what I thought. Thanks! On 30. Sep 2007, at 14:55, Rob Wultsch wrote: CHECK CONSTRAINT I mean... On 9/29/07, Rob Wultsch [EMAIL PROTECTED] wrote: CONSTRAINT does not exist in mysql. You can use a trigger to deal with the issue, which is obviously less than ideal. On 9/29/07, David

Re: Restrict inserts to meet certain conditions?

2007-09-30 Thread Rob Wultsch
I am sorry for sending multiple notes. The reply to is set not being set to mysql discussion list. I click the reply button automatically. This email is for the sake of the list sake... You want a feature like a check constraint: http://www.postgresql.org/docs/8.1/static/ddl-constraints.html

Re: Restrict inserts to meet certain conditions?

2007-09-30 Thread David Christopher Zentgraf
I'm seriously intrigued by the idea of trying postgres for this project... Thanks! On 30. Sep 2007, at 15:08, Rob Wultsch wrote: I am sorry for sending multiple notes. The reply to is set not being set to mysql discussion list. I click the reply button automatically. This email is for the

Restrict inserts to meet certain conditions?

2007-09-29 Thread David Zentgraf
Hi, Is it possible to restrict Inserts and Updates to meet certain conditions? In one of my tables lets say field A, B and C can be NULL, but not all at once. Depending on what type of item I want to store, A needs to be NULL, but B and C need values, for other types A needs a value but