Appropriate values for -Infinity & Infinity in Postgres

Question

In one of the cases we have to feed values for +infinity & -infinity in Postgres DB?

What should be appropriate value that should be considered.

If there is not 1, then please suggest the best suited.

Thank You

Answer 1

You can actually use +infinity and -infinity for FLOAT4 and FLOAT8 (i.e. float and double precision) data types, and for timestamps.

regress=> SELECT FLOAT8 '+infinity', FLOAT8 '-infinity';
  float8  |  float8   
----------+-----------
 Infinity | -Infinity
(1 row)

For other types, either use a separate column, use the minimum/maximum values for the type, or (where logically appropriate) use null.