/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; 201 SELECT (-9223372036854775808)::int8 % (-1)::int8; 231 FROM (VALUES (0::int8, 0::int8), 232 (0::int8, 29893644334::int8), 244 FROM (VALUES (0::int8, 0::int8), 245 (0::int8, 29893644334::int8), [all …]
|
/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 135 select '9223372036854775800'::int8 + '9223372036854775800'::int8; 138 select '9223372036854775800'::int8 - '-9223372036854775800'::int8; 139 select '-9223372036854775800'::int8 - '9223372036854775800'::int8; 141 select '9223372036854775800'::int8 * '9223372036854775800'::int8; 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 172 SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; [all …]
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 135 select '9223372036854775800'::int8 + '9223372036854775800'::int8; 138 select '9223372036854775800'::int8 - '-9223372036854775800'::int8; 139 select '-9223372036854775800'::int8 - '9223372036854775800'::int8; 141 select '9223372036854775800'::int8 * '9223372036854775800'::int8; 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 172 SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | int8.sql | 6 q1 int8, 7 q2 int8 537 '9223372036854775800'::int8 + '9223372036854775800'::int8; 543 '9223372036854775800'::int8 - '-9223372036854775800'::int8; 549 '9223372036854775800'::int8 * '9223372036854775800'::int8; 552 '9223372036854775800'::int8 / '0'::int8; 555 '9223372036854775800'::int8 % '0'::int8; 652 oid::int8 701 (-9223372036854775808)::int8 * (-1)::int8; 704 (-9223372036854775808)::int8 / (-1)::int8; [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 135 select '9223372036854775800'::int8 + '9223372036854775800'::int8; 138 select '9223372036854775800'::int8 - '-9223372036854775800'::int8; 139 select '-9223372036854775800'::int8 - '9223372036854775800'::int8; 141 select '9223372036854775800'::int8 * '9223372036854775800'::int8; 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 172 SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; [all …]
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 135 select '9223372036854775800'::int8 + '9223372036854775800'::int8; 138 select '9223372036854775800'::int8 - '-9223372036854775800'::int8; 139 select '-9223372036854775800'::int8 - '9223372036854775800'::int8; 141 select '9223372036854775800'::int8 * '9223372036854775800'::int8; 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 172 SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; [all …]
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 135 select '9223372036854775800'::int8 + '9223372036854775800'::int8; 138 select '9223372036854775800'::int8 - '-9223372036854775800'::int8; 139 select '-9223372036854775800'::int8 - '9223372036854775800'::int8; 141 select '9223372036854775800'::int8 * '9223372036854775800'::int8; 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 172 SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; [all …]
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 135 select '9223372036854775800'::int8 + '9223372036854775800'::int8; 138 select '9223372036854775800'::int8 - '-9223372036854775800'::int8; 139 select '-9223372036854775800'::int8 - '9223372036854775800'::int8; 141 select '9223372036854775800'::int8 * '9223372036854775800'::int8; 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 172 SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; [all …]
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 135 select '9223372036854775800'::int8 + '9223372036854775800'::int8; 138 select '9223372036854775800'::int8 - '-9223372036854775800'::int8; 139 select '-9223372036854775800'::int8 - '9223372036854775800'::int8; 141 select '9223372036854775800'::int8 * '9223372036854775800'::int8; 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 172 SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; [all …]
|
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 135 select '9223372036854775800'::int8 + '9223372036854775800'::int8; 138 select '9223372036854775800'::int8 - '-9223372036854775800'::int8; 139 select '-9223372036854775800'::int8 - '9223372036854775800'::int8; 141 select '9223372036854775800'::int8 * '9223372036854775800'::int8; 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 172 SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; [all …]
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 135 select '9223372036854775800'::int8 + '9223372036854775800'::int8; 138 select '9223372036854775800'::int8 - '-9223372036854775800'::int8; 139 select '-9223372036854775800'::int8 - '9223372036854775800'::int8; 141 select '9223372036854775800'::int8 * '9223372036854775800'::int8; 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 172 SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; [all …]
|
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
H A D | int8.sql | 5 CREATE TABLE INT8_TBL(q1 int8, q2 int8); 135 select '9223372036854775800'::int8 + '9223372036854775800'::int8; 138 select '9223372036854775800'::int8 - '-9223372036854775800'::int8; 139 select '-9223372036854775800'::int8 - '9223372036854775800'::int8; 141 select '9223372036854775800'::int8 * '9223372036854775800'::int8; 143 select '9223372036854775800'::int8 / '0'::int8; 144 select '9223372036854775800'::int8 % '0'::int8; 172 SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); 199 SELECT (-9223372036854775808)::int8 * (-1)::int8; 200 SELECT (-9223372036854775808)::int8 / (-1)::int8; [all …]
|