From: Joe <dev@freedomcircle.net>
To: Karthikeyan Sundaram <skarthi98@hotmail.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Urgent help in bit_string data type
Date: Wed, 11 Apr 2007 19:00:23 -0400
Message-ID: <1176332423.782.10.camel@pampa> (raw)
In-Reply-To: <BAY131-W421F946C7905459DCFE10B05F0@phx.gbl>
References: <BAY131-W421F946C7905459DCFE10B05F0@phx.gbl>
Hi skarthi,
On Wed, 2007-04-11 at 15:01 -0700, Karthikeyan Sundaram wrote:
> create table test_a (b bit(3));
>
> create view test_vw (b1, b2, b3)
> as select
> to_number(substring(b,1,1)::int,'9') as b1,
> to_number(substring(b,2,1)::int,'9') as b2,
> to_number(substring(b,3,1)::int,'9') as b3 from test_a;
>
> create or replace rule test_a_ins as on insert to test_vw
> do instead
> insert into test_a (b) values (COALESCE(new.b1::bit,'1')||
> COALESCE(new.b2::bit,'0')||COALESCE(new.b3::bit,'0')::bit);
>
> ERROR: cannot cast type numeric to bit
>
> How will I resolve this?
*My* question is why are you doing such convoluted conversions, from bit
string to text, then to int, etc.? It seems to me like you want to
manipulate bits and if that's the case, you should be using the bit
string operators, as someone pointed out a couple of days ago. In case
you haven't looked at them, please see:
http://www.postgresql.org/docs/8.2/static/functions-bitstring.html
Joe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@freedomcircle.net, skarthi98@hotmail.com, pgsql-admin@postgresql.org
Subject: Re: [SQL] Urgent help in bit_string data type
In-Reply-To: <1176332423.782.10.camel@pampa>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox