Re: How to implement Microsoft Access boolean (YESNO)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: "Jesper K(dot) Pedersen" <jkp(at)solnet(dot)homeip(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to implement Microsoft Access boolean (YESNO)
Date: 2006-01-24 14:59:01
Message-ID: 18437.1138114741@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Greg Stark <gsstark(at)mit(dot)edu> writes:
> Is there an implicit cast from ints? So if I pass a 0 or 1 argument for a
> boolean parameter now it'll work? That definitely didn't work in the past.

1. There's a cast. 2. It's not implicit. 3. You have always (well,
at least since 7.0 which is the oldest version I have alive to check)
been able to write '0' or '1' as the input textual representation of
bool. The latter has nothing to do with any integer coercion though.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message codeWarrior 2006-01-24 16:08:59 Re: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ?
Previous Message PFC 2006-01-24 10:14:58 Re: How to implement Microsoft Access boolean (YESNO)