isn.sql

来自「PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开」· SQL 代码 · 共 3,103 行 · 第 1/5 页

SQL
3,103
字号
CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = ismn13,	RIGHTARG = ismn13,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = ismn13,	RIGHTARG = ismn13,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = ismn13,	RIGHTARG = ismn,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = ismn13,	RIGHTARG = ismn,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = ismn13,	RIGHTARG = ismn,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = ismn13,	RIGHTARG = ismn,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = ismn13,	RIGHTARG = ismn,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = ismn13,	RIGHTARG = ismn,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);---- ISMN operators:-----------------------------------------------------CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = ismn,	RIGHTARG = ismn,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = ismn,	RIGHTARG = ismn,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = ismn,	RIGHTARG = ismn,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel,	HASHES);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = ismn,	RIGHTARG = ismn,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = ismn,	RIGHTARG = ismn,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = ismn,	RIGHTARG = ismn,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = ismn,	RIGHTARG = ismn13,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = ismn,	RIGHTARG = ismn13,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = ismn,	RIGHTARG = ismn13,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = ismn,	RIGHTARG = ismn13,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = ismn,	RIGHTARG = ismn13,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = ismn,	RIGHTARG = ismn13,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = ismn,	RIGHTARG = ean13,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = ismn,	RIGHTARG = ean13,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = ismn,	RIGHTARG = ean13,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = ismn,	RIGHTARG = ean13,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = ismn,	RIGHTARG = ean13,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = ismn,	RIGHTARG = ean13,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);---- ISSN13 operators:-----------------------------------------------------CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = issn13,	RIGHTARG = issn13,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = issn13,	RIGHTARG = issn13,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = issn13,	RIGHTARG = issn13,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel,	HASHES);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = issn13,	RIGHTARG = issn13,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = issn13,	RIGHTARG = issn13,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = issn13,	RIGHTARG = issn13,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = issn13,	RIGHTARG = issn,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = issn13,	RIGHTARG = issn,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = issn13,	RIGHTARG = issn,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = issn13,	RIGHTARG = issn,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = issn13,	RIGHTARG = issn,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = issn13,	RIGHTARG = issn,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = issn13,	RIGHTARG = ean13,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = issn13,	RIGHTARG = ean13,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = issn13,	RIGHTARG = ean13,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = issn13,	RIGHTARG = ean13,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = issn13,	RIGHTARG = ean13,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = issn13,	RIGHTARG = ean13,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);---- ISSN operators:-----------------------------------------------------CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = issn,	RIGHTARG = issn,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = issn,	RIGHTARG = issn,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = issn,	RIGHTARG = issn,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel,	HASHES);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = issn,	RIGHTARG = issn,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = issn,	RIGHTARG = issn,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = issn,	RIGHTARG = issn,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = issn,	RIGHTARG = issn13,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = issn,	RIGHTARG = issn13,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = issn,	RIGHTARG = issn13,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = issn,	RIGHTARG = issn13,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = issn,	RIGHTARG = issn13,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = issn,	RIGHTARG = issn13,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = issn,	RIGHTARG = ean13,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = issn,	RIGHTARG = ean13,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = issn,	RIGHTARG = ean13,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = issn,	RIGHTARG = ean13,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = issn,	RIGHTARG = ean13,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = issn,	RIGHTARG = ean13,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);---- UPC operators:-----------------------------------------------------CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = upc,	RIGHTARG = upc,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = upc,	RIGHTARG = upc,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = upc,	RIGHTARG = upc,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel,	HASHES);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = upc,	RIGHTARG = upc,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = upc,	RIGHTARG = upc,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = upc,	RIGHTARG = upc,	COMMUTATOR = <>,	NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);CREATE OPERATOR < (	PROCEDURE = isnlt,	LEFTARG = upc,	RIGHTARG = ean13,	COMMUTATOR = >,	NEGATOR = >=,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR <= (	PROCEDURE = isnle,	LEFTARG = upc,	RIGHTARG = ean13,	COMMUTATOR = >=,	NEGATOR = >,	RESTRICT = scalarltsel,	JOIN = scalarltjoinsel);CREATE OPERATOR = (	PROCEDURE = isneq,	LEFTARG = upc,	RIGHTARG = ean13,	COMMUTATOR = =,	NEGATOR = <>,	RESTRICT = eqsel,	JOIN = eqjoinsel);CREATE OPERATOR >= (	PROCEDURE = isnge,	LEFTARG = upc,	RIGHTARG = ean13,	COMMUTATOR = <=,	NEGATOR = <,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR > (	PROCEDURE = isngt,	LEFTARG = upc,	RIGHTARG = ean13,	COMMUTATOR = <,	NEGATOR = <=,	RESTRICT = scalargtsel,	JOIN = scalargtjoinsel );CREATE OPERATOR <> (	PROCEDURE = isnne,	LEFTARG = upc,	RIGHTARG = ean13,	COMMUTATOR = <>,

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?