cancel
Showing results for 
Search instead for 
Did you mean: 

Postgresql Lookup on a float value

c_decoster
New Contributor

Hello,

I have a lookup snap that verify if a specific data exist in a specific table.
The type of the column is a float.
image

When I do the lookup :
image
and when I verify that the value (here “2”) exist in the column named “value” the lookup return me false. I guess it’s data type missmatch but I use the parseFloat method to get the matched data type.

What is the problem here? the database contains the value (image 1) and the output of the lookup condition value is 2 (image 2).

I verified that the name of the table and the column exist, that the value is in the DB.

Thanks,

Corentin

0 REPLIES 0