It works for me in v7beta:
hygea1=# create table tmp (
idhygea1(# id int,
hygea1(# first text);
CREATE
hygea1=# insert into tmp values(1,'one');
INSERT 120138 1
hygea1=# alter table tmp add column last text;
ALTER
hygea1=# update tmp set last='';
UPDATE 1
hygea1=# insert into tmp values(2,'two','two');
INSERT 120140 1
hygea1=# select * from tmp where last='two';
id | first | last
----+-------+------
2 | two | two
(1 row)
Wim Ceulemans wrote:
> hikmat farhat wrote:
> >
> > hi,
> > i having problems adding a column to table, for example
> > the postgres response is preceded with ">"
> >
> > create table tmp (
> > id int,
> > first text);
> > >CREATE
> >
> > insert into tmp values(1,'one');
> > >INSERT 356298 1
> >
> > alter table tmp add column last text;
> > >ADD
> >
> > update tmp set last=''; i though that this might do it, but no
> > >UPDATE 1
> >
> > insert into tmp values(2,'two','two');
> > >INSERT 356300 1
> >
> > select * from tmp where last='two'
> >
> > >ERROR: RestrictionClauseSensitivity: bad value -1.998613
> >
> > i tried to search the mailing lists but i couldn't find anything
> >
> > any ideas?
>
> It's working here with version 6.5.3. Which version are you using?
>
> Wim
--
Jose' Soares
Bologna, Italy [EMAIL PROTECTED]
