File: numeric.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 (12 lines) | stat: -rw-r--r-- 509 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
-- 64 bit output in *.out, 32 bit output in *_3.out
-- PG14+ 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 numeric (x numeric);
insert into numeric values (0), ('12341234'), ('-567890'), ('NaN'), (null);
insert into numeric values ('-Infinity'), ('Infinity'); -- needs PG 14
\set relname numeric
\ir run_test.sql