/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | numeric_big.sql | 19 DROP TABLE num_exp_log10; 64 CREATE TABLE num_exp_log10 ( table 934 INSERT INTO num_exp_log10 936 INSERT INTO num_exp_log10 938 INSERT INTO num_exp_log10 940 INSERT INTO num_exp_log10 942 INSERT INTO num_exp_log10 944 INSERT INTO num_exp_log10 946 INSERT INTO num_exp_log10 948 INSERT INTO num_exp_log10 [all …]
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | numeric_big.sql | 13 DROP TABLE num_exp_log10; 24 CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800)); table 462 INSERT INTO num_exp_log10 VALUES (0,'NaN'); 463 INSERT INTO num_exp_log10 VALUES (1,'4.930660740129727276654889314296515979425461685461970306647398… 464 INSERT INTO num_exp_log10 VALUES (2,'32.99776962038896508677496970451822209025838998767969189335190… 467 INSERT INTO num_exp_log10 VALUES (5,'8.814750626578650238811431417807018895270298639823442501111235… 470 INSERT INTO num_exp_log10 VALUES (8,'9.929264914121995501917993119394933531225401243275938207624866… 471 INSERT INTO num_exp_log10 VALUES (9,'7.739283354261751283625223433456284905560931805428759681411970… 508 CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id); 517 VACUUM ANALYZE num_exp_log10; [all …]
|