Re: boolean defaults

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: boolean defaults
Date: 2003-08-05 01:54:59
Message-ID: 1060048498.91190.32.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 2003-08-04 at 21:46, Christopher Kings-Lynne wrote:
> Hi,
>
> Is it possible to get a default value on a boolean column to be anything
> other than 't', 'f', true or false?

NULL of course :) 1 or 0 also works.

And regardless of how hard MS Access tries, -1 is not true.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-08-05 01:55:29 Re: boolean defaults
Previous Message Christopher Kings-Lynne 2003-08-05 01:46:15 boolean defaults