Re: Restrict inserts to meet certain conditions?

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

which does exist in mysql.

A trigger can be used to replicate this feature, in a less than ideal manner...

On 9/29/07, David Zentgraf <deceze@gmail.com> wrote:
> 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 B and C can be NULL etc.
> Is it possible to implement this checking logic on the database level
> via CONSTRAINTs or something similar?
>
> Best Regards,
> Dav
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=wultsch@gmail.com
>
>

-- 
Rob Wultsch
(480)223-2566
wultsch@gmail.com (email/google im)
wultsch (aim)
wultsch@hotmail.com (msn)

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com