On Thu, 7 Mar 2002, Patrick Hatcher wrote:
> I have table defined as such:
>
> Create Table t1
> (
> f1 int,
> f2 numeric (13,2)
> )
>
> insert into t1 values (1,12.22);
> insert into t1 values (2,12);
>
> if I do the following query I receive data:
>
> Select * from t1 where f2 = 12;
have to explicitly cast this:
select * from t1 where f2::int = 12
or
select * from t1 where f2 = 12::numeric
should work
--
Joel BURTON | joel(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant