Thread: TODO question

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

> 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

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