Home > mailing lists

Weird 'bit' type behaviour - Mailing list pgsql-hackers

From	Christopher Kings-Lynne
Subject	Weird 'bit' type behaviour
Date	June 14, 2004 03:00:00
Msg-id	40CD15A3.4030005@familyhealth.com.au Whole thread Raw
Responses	Re: Weird 'bit' type behaviour (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-hackers

Is there any reason for this behaviour:

test=# select 1::bit; bit
----- 0
(1 row)

test=# select '1'::bit; bit
----- 1
(1 row)

Chris

From: Oliver Jowett
Date: 14 June 2004, 02:00:11
Subject: Re: Delaying the planning of unnamed statements until Bind

From: Christopher Kings-Lynne
Date: 14 June 2004, 03:07:18
Subject: Other bit oddities