Re: postgresql vs mysql - Mailing list pgsql-general

From CaT
Subject Re: postgresql vs mysql
Date
Msg-id 20070222032317.GG3107@zip.com.au
Whole thread Raw
In response to Re: postgresql vs mysql  (Chris <dmagick@gmail.com>)
List pgsql-general
On Thu, Feb 22, 2007 at 01:08:04PM +1100, Chris wrote:
> In postgres, to stop an empty blank string:
>
> create table a(a text not null check (char_length(a) > 0));

What's wrrong with using

a <> ''

sd the check? Or is this just a flavour thing?

--
    "To the extent that we overreact, we proffer the terrorists the
    greatest tribute."
        - High Court Judge Michael Kirby

pgsql-general by date:

Previous
From: RPK
Date:
Subject: Composite Keys
Next
From: Gene
Date:
Subject: how to tell if using unnamed paramaterized queries?