File: float.sql

package info (click to toggle)
postgresql-filedump 17.4-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 420 kB
  • sloc: ansic: 3,554; sql: 152; perl: 118; sh: 24; makefile: 23
file content (16 lines) | stat: -rw-r--r-- 599 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
-- 64 bit output in *.out, 32 bit output in *_3.out
-- PG12+ output in *.out/*_3.out, earlier in *_1.out/*_4.out

select oid as datoid from pg_database where datname = current_database() \gset

----------------------------------------------------------------------------------------------

create table float4 (x float4);
insert into float4 values (0), ('-0'), ('-infinity'), ('infinity'), ('NaN'), (null);
\set relname float4
\ir run_test.sql

create table float8 (x float8);
insert into float8 values (0), ('-0'), ('-infinity'), ('infinity'), ('NaN'), (null);
\set relname float8
\ir run_test.sql