Zoltan Boszormenyi wrote:
I would do a CHECK (trim(a) <> '')
If you were ok with a string consisting soley of whitespace.
I meant NOT NULL CHECK(trim(a) <> ''), keeping the context of the
above example.
Right. I plead that it was late when i replied. I honestly don't know
what i was thinking.
trim() trims whitespace only from the beginning and the end of the
strings but not from the middle:
# select trim(' a b c ');
I realise that. I was thinking of this case:
select trim(' ');
Though, i'm not sure what my point was. Again, it was late. Carry on!
brian
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
