From: | Doug McNaught <doug(at)wireboard(dot)com> |
---|---|
To: | Terry Fielder <terry(at)greatgulfhomes(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Default value for bit datatype |
Date: | 2001-06-12 18:23:10 |
Message-ID: | m3r8wpr20h.fsf@belphigor.mcnaught.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Terry Fielder <terry(at)greatgulfhomes(dot)com> writes:
> When I try to do a default value for the bit datatype, eg:
> CREATE TABLE my_calendar (
> ID serial NOT NULL ,
> Global_field bit DEFAULT 0 NOT NULL ,
> )
>
> I get the message:
> ERROR: Attribute 'global_field' is of type 'bit' but default expression
> is of type 'int4'
> You will need to rewrite or cast the expression
>
> I have tried (bit) 0, bit(0), bit 0, etc but have not found a way to do
> casting. Can anyone help me to set a default value for a bit datatype
> field?
Try:
Global_field bit DEFAULT '0'::bit NOT NULL
Yes, it's a little weird. ;)
-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time... --Dylan
From | Date | Subject | |
---|---|---|---|
Next Message | Thalis A. Kalfigopoulos | 2001-06-12 18:25:42 | Re: select, where and null-values (or: select null<>'1' is fuzzy) |
Previous Message | Peter Eisentraut | 2001-06-12 18:22:06 | Re: select, where and null-values (or: select null<>'1' is fuzzy) |