Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table dvbs_transponders (transponder_id  int, freq real)
insert into dvbs_transponders values (1, '11487.77')
1 rows affected

insert into dvbs_transponders values (1, '11487')
1 rows affected

select *
from dvbs_transponders
where freq = 11487


transponder_id
freq


1
11487


select *
from dvbs_transponders
where freq = 11487.77
select *
from dvbs_transponders
where freq = '11487.77'


transponder_id
freq


1
11487.77


select *
from dvbs_transponders
where freq = '11487'


transponder_id
freq


1
11487