datatype might change for constant float values
borisz opened this issue · 1 comments
borisz commented
Here is a short example of the odd behavior:
❯ psql -X postgres -c 'select 1/2, 1/2.'
?column? | ?column?
----------+------------------------
0 | 0.50000000000000000000
(1 row)
❯ pgpp -S 'select 1/2, 1/2.' | psql -X postgres
?column? | ?column?
----------+----------
0 | 0
(1 row)
lelit commented
Good catch, thank you for the report.