0/1 vs true/false

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Subject: 0/1 vs true/false
Date: 2003-07-23 06:46:22
Message-ID: 3F1E2F3E.5030402@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just having a small argument with an application developer ...

is using 0/1 for boolean types SQL compliant? I am trying to convince
him that the proper SQL compliant (and postgresql compliant) syntax is
true/false but he won't budge ...

The app as currently written no longer works with postgres because they
code uses 0/1 instead of the now enforced true/false for boolean types.

Can someone point me to an SQL spec and section where this is clearly
stated out?

Thanks,

Jean-Christian Imbeault

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2003-07-23 06:53:54 birthday calculation
Previous Message Stephan Szabo 2003-07-23 05:46:35 Re: String Comparison / Embedded Spaces