Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
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
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:
> 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:
>> Is it possible to restrict Inserts and Updates to meet certain
>> 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,
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?
> Rob Wultsch
> 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