This TODO-item "SELECT col FROM tab WHERE numeric_col = 10.1 fails, requires
quotes" - is it already fixed? I executed smth. like

select * from tab2 where dpcol = 10.1;

and it returns a record containing this value in the double precision column
"dpcol".

rgds
Pavlo Baron


Thu, 27 Dec 2001 22:09:14 +0100
"Pavlo Baron" <pb@pbit.org>
TODO question
> This TODO-item "SELECT col FROM tab WHERE numeric_col = 10.1 fails, requires
> quotes" - is it already fixed? ...

thomas=# create table t3 (n numeric);
CREATE
thomas=# select * from t3 where n = 10.1;
ERROR:  Unable to identify an operator '=' for types 'numeric' and
'double precision'
	You will have to retype this query using an explicit cast
thomas=# select * from t3 where n = '10.1';
 n 
---
(0 rows)


                   - Thomas

Thu, 27 Dec 2001 21:32:18 +0000
Thomas Lockhart <lockhart@fourpalms.org>
Re: TODO question
Thomas Lockhart:
> > This TODO-item "SELECT col FROM tab WHERE numeric_col = 10.1 fails,
requires
> > quotes" - is it already fixed? ...
>
> thomas=# create table t3 (n numeric);
> CREATE
> thomas=# select * from t3 where n = 10.1;
> ERROR:  Unable to identify an operator '=' for types 'numeric' and
> 'double precision'
> You will have to retype this query using an explicit cast
> thomas=# select * from t3 where n = '10.1';
>  n
> ---
> (0 rows)

oops, I should clean my eyeballs: my test case was:

create table t3 (n double precision);
select * from t3 where n = 10.1;
n
---
(0 rows)

the problem lies in the numeric field - let's see, if I find out where to
fix it

rgds
Pavlo Baron


Thu, 27 Dec 2001 22:50:21 +0100
"Pavlo Baron" <pb@pbit.org>
Re: TODO question