📄 isn.sql

📁 PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开发团队说,该版本将加速更多企业向该数据库移植.核心开发成员之一Bruce Momjian表示,在新版PostgreSQL
💻 SQL
📖 第 1 页 / 共 5 页
字号:
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 = <>,
💿 文件大小 13119 K
👤 上传用户 sheng_xia
📂 所属分类 SQL Server
🏷️ 相关标签

#PostgreSQL #Momjian #Bruce #8.2
⌨️ 快捷键说明

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