OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Restrict inserts to meet certain conditions?

From: David Christopher Zentgraf (decezegmail.com)
Date: Sun Sep 30 2007 - 02:09:05 CDT


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 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 <decezegmail.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=wultschgmail.com
>>
>>
>
>
> --
> Rob Wultsch
> (480)223-2566
> wultschgmail.com (email/google im)
> wultsch (aim)
> wultschhotmail.com (msn)
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=decezegmail.com
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql