0/1 vs true/false - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject 0/1 vs true/false
Date
Msg-id 3F1E2F3E.5030402@mega-bucks.co.jp
Whole thread Raw
Responses Re: 0/1 vs true/false  (Chris Travers <chris@travelamericas.com>)
Re: 0/1 vs true/false  (Peter Eisentraut <peter_e@gmx.net>)
List 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


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: String Comparison / Embedded Spaces
Next
From: Ben
Date:
Subject: birthday calculation