Re: [BUGS] BUG #3056: strange behave of CHECK constraint

2007-02-22 Thread Peter Eisentraut
Pavel Stehule wrote: > check constraint doesn't work correct: There is nothing incorrect happening here. I think you are confused. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 7: You can help support t

Re: [BUGS] BUG #3056: strange behave of CHECK constraint

2007-02-22 Thread Douglas Toltzman
Is it just me, or did you reverse the sense of your check. In the first case, you select with "[^0-9]", but your constraint uses "[0-9]" without the carrot. On Feb 22, 2007, at 4:48 PM, Pavel Stehule wrote: The following bug has been logged online: Bug reference: 3056 Logged by: