Re: postgresql vs mysql

From: CaT <cat(at)zip(dot)com(dot)au>
To: Chris <dmagick(at)gmail(dot)com>
Cc: Erick Papadakis <erick(dot)papa(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql vs mysql
Date: 2007-02-22 03:23:18
Message-ID: 20070222032317.GG3107@zip.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2007-02-22 03:25:00 Re: postgresql vs mysql
Previous Message Alvaro Herrera 2007-02-22 03:21:37 Re: Row-Level Access Control via FK to pg_catalog.pg_authid