Return-Path: X-Original-To: apmail-hawq-commits-archive@minotaur.apache.org Delivered-To: apmail-hawq-commits-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7536317D34 for ; Tue, 22 Sep 2015 19:14:44 +0000 (UTC) Received: (qmail 18020 invoked by uid 500); 22 Sep 2015 19:14:35 -0000 Delivered-To: apmail-hawq-commits-archive@hawq.apache.org Received: (qmail 17974 invoked by uid 500); 22 Sep 2015 19:14:34 -0000 Mailing-List: contact commits-help@hawq.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hawq.incubator.apache.org Delivered-To: mailing list commits@hawq.incubator.apache.org Received: (qmail 17965 invoked by uid 99); 22 Sep 2015 19:14:34 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Sep 2015 19:14:34 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 54FF5F62BB for ; Tue, 22 Sep 2015 19:14:34 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.802 X-Spam-Level: * X-Spam-Status: No, score=1.802 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RP_MATCHES_RCVD=0.001, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id PhgM5t01UNL6 for ; Tue, 22 Sep 2015 19:14:23 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with SMTP id E52D624D0D for ; Tue, 22 Sep 2015 19:14:06 +0000 (UTC) Received: (qmail 15523 invoked by uid 99); 22 Sep 2015 19:14:05 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Sep 2015 19:14:05 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 0DF04E01BA; Tue, 22 Sep 2015 19:14:05 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: rvs@apache.org To: commits@hawq.incubator.apache.org Date: Tue, 22 Sep 2015 19:14:20 -0000 Message-Id: <28be443f2e394b9e96e71d9db1e5a80f@git.apache.org> In-Reply-To: <3b95af7e5cc24c719e0ed93b00ba2af9@git.apache.org> References: <3b95af7e5cc24c719e0ed93b00ba2af9@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [17/35] incubator-hawq git commit: SGA import. Now with files previously missing because of the .gitignore issue http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a485be47/src/test/regress/data/upgrade34/pg_description33.data ---------------------------------------------------------------------- diff --git a/src/test/regress/data/upgrade34/pg_description33.data b/src/test/regress/data/upgrade34/pg_description33.data new file mode 100644 index 0000000..aeee19a --- /dev/null +++ b/src/test/regress/data/upgrade34/pg_description33.data @@ -0,0 +1,2094 @@ +objoid,classoid,objsubid,description +1242,1255,0,I/O +1243,1255,0,I/O +1244,1255,0,I/O +31,1255,0,I/O +1245,1255,0,I/O +33,1255,0,I/O +34,1255,0,I/O +35,1255,0,I/O +38,1255,0,I/O +39,1255,0,I/O +40,1255,0,I/O +41,1255,0,I/O +42,1255,0,I/O +43,1255,0,I/O +44,1255,0,I/O +45,1255,0,I/O +46,1255,0,I/O +47,1255,0,I/O +48,1255,0,I/O +49,1255,0,I/O +50,1255,0,I/O +51,1255,0,I/O +52,1255,0,I/O +53,1255,0,I/O +54,1255,0,I/O +55,1255,0,I/O +56,1255,0,less-than +57,1255,0,greater-than +60,1255,0,equal +61,1255,0,equal +62,1255,0,equal +63,1255,0,equal +64,1255,0,less-than +65,1255,0,equal +66,1255,0,less-than +67,1255,0,equal +68,1255,0,equal +69,1255,0,equal +70,1255,0,not equal +1246,1255,0,less-than +72,1255,0,less-than-or-equal +73,1255,0,greater-than +74,1255,0,greater-than-or-equal +77,1255,0,convert char to int4 +78,1255,0,convert int4 to char +79,1255,0,"matches regex., case-sensitive" +1252,1255,0,"does not match regex., case-sensitive" +1254,1255,0,"matches regex., case-sensitive" +1256,1255,0,"does not match regex., case-sensitive" +1257,1255,0,length +1258,1255,0,concatenate +84,1255,0,not equal +89,1255,0,PostgreSQL version string +101,1255,0,restriction selectivity of = and related operators +102,1255,0,restriction selectivity of <> and related operators +103,1255,0,restriction selectivity of < and related operators on scalar datatypes +104,1255,0,restriction selectivity of > and related operators on scalar datatypes +105,1255,0,join selectivity of = and related operators +106,1255,0,join selectivity of <> and related operators +107,1255,0,join selectivity of < and related operators on scalar datatypes +108,1255,0,join selectivity of > and related operators on scalar datatypes +109,1255,0,I/O +110,1255,0,I/O +112,1255,0,convert int4 to text +113,1255,0,convert int2 to text +114,1255,0,convert oid to text +115,1255,0,is above (allows touching) +116,1255,0,is below (allows touching) +117,1255,0,I/O +118,1255,0,I/O +119,1255,0,I/O +120,1255,0,I/O +121,1255,0,I/O +122,1255,0,I/O +123,1255,0,I/O +124,1255,0,I/O +125,1255,0,overlaps +126,1255,0,greater-than-or-equal by area +127,1255,0,greater-than by area +128,1255,0,equal by area +129,1255,0,less-than by area +130,1255,0,less-than-or-equal by area +131,1255,0,is above +132,1255,0,is left of +133,1255,0,is right of +134,1255,0,is below +135,1255,0,same as? +136,1255,0,point inside box? +137,1255,0,"point within closed path, or point on open path" +138,1255,0,center of +139,1255,0,restriction selectivity for area-comparison operators +140,1255,0,join selectivity for area-comparison operators +141,1255,0,multiply +144,1255,0,not equal +145,1255,0,not equal +146,1255,0,greater-than +147,1255,0,greater-than +148,1255,0,less-than-or-equal +149,1255,0,less-than-or-equal +150,1255,0,greater-than-or-equal +151,1255,0,greater-than-or-equal +152,1255,0,multiply +153,1255,0,divide +154,1255,0,divide +155,1255,0,modulus +156,1255,0,modulus +157,1255,0,not equal +158,1255,0,equal +159,1255,0,equal +160,1255,0,less-than +161,1255,0,less-than +162,1255,0,greater-than +163,1255,0,greater-than +164,1255,0,not equal +165,1255,0,not equal +166,1255,0,less-than-or-equal +167,1255,0,less-than-or-equal +168,1255,0,greater-than-or-equal +169,1255,0,greater-than-or-equal +170,1255,0,multiply +171,1255,0,multiply +172,1255,0,divide +173,1255,0,divide +174,1255,0,modulus +175,1255,0,modulus +176,1255,0,add +177,1255,0,add +178,1255,0,add +179,1255,0,add +180,1255,0,subtract +181,1255,0,subtract +182,1255,0,subtract +183,1255,0,subtract +184,1255,0,equal +185,1255,0,not equal +186,1255,0,same as? +187,1255,0,contains? +188,1255,0,is left of +189,1255,0,overlaps or is left of +190,1255,0,overlaps or is right of +191,1255,0,is right of +192,1255,0,is contained by? +200,1255,0,I/O +201,1255,0,I/O +202,1255,0,multiply +203,1255,0,divide +204,1255,0,add +205,1255,0,subtract +206,1255,0,negate +207,1255,0,absolute value +208,1255,0,aggregate transition function +6024,1255,0,aggregate inverse transition function +3106,1255,0,aggregate transition function +3107,1255,0,aggregate inverse transition function +209,1255,0,larger of two +211,1255,0,smaller of two +212,1255,0,negate +213,1255,0,negate +214,1255,0,I/O +215,1255,0,I/O +216,1255,0,multiply +217,1255,0,divide +218,1255,0,add +219,1255,0,subtract +220,1255,0,negate +221,1255,0,absolute value +222,1255,0,aggregate transition function +6025,1255,0,aggregate inverse transition function +3108,1255,0,aggregate transition function +3109,1255,0,aggregate inverse transition function +223,1255,0,larger of two +224,1255,0,smaller of two +225,1255,0,center of +226,1255,0,center of +227,1255,0,center of +228,1255,0,round to nearest integer +229,1255,0,truncate to integer +2308,1255,0,smallest integer >= value +2320,1255,0,smallest integer >= value +2309,1255,0,largest integer <= value +2310,1255,0,sign of value +230,1255,0,square root +231,1255,0,cube root +232,1255,0,exponentiation (x^y) +233,1255,0,natural exponential (e^x) +234,1255,0,natural logarithm +235,1255,0,convert int2 to float8 +236,1255,0,convert int2 to float4 +237,1255,0,convert float8 to int2 +238,1255,0,convert float4 to int2 +239,1255,0,distance between +240,1255,0,I/O +241,1255,0,I/O +242,1255,0,I/O +243,1255,0,I/O +244,1255,0,add +245,1255,0,subtract +246,1255,0,I/O +247,1255,0,I/O +248,1255,0,abstime in tinterval +249,1255,0,tinterval to reltime +250,1255,0,Current date and time (abstime) +251,1255,0,equal +252,1255,0,not equal +253,1255,0,less-than +254,1255,0,greater-than +255,1255,0,less-than-or-equal +256,1255,0,greater-than-or-equal +257,1255,0,equal +258,1255,0,not equal +259,1255,0,less-than +260,1255,0,greater-than +261,1255,0,less-than-or-equal +262,1255,0,greater-than-or-equal +263,1255,0,same as? +264,1255,0,contains? +265,1255,0,overlaps +266,1255,0,length equal +267,1255,0,length not equal to +268,1255,0,length less-than +269,1255,0,length greater-than +270,1255,0,length less-than-or-equal +271,1255,0,length greater-than-or-equal +272,1255,0,start of interval +273,1255,0,end of interval +274,1255,0,Current date and time - increments during transactions +275,1255,0,finite abstime? +277,1255,0,intersect? +278,1255,0,intersect? +279,1255,0,multiply +280,1255,0,divide +281,1255,0,add +282,1255,0,subtract +283,1255,0,multiply +284,1255,0,divide +285,1255,0,add +286,1255,0,subtract +287,1255,0,equal +288,1255,0,not equal +289,1255,0,less-than +290,1255,0,less-than-or-equal +291,1255,0,greater-than +292,1255,0,greater-than-or-equal +293,1255,0,equal +294,1255,0,not equal +295,1255,0,less-than +296,1255,0,less-than-or-equal +297,1255,0,greater-than +298,1255,0,greater-than-or-equal +299,1255,0,equal +300,1255,0,not equal +301,1255,0,less-than +302,1255,0,less-than-or-equal +303,1255,0,greater-than +304,1255,0,greater-than-or-equal +305,1255,0,equal +306,1255,0,not equal +307,1255,0,less-than +308,1255,0,less-than-or-equal +309,1255,0,greater-than +310,1255,0,greater-than-or-equal +311,1255,0,convert float4 to float8 +312,1255,0,convert float8 to float4 +313,1255,0,convert int2 to int4 +314,1255,0,convert int4 to int2 +315,1255,0,equal +316,1255,0,convert int4 to float8 +317,1255,0,convert float8 to int4 +318,1255,0,convert int4 to float4 +319,1255,0,convert float4 to int4 +330,1255,0,btree(internal) +636,1255,0,btree(internal) +331,1255,0,btree(internal) +333,1255,0,btree(internal) +334,1255,0,btree(internal) +335,1255,0,btree(internal) +336,1255,0,btree(internal) +337,1255,0,btree(internal) +338,1255,0,btree(internal) +332,1255,0,btree(internal) +972,1255,0,btree(internal) +1268,1255,0,btree(internal) +2785,1255,0,btree(internal) +339,1255,0,same as? +340,1255,0,contains? +341,1255,0,is left of +342,1255,0,overlaps or is left of +343,1255,0,overlaps or is right of +344,1255,0,is right of +345,1255,0,is contained by? +346,1255,0,overlaps +347,1255,0,I/O +348,1255,0,I/O +350,1255,0,btree less-equal-greater +351,1255,0,btree less-equal-greater +842,1255,0,btree less-equal-greater +354,1255,0,btree less-equal-greater +355,1255,0,btree less-equal-greater +356,1255,0,btree less-equal-greater +404,1255,0,btree less-equal-greater +357,1255,0,btree less-equal-greater +358,1255,0,btree less-equal-greater +359,1255,0,btree less-equal-greater +360,1255,0,btree less-equal-greater +377,1255,0,btree less-equal-greater +380,1255,0,btree less-equal-greater +381,1255,0,btree less-equal-greater +382,1255,0,btree less-equal-greater +361,1255,0,distance between +362,1255,0,intersection point +363,1255,0,distance between +364,1255,0,distance between point and box +365,1255,0,distance between segment and box +366,1255,0,closest point on line segment +367,1255,0,closest point on box +368,1255,0,closest point to line segment on box +369,1255,0,point contained in segment? +370,1255,0,distance between paths +371,1255,0,distance between point and path +372,1255,0,lseg contained in box? +373,1255,0,intersect? +401,1255,0,convert char(n) to text +406,1255,0,convert name to text +407,1255,0,convert text to name +408,1255,0,convert name to char(n) +409,1255,0,convert char(n) to name +440,1255,0,hash(internal) +637,1255,0,hash(internal) +441,1255,0,hash(internal) +443,1255,0,hash(internal) +444,1255,0,hash(internal) +445,1255,0,hash(internal) +446,1255,0,hash(internal) +447,1255,0,hash(internal) +448,1255,0,hash(internal) +442,1255,0,hash(internal) +425,1255,0,hash(internal) +438,1255,0,hash(internal) +2786,1255,0,hash(internal) +449,1255,0,hash +450,1255,0,hash +949,1255,0,hash +451,1255,0,hash +452,1255,0,hash +453,1255,0,hash +454,1255,0,hash +455,1255,0,hash +400,1255,0,hash +456,1255,0,hash any varlena type +457,1255,0,hash +329,1255,0,hash +398,1255,0,hash +399,1255,0,hash +422,1255,0,hash +6432,1255,0,hash +458,1255,0,larger of two +459,1255,0,smaller of two +460,1255,0,I/O +461,1255,0,I/O +462,1255,0,negate +463,1255,0,add +464,1255,0,subtract +465,1255,0,multiply +466,1255,0,divide +467,1255,0,equal +468,1255,0,not equal +469,1255,0,less-than +470,1255,0,greater-than +471,1255,0,less-than-or-equal +472,1255,0,greater-than-or-equal +474,1255,0,equal +475,1255,0,not equal +476,1255,0,less-than +477,1255,0,greater-than +478,1255,0,less-than-or-equal +479,1255,0,greater-than-or-equal +480,1255,0,convert int8 to int4 +481,1255,0,convert int4 to int8 +482,1255,0,convert int8 to float8 +483,1255,0,convert float8 to int8 +652,1255,0,convert int8 to float4 +653,1255,0,convert float4 to int8 +714,1255,0,convert int8 to int2 +754,1255,0,convert int2 to int8 +1285,1255,0,not in +1286,1255,0,not in +655,1255,0,less-than +656,1255,0,less-than-or-equal +657,1255,0,greater-than +658,1255,0,greater-than-or-equal +659,1255,0,not equal +668,1255,0,adjust char() to typmod length +669,1255,0,adjust varchar() to typmod length +676,1255,0,convert to tinterval +619,1255,0,not equal +677,1255,0,less-than +678,1255,0,less-than-or-equal +679,1255,0,equal +680,1255,0,greater-than-or-equal +681,1255,0,greater-than +710,1255,0,deprecated -- use current_user +716,1255,0,less-than +717,1255,0,less-than-or-equal +720,1255,0,octet length +721,1255,0,get byte +722,1255,0,set byte +723,1255,0,get bit +724,1255,0,set bit +725,1255,0,distance between point and line +726,1255,0,distance between line and box +727,1255,0,distance between lseg and line +728,1255,0,distance between +729,1255,0,distance between +740,1255,0,less-than +741,1255,0,less-than-or-equal +742,1255,0,greater-than +743,1255,0,greater-than-or-equal +745,1255,0,current user name +746,1255,0,session user name +744,1255,0,array equal +390,1255,0,array not equal +391,1255,0,array less than +392,1255,0,array greater than +393,1255,0,array less than or equal +396,1255,0,array greater than or equal +747,1255,0,array dimensions +750,1255,0,I/O +751,1255,0,I/O +2091,1255,0,array lower dimension +2092,1255,0,array upper dimension +378,1255,0,append element onto end of array +379,1255,0,prepend element onto front of array +383,1255,0,concatenate two arrays +384,1255,0,coerce array to another array type +394,1255,0,split delimited text into text[] +395,1255,0,"concatenate array elements, using delimiter, into text" +515,1255,0,larger of two +516,1255,0,smaller of two +6012,1255,0,itemwise add two integer arrays +760,1255,0,I/O +761,1255,0,I/O +762,1255,0,storage manager +763,1255,0,storage manager +764,1255,0,large object import +765,1255,0,large object export +766,1255,0,increment +768,1255,0,larger of two +769,1255,0,smaller of two +770,1255,0,larger of two +771,1255,0,smaller of two +774,1255,0,gist(internal) +638,1255,0,gist(internal) +775,1255,0,gist(internal) +777,1255,0,gist(internal) +778,1255,0,gist(internal) +779,1255,0,gist(internal) +780,1255,0,gist(internal) +781,1255,0,gist(internal) +782,1255,0,gist(internal) +776,1255,0,gist(internal) +2561,1255,0,gist(internal) +772,1255,0,gist(internal) +2787,1255,0,gist(internal) +784,1255,0,equal +785,1255,0,not equal +786,1255,0,less-than +787,1255,0,greater-than +788,1255,0,less-than-or-equal +789,1255,0,greater-than-or-equal +817,1255,0,convert text to oid +818,1255,0,convert text to int2 +819,1255,0,convert text to int4 +838,1255,0,convert text to float8 +839,1255,0,convert text to float4 +840,1255,0,convert float8 to text +841,1255,0,convert float4 to text +846,1255,0,multiply +847,1255,0,divide +848,1255,0,multiply +849,1255,0,return position of substring +850,1255,0,matches LIKE expression +851,1255,0,does not match LIKE expression +852,1255,0,equal +853,1255,0,not equal +854,1255,0,less-than +855,1255,0,greater-than +856,1255,0,less-than-or-equal +857,1255,0,greater-than-or-equal +858,1255,0,matches LIKE expression +859,1255,0,does not match LIKE expression +860,1255,0,convert char to char() +861,1255,0,returns the current database +862,1255,0,multiply +863,1255,0,multiply +864,1255,0,multiply +865,1255,0,divide +866,1255,0,multiply +867,1255,0,divide +886,1255,0,I/O +887,1255,0,I/O +888,1255,0,equal +889,1255,0,not equal +890,1255,0,less-than +891,1255,0,less-than-or-equal +892,1255,0,greater-than +893,1255,0,greater-than-or-equal +894,1255,0,add +895,1255,0,subtract +896,1255,0,multiply +897,1255,0,divide +898,1255,0,larger of two +899,1255,0,smaller of two +919,1255,0,multiply +935,1255,0,output amount as words +940,1255,0,modulus +941,1255,0,modulus +942,1255,0,modulus +943,1255,0,modulus +945,1255,0,modulus +947,1255,0,modulus +944,1255,0,convert text to char +946,1255,0,convert char to text +950,1255,0,bool is true (not false or unknown) +951,1255,0,bool is false (not true or unknown) +952,1255,0,large object open +953,1255,0,large object close +954,1255,0,large object read +955,1255,0,large object write +956,1255,0,large object seek +957,1255,0,large object create +715,1255,0,large object create +958,1255,0,large object position +828,1255,0,truncate large object +959,1255,0,point on line? +960,1255,0,lseg on line? +961,1255,0,closest point on line +962,1255,0,closest point to line segment on line +963,1255,0,closest point to line on box +964,1255,0,large object unlink(delete) +973,1255,0,intersect? +975,1255,0,box area +976,1255,0,box width +977,1255,0,box height +978,1255,0,distance between boxes +979,1255,0,area of a closed path +980,1255,0,box intersection (another box) +981,1255,0,box diagonal +982,1255,0,less-than +983,1255,0,greater-than +984,1255,0,equal +985,1255,0,less-than-or-equal +986,1255,0,greater-than-or-equal +987,1255,0,sum of path segment lengths +988,1255,0,not equal +989,1255,0,vertically aligned? +990,1255,0,horizontally aligned? +991,1255,0,distance between +992,1255,0,slope between points +993,1255,0,convert points to line segment +994,1255,0,intersect? +995,1255,0,parallel? +996,1255,0,perpendicular? +997,1255,0,vertical? +998,1255,0,horizontal? +999,1255,0,equal +748,1255,0,convert text to date +749,1255,0,convert date to text +837,1255,0,convert text to time +948,1255,0,convert time to text +938,1255,0,convert text to timetz +939,1255,0,convert timetz to text +1026,1255,0,adjust timestamp to new time zone +1029,1255,0,(internal) +1030,1255,0,(internal) +1031,1255,0,I/O +1032,1255,0,I/O +1035,1255,0,add/update ACL item +1036,1255,0,remove ACL item +1037,1255,0,ACL contains item? +1062,1255,0,equality operator for ACL items +1365,1255,0,make ACL item +1044,1255,0,I/O +1045,1255,0,I/O +1046,1255,0,I/O +1047,1255,0,I/O +1048,1255,0,equal +1049,1255,0,less-than +1050,1255,0,less-than-or-equal +1051,1255,0,greater-than +1052,1255,0,greater-than-or-equal +1053,1255,0,not equal +1063,1255,0,larger of two +1064,1255,0,smaller of two +1078,1255,0,less-equal-greater +1080,1255,0,hash +1081,1255,0,format a type oid and atttypmod to canonical SQL +1084,1255,0,I/O +1085,1255,0,I/O +1086,1255,0,equal +1087,1255,0,less-than +1088,1255,0,less-than-or-equal +1089,1255,0,greater-than +1090,1255,0,greater-than-or-equal +1091,1255,0,not equal +1092,1255,0,less-equal-greater +1102,1255,0,less-than +1103,1255,0,less-than-or-equal +1104,1255,0,greater-than +1105,1255,0,greater-than-or-equal +1106,1255,0,not equal +1107,1255,0,less-equal-greater +1138,1255,0,larger of two +1139,1255,0,smaller of two +1140,1255,0,subtract +1141,1255,0,add +1142,1255,0,subtract +1143,1255,0,I/O +1144,1255,0,I/O +1145,1255,0,equal +1146,1255,0,add +1147,1255,0,subtract +1148,1255,0,multiply +1149,1255,0,divide +1150,1255,0,I/O +1151,1255,0,I/O +1152,1255,0,equal +1153,1255,0,not equal +1154,1255,0,less-than +1155,1255,0,less-than-or-equal +1156,1255,0,greater-than-or-equal +1157,1255,0,greater-than +1158,1255,0,convert UNIX epoch to timestamptz +1159,1255,0,adjust timestamp to new time zone +1160,1255,0,I/O +1161,1255,0,I/O +1162,1255,0,equal +1163,1255,0,not equal +1164,1255,0,less-than +1165,1255,0,less-than-or-equal +1166,1255,0,greater-than-or-equal +1167,1255,0,greater-than +1168,1255,0,subtract +1169,1255,0,add +1170,1255,0,subtract +1171,1255,0,extract field from timestamp with time zone +1172,1255,0,extract field from interval +1173,1255,0,convert abstime to timestamp with time zone +1174,1255,0,convert date to timestamp with time zone +2711,1255,0,promote groups of 24 hours to numbers of days and promote groups of 30 days to numbers of months +1175,1255,0,promote groups of 24 hours to numbers of days +1295,1255,0,promote groups of 30 days to numbers of months +1176,1255,0,convert date and time to timestamp with time zone +1177,1255,0,convert reltime to interval +1178,1255,0,convert timestamp with time zone to date +1179,1255,0,convert abstime to date +1180,1255,0,convert timestamp with time zone to abstime +1181,1255,0,"age of a transaction ID, in transactions before current transaction" +1188,1255,0,subtract +1189,1255,0,plus +1190,1255,0,minus +1191,1255,0,convert text to timestamp with time zone +1192,1255,0,convert timestamp with time zone to text +1193,1255,0,convert interval to text +1194,1255,0,convert interval to reltime +1195,1255,0,smaller of two +1196,1255,0,larger of two +1197,1255,0,smaller of two +1198,1255,0,larger of two +1199,1255,0,date difference preserving months and years +1200,1255,0,adjust interval precision +1215,1255,0,get description for object id and catalog name +1216,1255,0,get description for table column +1993,1255,0,get description for object id and shared catalog name +1217,1255,0,truncate timestamp with time zone to specified units +1218,1255,0,truncate interval to specified units +1219,1255,0,increment +2804,1255,0,"increment, ignores second argument" +1230,1255,0,absolute value +1236,1255,0,larger of two +1237,1255,0,smaller of two +1238,1255,0,"matches regex., case-insensitive" +1239,1255,0,"does not match regex., case-insensitive" +1240,1255,0,"matches regex., case-insensitive" +1241,1255,0,"does not match regex., case-insensitive" +1251,1255,0,absolute value +1253,1255,0,absolute value +1263,1255,0,convert text to interval +1271,1255,0,SQL92 interval comparison +1272,1255,0,convert date and time to timestamp +1273,1255,0,extract field from time with time zone +1274,1255,0,add +1275,1255,0,subtract +1276,1255,0,multiply +1277,1255,0,divide +1278,1255,0,add +1279,1255,0,subtract +1280,1255,0,multiply +1281,1255,0,divide +1287,1255,0,convert int8 to oid +1288,1255,0,convert oid to int8 +1289,1255,0,convert int8 to text +1290,1255,0,convert text to int8 +1291,1255,0,adjust any array to new element typmod +1292,1255,0,equal +1293,1255,0,latest tid of a tuple +1294,1255,0,latest tid of a tuple +1265,1255,0,not equal +2790,1255,0,greater-than +2791,1255,0,less-than +2792,1255,0,greater-than-or-equal +2793,1255,0,less-than-or-equal +2794,1255,0,btree less-equal-greater +2795,1255,0,larger of two +2796,1255,0,smaller of two +1296,1255,0,convert time and date to timestamp +1297,1255,0,convert date and time with time zone to timestamp with time zone +1298,1255,0,convert time with time zone and date to timestamp with time zone +1299,1255,0,current transaction time +2647,1255,0,current transaction time +2648,1255,0,current statement time +2649,1255,0,current clock time +1300,1255,0,restriction selectivity for position-comparison operators +1301,1255,0,join selectivity for position-comparison operators +1302,1255,0,restriction selectivity for containment comparison operators +1303,1255,0,join selectivity for containment comparison operators +1304,1255,0,SQL92 interval comparison +1305,1255,0,SQL92 interval comparison +1306,1255,0,SQL92 interval comparison +1307,1255,0,SQL92 interval comparison +1308,1255,0,SQL92 interval comparison +1309,1255,0,SQL92 interval comparison +1310,1255,0,SQL92 interval comparison +1311,1255,0,SQL92 interval comparison +1312,1255,0,I/O +1313,1255,0,I/O +1314,1255,0,less-equal-greater +1315,1255,0,less-equal-greater +1316,1255,0,convert timestamp to time +1317,1255,0,length +1318,1255,0,character length +1319,1255,0,equal +1326,1255,0,divide +1339,1255,0,base 10 logarithm +1340,1255,0,base 10 logarithm +1341,1255,0,natural logarithm +1342,1255,0,round to nearest integer +1343,1255,0,truncate to integer +1344,1255,0,square root +1345,1255,0,cube root +1346,1255,0,exponentiation +1368,1255,0,exponentiation +1347,1255,0,exponential +1348,1255,0,get description for object id (deprecated) +1349,1255,0,print type names of oidvector field +1350,1255,0,I/O +1351,1255,0,I/O +1352,1255,0,equal +1353,1255,0,not equal +1354,1255,0,less-than +1355,1255,0,less-than-or-equal +1356,1255,0,greater-than-or-equal +1357,1255,0,greater-than +1358,1255,0,less-equal-greater +1359,1255,0,convert date and time with time zone to timestamp with time zone +1364,1255,0,convert abstime to time +1367,1255,0,character length +1369,1255,0,character length +1370,1255,0,convert time to interval +1372,1255,0,character length +1373,1255,0,coerce array to another type and adjust element typmod +1374,1255,0,octet length +1375,1255,0,octet length +1377,1255,0,larger of two +1378,1255,0,smaller of two +1379,1255,0,larger of two +1380,1255,0,smaller of two +1381,1255,0,character length +1382,1255,0,extract field from abstime +1383,1255,0,extract field from reltime +1384,1255,0,extract field from date +1385,1255,0,extract field from time +1386,1255,0,date difference from today preserving months and years +1388,1255,0,convert timestamptz to timetz +1389,1255,0,finite timestamp? +1390,1255,0,finite interval? +1376,1255,0,factorial +1394,1255,0,absolute value +1395,1255,0,absolute value +1396,1255,0,absolute value +1397,1255,0,absolute value +1398,1255,0,absolute value +1400,1255,0,convert varchar to name +1401,1255,0,convert name to varchar +1402,1255,0,current schema name +1403,1255,0,current schema search list +1404,1255,0,substitute portion of string +1405,1255,0,substitute portion of string +1406,1255,0,vertically aligned? +1407,1255,0,horizontally aligned? +1408,1255,0,parallel? +1409,1255,0,perpendicular? +1410,1255,0,vertical? +1411,1255,0,horizontal? +1412,1255,0,parallel? +1413,1255,0,perpendicular? +1414,1255,0,vertical? +1415,1255,0,horizontal? +1416,1255,0,center of +1417,1255,0,"bool is not true (ie, false or unknown)" +1418,1255,0,"bool is not false (ie, true or unknown)" +1419,1255,0,convert interval to time +1421,1255,0,convert points to box +1422,1255,0,add point to box (translate) +1423,1255,0,subtract point from box (translate) +1424,1255,0,multiply box by point (scale) +1425,1255,0,divide box by point (scale) +1426,1255,0,path contains point? +1428,1255,0,polygon contains point? +1429,1255,0,point contained in polygon? +1430,1255,0,path closed? +1431,1255,0,path open? +1432,1255,0,number of points in path +1433,1255,0,close path +1434,1255,0,open path +1435,1255,0,concatenate open paths +1436,1255,0,add (translate path) +1437,1255,0,subtract (translate path) +1438,1255,0,multiply (rotate/scale path) +1439,1255,0,divide (rotate/scale path) +1440,1255,0,"convert x, y to point" +1441,1255,0,add points (translate) +1442,1255,0,subtract points (translate) +1443,1255,0,multiply points (scale/rotate) +1444,1255,0,divide points (scale/rotate) +1445,1255,0,number of points in polygon +1446,1255,0,convert polygon to bounding box +1447,1255,0,convert polygon to path +1448,1255,0,convert box to polygon +1449,1255,0,convert path to polygon +1450,1255,0,I/O +1451,1255,0,I/O +1452,1255,0,same as? +1453,1255,0,contains? +1454,1255,0,is left of +1455,1255,0,overlaps or is left of +1456,1255,0,overlaps or is right of +1457,1255,0,is right of +1458,1255,0,is contained by? +1459,1255,0,overlaps +1460,1255,0,is below +1461,1255,0,is above +1462,1255,0,equal by area +1463,1255,0,not equal by area +1464,1255,0,less-than by area +1465,1255,0,greater-than by area +1466,1255,0,less-than-or-equal by area +1467,1255,0,greater-than-or-equal by area +1468,1255,0,area of circle +1469,1255,0,diameter of circle +1470,1255,0,radius of circle +1471,1255,0,distance between +1472,1255,0,center of +1473,1255,0,convert point and radius to circle +1474,1255,0,convert polygon to circle +1475,1255,0,convert vertex count and circle to polygon +1476,1255,0,distance between point and circle +1477,1255,0,circle contains point? +1478,1255,0,point contained in circle? +1479,1255,0,convert box to circle +1480,1255,0,convert circle to box +1481,1255,0,convert to tinterval +1482,1255,0,not equal +1483,1255,0,less-than by length +1484,1255,0,less-than-or-equal by length +1485,1255,0,greater-than by length +1486,1255,0,greater-than-or-equal by length +1487,1255,0,distance between endpoints +1488,1255,0,closest point to line on line segment +1489,1255,0,closest point to line segment on line segment +1490,1255,0,I/O +1491,1255,0,I/O +1492,1255,0,lines equal? +1493,1255,0,line from points +1494,1255,0,intersection point +1495,1255,0,intersect? +1496,1255,0,parallel? +1497,1255,0,perpendicular? +1498,1255,0,vertical? +1499,1255,0,horizontal? +1530,1255,0,distance between endpoints +1531,1255,0,sum of path segments +1532,1255,0,center of +1533,1255,0,center of +1534,1255,0,center of +1540,1255,0,center of +1541,1255,0,diagonal of +1542,1255,0,center of +1543,1255,0,center of +1544,1255,0,convert circle to 12-vertex polygon +1545,1255,0,number of points in path +1556,1255,0,number of points in polygon +1564,1255,0,I/O +1565,1255,0,I/O +1569,1255,0,matches LIKE expression +1570,1255,0,does not match LIKE expression +1571,1255,0,matches LIKE expression +1572,1255,0,does not match LIKE expression +1574,1255,0,sequence next value +1575,1255,0,sequence current value +1576,1255,0,set sequence value +1765,1255,0,set sequence value and iscalled status +1579,1255,0,I/O +1580,1255,0,I/O +1581,1255,0,equal +1582,1255,0,not equal +1592,1255,0,greater than or equal +1593,1255,0,greater than +1594,1255,0,less than or equal +1595,1255,0,less than +1596,1255,0,compare +1598,1255,0,random value +1599,1255,0,set random seed +1600,1255,0,arcsine +1601,1255,0,arccosine +1602,1255,0,arctangent +1603,1255,0,"arctangent, two arguments" +1604,1255,0,sine +1605,1255,0,cosine +1606,1255,0,tangent +1607,1255,0,cotangent +1608,1255,0,radians to degrees +1609,1255,0,degrees to radians +1610,1255,0,PI +1618,1255,0,multiply interval +1620,1255,0,convert first char to int4 +1621,1255,0,convert int4 to char +1622,1255,0,replicate string int4 times +1623,1255,0,convert SQL99 regexp pattern to POSIX style +1631,1255,0,matches LIKE expression +1632,1255,0,does not match LIKE expression +1633,1255,0,"matches LIKE expression, case-insensitive" +1634,1255,0,"does not match LIKE expression, case-insensitive" +1635,1255,0,"matches LIKE expression, case-insensitive" +1636,1255,0,"does not match LIKE expression, case-insensitive" +1637,1255,0,convert LIKE pattern to use backslash escapes +1656,1255,0,"matches regex., case-insensitive" +1657,1255,0,"does not match regex., case-insensitive" +1658,1255,0,"matches regex., case-sensitive" +1659,1255,0,"does not match regex., case-sensitive" +1660,1255,0,"matches LIKE expression, case-insensitive" +1661,1255,0,"does not match LIKE expression, case-insensitive" +1689,1255,0,update flat-file copy of a shared catalog +868,1255,0,find position of substring +870,1255,0,lowercase +871,1255,0,uppercase +872,1255,0,capitalize each word +873,1255,0,left-pad string to length +874,1255,0,right-pad string to length +875,1255,0,trim selected characters from left end of string +876,1255,0,trim selected characters from right end of string +877,1255,0,return portion of string +878,1255,0,map a set of character appearing in string +879,1255,0,left-pad string to length +880,1255,0,right-pad string to length +881,1255,0,trim spaces from left end of string +882,1255,0,trim spaces from right end of string +883,1255,0,return portion of string +884,1255,0,trim selected characters from both ends of string +885,1255,0,trim spaces from both ends of string +936,1255,0,return portion of string +937,1255,0,return portion of string +2087,1255,0,replace all occurrences of old_substr with new_substr in string +2284,1255,0,replace text using regexp +2285,1255,0,replace text using regexp +5018,1255,0,return all match groups for regexp +5019,1255,0,return all match groups for regexp +5020,1255,0,split string by pattern +5021,1255,0,split string by pattern +5022,1255,0,split string by pattern +5023,1255,0,split string by pattern +2088,1255,0,split string by field_sep and return field_num +2089,1255,0,convert int4 number to hex +2090,1255,0,convert int8 number to hex +1039,1255,0,encoding name of current database +810,1255,0,encoding name of current database +1717,1255,0,convert string with specified destination encoding name +1813,1255,0,convert string with specified encoding names +1619,1255,0,convert string with specified conversion name +1264,1255,0,convert encoding name to encoding id +1597,1255,0,convert encoding id to encoding name +1638,1255,0,greater-than +1639,1255,0,greater-than-or-equal +1573,1255,0,source text of a rule +1640,1255,0,select statement of a view +1641,1255,0,select statement of a view +1642,1255,0,role name by OID (with fallback) +1643,1255,0,index description +1662,1255,0,trigger description +1387,1255,0,constraint description +1716,1255,0,deparse an encoded expression +1665,1255,0,name of sequence for a serial column +5025,1255,0,partition configuration for a given relation +5028,1255,0,partition configuration for a given rule +1644,1255,0,referential integrity FOREIGN KEY ... REFERENCES +1645,1255,0,referential integrity FOREIGN KEY ... REFERENCES +1646,1255,0,referential integrity ON DELETE CASCADE +1647,1255,0,referential integrity ON UPDATE CASCADE +1648,1255,0,referential integrity ON DELETE RESTRICT +1649,1255,0,referential integrity ON UPDATE RESTRICT +1650,1255,0,referential integrity ON DELETE SET NULL +1651,1255,0,referential integrity ON UPDATE SET NULL +1652,1255,0,referential integrity ON DELETE SET DEFAULT +1653,1255,0,referential integrity ON UPDATE SET DEFAULT +1654,1255,0,referential integrity ON DELETE NO ACTION +1655,1255,0,referential integrity ON UPDATE NO ACTION +1666,1255,0,equal +1667,1255,0,not equal +1668,1255,0,greater than or equal +1669,1255,0,greater than +1670,1255,0,less than or equal +1671,1255,0,less than +1672,1255,0,compare +1673,1255,0,bitwise and +1674,1255,0,bitwise or +1675,1255,0,bitwise exclusive or +1676,1255,0,bitwise not +1677,1255,0,bitwise left shift +1678,1255,0,bitwise right shift +1679,1255,0,bitwise concatenation +1680,1255,0,return portion of bitstring +1681,1255,0,bitstring length +1682,1255,0,octet length +1683,1255,0,int4 to bitstring +1684,1255,0,bitstring to int4 +1685,1255,0,adjust bit() to typmod length +1687,1255,0,adjust varbit() to typmod length +1698,1255,0,return position of sub-bitstring +1699,1255,0,return portion of bitstring +436,1255,0,I/O +437,1255,0,I/O +752,1255,0,MAC address to text +753,1255,0,MAC manufacturer fields +767,1255,0,text to MAC address +830,1255,0,equal +831,1255,0,less-than +832,1255,0,less-than-or-equal +833,1255,0,greater-than +834,1255,0,greater-than-or-equal +835,1255,0,not equal +836,1255,0,less-equal-greater +910,1255,0,I/O +911,1255,0,I/O +1267,1255,0,I/O +1427,1255,0,I/O +920,1255,0,equal +921,1255,0,less-than +922,1255,0,less-than-or-equal +923,1255,0,greater-than +924,1255,0,greater-than-or-equal +925,1255,0,not equal +926,1255,0,less-equal-greater +927,1255,0,is-subnet +928,1255,0,is-subnet-or-equal +929,1255,0,is-supernet +930,1255,0,is-supernet-or-equal +598,1255,0,abbreviated display of inet value +599,1255,0,abbreviated display of cidr value +605,1255,0,change netmask of inet +635,1255,0,change netmask of cidr +711,1255,0,"address family (4 for IPv4, 6 for IPv6)" +683,1255,0,network part of address +696,1255,0,netmask of address +697,1255,0,netmask length +698,1255,0,broadcast address of network +699,1255,0,show address octets only +730,1255,0,show all parts of inet/cidr value +1362,1255,0,hostmask of address +1713,1255,0,text to inet +1714,1255,0,text to cidr +1715,1255,0,coerce inet to cidr +2196,1255,0,inet address of the client +2197,1255,0,client's port number for this connection +2198,1255,0,inet address of the server +2199,1255,0,server's port number for this connection +2627,1255,0,bitwise not +2628,1255,0,bitwise and +2629,1255,0,bitwise or +2630,1255,0,add integer to inet value +2631,1255,0,add integer to inet value +2632,1255,0,subtract integer from inet value +2633,1255,0,subtract inet values +1686,1255,0,(internal) +1688,1255,0,(internal) +1690,1255,0,minus +1691,1255,0,less-than-or-equal +1692,1255,0,greater-than-or-equal +1693,1255,0,btree less-equal-greater +1696,1255,0,hash +1697,1255,0,hash +1701,1255,0,I/O +1702,1255,0,I/O +1703,1255,0,adjust numeric to typmod precision/scale +1704,1255,0,absolute value +1705,1255,0,absolute value +1706,1255,0,sign of value +1707,1255,0,value rounded to 'scale' +1708,1255,0,value rounded to 'scale' of zero +1709,1255,0,value truncated to 'scale' +1710,1255,0,value truncated to 'scale' of zero +1711,1255,0,smallest integer >= value +2167,1255,0,smallest integer >= value +1712,1255,0,largest integer <= value +1718,1255,0,equal +1719,1255,0,not equal +1720,1255,0,greater-than +1721,1255,0,greater-than-or-equal +1722,1255,0,less-than +1723,1255,0,less-than-or-equal +1724,1255,0,add +1725,1255,0,subtract +1726,1255,0,multiply +1727,1255,0,divide +1728,1255,0,modulus +1729,1255,0,modulus +1730,1255,0,square root +1731,1255,0,square root +1732,1255,0,e raised to the power of n +1733,1255,0,e raised to the power of n +1734,1255,0,natural logarithm of n +1735,1255,0,natural logarithm of n +1736,1255,0,logarithm base m of n +1737,1255,0,logarithm base m of n +1738,1255,0,m raised to the power of n +2169,1255,0,m raised to the power of n +1739,1255,0,m raised to the power of n +1740,1255,0,(internal) +1741,1255,0,logarithm base 10 of n +1742,1255,0,(internal) +1743,1255,0,(internal) +1744,1255,0,(internal) +1745,1255,0,(internal) +1746,1255,0,(internal) +2170,1255,0,bucket number of operand in equidepth histogram +1747,1255,0,plus +1748,1255,0,minus +1749,1255,0,plus +1750,1255,0,minus +1764,1255,0,increment by one +1004,1255,0,increment by one +1766,1255,0,smaller of two numbers +1767,1255,0,larger of two numbers +1769,1255,0,compare two numbers +1771,1255,0,negate +1779,1255,0,(internal) +1781,1255,0,(internal) +1782,1255,0,(internal) +1783,1255,0,(internal) +1770,1255,0,format timestamp with time zone to text +1772,1255,0,format numeric to text +1773,1255,0,format int4 to text +1774,1255,0,format int8 to text +1775,1255,0,format float4 to text +1776,1255,0,format float8 to text +1777,1255,0,convert text to numeric +1778,1255,0,convert text to timestamp with time zone +1780,1255,0,convert text to date +1768,1255,0,format interval to text +1282,1255,0,quote an identifier for usage in a querystring +1283,1255,0,quote a literal for usage in a querystring +1798,1255,0,I/O +1799,1255,0,I/O +1810,1255,0,length in bits +1811,1255,0,length in bits +1812,1255,0,length in bits +1814,1255,0,restriction selectivity of ILIKE +1815,1255,0,restriction selectivity of NOT ILIKE +1816,1255,0,join selectivity of ILIKE +1817,1255,0,join selectivity of NOT ILIKE +1818,1255,0,restriction selectivity of regex match +1819,1255,0,restriction selectivity of LIKE +1820,1255,0,restriction selectivity of case-insensitive regex match +1821,1255,0,restriction selectivity of regex non-match +1822,1255,0,restriction selectivity of NOT LIKE +1823,1255,0,restriction selectivity of case-insensitive regex non-match +1824,1255,0,join selectivity of regex match +1825,1255,0,join selectivity of LIKE +1826,1255,0,join selectivity of case-insensitive regex match +1827,1255,0,join selectivity of regex non-match +1828,1255,0,join selectivity of NOT LIKE +1829,1255,0,join selectivity of case-insensitive regex non-match +1830,1255,0,AVG aggregate final function +2512,1255,0,VAR_POP aggregate final function +1831,1255,0,VAR_SAMP aggregate final function +2513,1255,0,STDDEV_POP aggregate final function +1832,1255,0,STDDEV_SAMP aggregate final function +1833,1255,0,aggregate transition function +3102,1255,0,aggregate transition function +7309,1255,0,aggregate inverse transition function +3103,1255,0,aggregate inverse transition function +1834,1255,0,aggregate transition function +1835,1255,0,aggregate transition function +1836,1255,0,aggregate transition function +7306,1255,0,aggregate inverse transition function +7307,1255,0,aggregate inverse transition function +7308,1255,0,aggregate inverse transition function +1837,1255,0,AVG aggregate final function +2514,1255,0,VAR_POP aggregate final function +1838,1255,0,VAR_SAMP aggregate final function +2596,1255,0,STDDEV_POP aggregate final function +1839,1255,0,STDDEV_SAMP aggregate final function +1840,1255,0,SUM(int2) transition function +1841,1255,0,SUM(int4) transition function +1842,1255,0,SUM(int8) transition function +7008,1255,0,SUM(int2) inverse transition function +7009,1255,0,SUM(int4) inverse transition function +7010,1255,0,SUM(int8) inverse transition function +1843,1255,0,aggregate transition function +6038,1255,0,aggregate inverse transition function +1844,1255,0,AVG aggregate final function +1962,1255,0,AVG(int2) transition function +1963,1255,0,AVG(int4) transition function +3100,1255,0,AVG(int8) transition function +6019,1255,0,AVG(int2) transition function +6020,1255,0,AVG(int4) transition function +3101,1255,0,AVG(int8) transition function +1964,1255,0,AVG(int) aggregate final function +2805,1255,0,"REGR_COUNT(double, double) transition function" +2806,1255,0,"REGR_...(double, double) transition function" +2807,1255,0,"REGR_SXX(double, double) aggregate final function" +2808,1255,0,"REGR_SYY(double, double) aggregate final function" +2809,1255,0,"REGR_SXY(double, double) aggregate final function" +2810,1255,0,"REGR_AVGX(double, double) aggregate final function" +2811,1255,0,"REGR_AVGY(double, double) aggregate final function" +2812,1255,0,"REGR_R2(double, double) aggregate final function" +2813,1255,0,"REGR_SLOPE(double, double) aggregate final function" +2814,1255,0,"REGR_INTERCEPT(double, double) aggregate final function" +2815,1255,0,"COVAR_POP(double, double) aggregate final function" +2816,1255,0,"COVAR_SAMP(double, double) aggregate final function" +2817,1255,0,"CORR(double, double) aggregate final function" +1845,1255,0,encode text from DB encoding to ASCII text +1846,1255,0,encode text from encoding to ASCII text +1847,1255,0,encode text from encoding to ASCII text +1848,1255,0,plus +1850,1255,0,equal +1851,1255,0,not equal +1852,1255,0,less-than +1853,1255,0,greater-than +1854,1255,0,less-than-or-equal +1855,1255,0,greater-than-or-equal +1856,1255,0,equal +1857,1255,0,not equal +1858,1255,0,less-than +1859,1255,0,greater-than +1860,1255,0,less-than-or-equal +1861,1255,0,greater-than-or-equal +1892,1255,0,bitwise and +1893,1255,0,bitwise or +1894,1255,0,bitwise xor +1895,1255,0,bitwise not +1896,1255,0,bitwise shift left +1897,1255,0,bitwise shift right +1898,1255,0,bitwise and +1899,1255,0,bitwise or +1900,1255,0,bitwise xor +1901,1255,0,bitwise not +1902,1255,0,bitwise shift left +1903,1255,0,bitwise shift right +1904,1255,0,bitwise and +1905,1255,0,bitwise or +1906,1255,0,bitwise xor +1907,1255,0,bitwise not +1908,1255,0,bitwise shift left +1909,1255,0,bitwise shift right +1910,1255,0,unary plus +1911,1255,0,unary plus +1912,1255,0,unary plus +1913,1255,0,unary plus +1914,1255,0,unary plus +1915,1255,0,unary plus +1922,1255,0,"user privilege on relation by username, rel name" +1923,1255,0,"user privilege on relation by username, rel oid" +1924,1255,0,"user privilege on relation by user oid, rel name" +1925,1255,0,"user privilege on relation by user oid, rel oid" +1926,1255,0,current user privilege on relation by rel name +1927,1255,0,current user privilege on relation by rel oid +1928,1255,0,Statistics: Number of scans done for table/index +1929,1255,0,Statistics: Number of tuples read by seqscan +1930,1255,0,Statistics: Number of tuples fetched by idxscan +1931,1255,0,Statistics: Number of tuples inserted +1932,1255,0,Statistics: Number of tuples updated +1933,1255,0,Statistics: Number of tuples deleted +1934,1255,0,Statistics: Number of blocks fetched +1935,1255,0,Statistics: Number of blocks found in cache +2781,1255,0,Statistics: Last manual vacuum time for a table +2782,1255,0,Statistics: Last auto vacuum time for a table +2783,1255,0,Statistics: Last manual analyze time for a table +2784,1255,0,Statistics: Last auto analyze time for a table +1936,1255,0,Statistics: Currently active backend IDs +2026,1255,0,Statistics: Current backend PID +2274,1255,0,Statistics: Reset collected statistics +1937,1255,0,Statistics: PID of backend +1938,1255,0,Statistics: Database ID of backend +1939,1255,0,Statistics: User ID of backend +1940,1255,0,Statistics: Current query of backend +2853,1255,0,Statistics: Is backend currently waiting for a lock +2094,1255,0,Statistics: Start time for current query of backend +1391,1255,0,Statistics: Start time for current backend session +1392,1255,0,Statistics: Address of client connected to backend +1393,1255,0,Statistics: Port number of client connected to backend +1941,1255,0,Statistics: Number of backends in database +1942,1255,0,Statistics: Transactions committed +1943,1255,0,Statistics: Transactions rolled back +1944,1255,0,Statistics: Blocks fetched for database +1945,1255,0,Statistics: Blocks found in cache for database +6031,1255,0,Statistics: Number of queries that executed in queue +6032,1255,0,Statistics: Number of queries that waited in queue +6033,1255,0,Statistics: Elapsed seconds for queries that executed in queue +6034,1255,0,Statistics: Elapsed seconds for queries that waited in queue +6039,1255,0,Statistics: Greenplum session id of backend +6042,1255,0,change priority of all the backends for a given session id +1946,1255,0,Convert bytea value into some ascii-only text string +1947,1255,0,Convert ascii-encoded text string into bytea value +1948,1255,0,equal +1949,1255,0,less-than +1950,1255,0,less-than-or-equal +1951,1255,0,greater-than +1952,1255,0,greater-than-or-equal +1953,1255,0,not equal +1954,1255,0,less-equal-greater +1961,1255,0,adjust timestamp precision +1965,1255,0,larger of two +1966,1255,0,smaller of two +1967,1255,0,adjust timestamptz precision +1968,1255,0,adjust time precision +1969,1255,0,adjust time with time zone precision +2005,1255,0,matches LIKE expression +2006,1255,0,does not match LIKE expression +2007,1255,0,matches LIKE expression +2008,1255,0,does not match LIKE expression +2009,1255,0,convert LIKE pattern to use backslash escapes +2010,1255,0,octet length +2011,1255,0,concatenate +2012,1255,0,return portion of string +2013,1255,0,return portion of string +2085,1255,0,return portion of string +2086,1255,0,return portion of string +2014,1255,0,return position of substring +2015,1255,0,trim both ends of string +2019,1255,0,convert timestamptz to time +2020,1255,0,truncate timestamp to specified units +2021,1255,0,extract field from timestamp +2022,1255,0,convert text to timestamp +2023,1255,0,convert abstime to timestamp +2024,1255,0,convert date to timestamp +2025,1255,0,convert date and time to timestamp +2027,1255,0,convert timestamp with time zone to timestamp +2028,1255,0,convert timestamp to timestamp with time zone +2029,1255,0,convert timestamp to date +2030,1255,0,convert timestamp to abstime +2031,1255,0,subtract +2032,1255,0,plus +2033,1255,0,minus +2034,1255,0,convert timestamp to text +2035,1255,0,smaller of two +2036,1255,0,larger of two +2037,1255,0,adjust time with time zone to new zone +2038,1255,0,adjust time with time zone to new zone +2041,1255,0,SQL92 interval comparison +2042,1255,0,SQL92 interval comparison +2043,1255,0,SQL92 interval comparison +2044,1255,0,SQL92 interval comparison +2045,1255,0,less-equal-greater +2046,1255,0,convert time with time zone to time +2047,1255,0,convert time to timetz +2048,1255,0,finite timestamp? +2049,1255,0,format timestamp to text +2052,1255,0,equal +2053,1255,0,not equal +2054,1255,0,less-than +2055,1255,0,less-than-or-equal +2056,1255,0,greater-than-or-equal +2057,1255,0,greater-than +2058,1255,0,date difference preserving months and years +2059,1255,0,date difference from today preserving months and years +2069,1255,0,adjust timestamp to new time zone +2070,1255,0,adjust timestamp to new time zone +2071,1255,0,add +2072,1255,0,subtract +2073,1255,0,extracts text matching regular expression +2074,1255,0,extracts text matching SQL99 regular expression +2075,1255,0,int8 to bitstring +2076,1255,0,bitstring to int8 +2077,1255,0,SHOW X as a function +2078,1255,0,SET X as a function +2084,1255,0,SHOW ALL as a function +1371,1255,0,view system lock information +1065,1255,0,view two-phase transactions +2079,1255,0,is table visible in search path? +2080,1255,0,is type visible in search path? +2081,1255,0,is function visible in search path? +2082,1255,0,is operator visible in search path? +2083,1255,0,is opclass visible in search path? +2093,1255,0,is conversion visible in search path? +2854,1255,0,"get OID of current session's temp schema, if any" +2855,1255,0,is schema another session's temp schema? +2171,1255,0,Cancel a server process' current query +2172,1255,0,Prepare for taking an online backup +2173,1255,0,Finish taking an online backup +2848,1255,0,Switch to new xlog file +2849,1255,0,current xlog write location +2852,1255,0,current xlog insert location +2850,1255,0,"xlog filename and byte offset, given an xlog location" +2851,1255,0,"xlog filename, given an xlog location" +2621,1255,0,Reload configuration files +2622,1255,0,Rotate log file +2623,1255,0,Return file information +2624,1255,0,Read text from a file +2625,1255,0,List all files in a directory +2626,1255,0,Sleep for the specified time in seconds +6030,1255,0,Return resource queue information +6045,1255,0,Read text from a file +6046,1255,0,Rotate log file +6047,1255,0,Write text to a file +6048,1255,0,Rename a file +6049,1255,0,Delete (unlink) a file +6050,1255,0,ls the log dir +6051,1255,0,Get the length of a file (via stat) +2212,1255,0,I/O +2213,1255,0,I/O +2214,1255,0,I/O +2215,1255,0,I/O +2216,1255,0,I/O +2217,1255,0,I/O +2218,1255,0,I/O +2219,1255,0,I/O +2220,1255,0,I/O +2221,1255,0,I/O +1079,1255,0,convert text to regclass +2246,1255,0,(internal) +2247,1255,0,(internal) +2248,1255,0,(internal) +2250,1255,0,"user privilege on database by username, database name" +2251,1255,0,"user privilege on database by username, database oid" +2252,1255,0,"user privilege on database by user oid, database name" +2253,1255,0,"user privilege on database by user oid, database oid" +2254,1255,0,current user privilege on database by database name +2255,1255,0,current user privilege on database by database oid +2256,1255,0,"user privilege on function by username, function name" +2257,1255,0,"user privilege on function by username, function oid" +2258,1255,0,"user privilege on function by user oid, function name" +2259,1255,0,"user privilege on function by user oid, function oid" +2260,1255,0,current user privilege on function by function name +2261,1255,0,current user privilege on function by function oid +2262,1255,0,"user privilege on language by username, language name" +2263,1255,0,"user privilege on language by username, language oid" +2264,1255,0,"user privilege on language by user oid, language name" +2265,1255,0,"user privilege on language by user oid, language oid" +2266,1255,0,current user privilege on language by language name +2267,1255,0,current user privilege on language by language oid +2268,1255,0,"user privilege on schema by username, schema name" +2269,1255,0,"user privilege on schema by username, schema oid" +2270,1255,0,"user privilege on schema by user oid, schema name" +2271,1255,0,"user privilege on schema by user oid, schema oid" +2272,1255,0,current user privilege on schema by schema name +2273,1255,0,current user privilege on schema by schema oid +2390,1255,0,"user privilege on tablespace by username, tablespace name" +2391,1255,0,"user privilege on tablespace by username, tablespace oid" +2392,1255,0,"user privilege on tablespace by user oid, tablespace name" +2393,1255,0,"user privilege on tablespace by user oid, tablespace oid" +2394,1255,0,current user privilege on tablespace by tablespace name +2395,1255,0,current user privilege on tablespace by tablespace oid +2705,1255,0,"user privilege on role by username, role name" +2706,1255,0,"user privilege on role by username, role oid" +2707,1255,0,"user privilege on role by user oid, role name" +2708,1255,0,"user privilege on role by user oid, role oid" +2709,1255,0,current user privilege on role by role name +2710,1255,0,current user privilege on role by role oid +1269,1255,0,"bytes required to store the value, perhaps with compression" +2322,1255,0,Calculate total disk space usage for the specified tablespace +2323,1255,0,Calculate total disk space usage for the specified tablespace +2324,1255,0,Calculate total disk space usage for the specified database +2168,1255,0,Calculate total disk space usage for the specified database +2325,1255,0,Calculate disk space usage for the specified table or index +2289,1255,0,Calculate disk space usage for the specified table or index +2286,1255,0,Calculate total disk space usage for the specified table and associated indexes and toast tables +2287,1255,0,Calculate total disk space usage for the specified table and associated indexes and toast tables +2288,1255,0,Convert a long int to a human readable text using size units +2290,1255,0,I/O +2291,1255,0,I/O +2292,1255,0,I/O +2293,1255,0,I/O +2294,1255,0,I/O +2295,1255,0,I/O +2296,1255,0,I/O +2297,1255,0,I/O +2298,1255,0,I/O +2299,1255,0,I/O +2300,1255,0,I/O +2301,1255,0,I/O +2302,1255,0,I/O +2303,1255,0,I/O +2304,1255,0,I/O +2305,1255,0,I/O +2306,1255,0,I/O +2307,1255,0,I/O +2312,1255,0,I/O +2313,1255,0,I/O +2398,1255,0,I/O +2399,1255,0,I/O +2597,1255,0,I/O +2598,1255,0,I/O +2311,1255,0,calculates md5 hash +2321,1255,0,calculates md5 hash +2338,1255,0,less-than +2339,1255,0,less-than-or-equal +2340,1255,0,equal +2341,1255,0,greater-than +2342,1255,0,greater-than-or-equal +2343,1255,0,not equal +2344,1255,0,less-equal-greater +2351,1255,0,less-than +2352,1255,0,less-than-or-equal +2353,1255,0,equal +2354,1255,0,greater-than +2355,1255,0,greater-than-or-equal +2356,1255,0,not equal +2357,1255,0,less-equal-greater +2364,1255,0,less-than +2365,1255,0,less-than-or-equal +2366,1255,0,equal +2367,1255,0,greater-than +2368,1255,0,greater-than-or-equal +2369,1255,0,not equal +2370,1255,0,less-equal-greater +2377,1255,0,less-than +2378,1255,0,less-than-or-equal +2379,1255,0,equal +2380,1255,0,greater-than +2381,1255,0,greater-than-or-equal +2382,1255,0,not equal +2383,1255,0,less-equal-greater +2520,1255,0,less-than +2521,1255,0,less-than-or-equal +2522,1255,0,equal +2523,1255,0,greater-than +2524,1255,0,greater-than-or-equal +2525,1255,0,not equal +2526,1255,0,less-equal-greater +2527,1255,0,less-than +2528,1255,0,less-than-or-equal +2529,1255,0,equal +2530,1255,0,greater-than +2531,1255,0,greater-than-or-equal +2532,1255,0,not equal +2533,1255,0,less-equal-greater +2400,1255,0,I/O +2401,1255,0,I/O +2402,1255,0,I/O +2403,1255,0,I/O +2404,1255,0,I/O +2405,1255,0,I/O +2406,1255,0,I/O +2407,1255,0,I/O +2408,1255,0,I/O +2409,1255,0,I/O +2410,1255,0,I/O +2411,1255,0,I/O +2412,1255,0,I/O +2413,1255,0,I/O +2414,1255,0,I/O +2415,1255,0,I/O +2416,1255,0,I/O +2417,1255,0,I/O +2418,1255,0,I/O +2419,1255,0,I/O +2420,1255,0,I/O +2421,1255,0,I/O +2422,1255,0,I/O +2423,1255,0,I/O +2424,1255,0,I/O +2425,1255,0,I/O +2426,1255,0,I/O +2427,1255,0,I/O +2428,1255,0,I/O +2429,1255,0,I/O +2430,1255,0,I/O +2431,1255,0,I/O +2432,1255,0,I/O +2433,1255,0,I/O +2434,1255,0,I/O +2435,1255,0,I/O +2436,1255,0,I/O +2437,1255,0,I/O +2438,1255,0,I/O +2439,1255,0,I/O +2440,1255,0,I/O +2441,1255,0,I/O +2442,1255,0,I/O +2443,1255,0,I/O +2444,1255,0,I/O +2445,1255,0,I/O +2446,1255,0,I/O +2447,1255,0,I/O +2448,1255,0,I/O +2449,1255,0,I/O +2450,1255,0,I/O +2451,1255,0,I/O +2452,1255,0,I/O +2453,1255,0,I/O +2454,1255,0,I/O +2455,1255,0,I/O +2456,1255,0,I/O +2457,1255,0,I/O +2458,1255,0,I/O +2459,1255,0,I/O +2460,1255,0,I/O +2461,1255,0,I/O +2462,1255,0,I/O +2463,1255,0,I/O +2464,1255,0,I/O +2465,1255,0,I/O +2466,1255,0,I/O +2467,1255,0,I/O +2468,1255,0,I/O +2469,1255,0,I/O +2470,1255,0,I/O +2471,1255,0,I/O +2472,1255,0,I/O +2473,1255,0,I/O +2474,1255,0,I/O +2475,1255,0,I/O +2476,1255,0,I/O +2477,1255,0,I/O +2478,1255,0,I/O +2479,1255,0,I/O +2480,1255,0,I/O +2481,1255,0,I/O +2482,1255,0,I/O +2483,1255,0,I/O +2484,1255,0,I/O +2485,1255,0,I/O +2486,1255,0,I/O +2487,1255,0,I/O +2488,1255,0,I/O +2489,1255,0,I/O +2490,1255,0,I/O +2491,1255,0,I/O +2492,1255,0,I/O +2493,1255,0,I/O +2494,1255,0,I/O +2495,1255,0,I/O +2496,1255,0,I/O +2497,1255,0,I/O +2498,1255,0,I/O +2499,1255,0,I/O +2500,1255,0,I/O +2501,1255,0,I/O +2502,1255,0,I/O +2503,1255,0,I/O +2504,1255,0,source text of a rule with pretty-print option +2505,1255,0,select statement of a view with pretty-print option +2506,1255,0,select statement of a view with pretty-print option +2507,1255,0,index description (full create statement or single expression) with pretty-print option +2508,1255,0,constraint description with pretty-print option +2509,1255,0,deparse an encoded expression with pretty-print option +2510,1255,0,get the prepared statements for this session +2511,1255,0,get the open cursors for this session +2599,1255,0,get the available time zone abbreviations +2856,1255,0,get the available time zone names +1066,1255,0,non-persistent series generator +1067,1255,0,non-persistent series generator +1068,1255,0,non-persistent series generator +1069,1255,0,non-persistent series generator +2515,1255,0,boolean-and aggregate transition function +2516,1255,0,boolean-or aggregate transition function +2517,1255,0,boolean-and aggregate +2518,1255,0,boolean-or aggregate +2519,1255,0,boolean-and aggregate +2236,1255,0,bitwise-and smallint aggregate +2237,1255,0,bitwise-or smallint aggregate +2238,1255,0,bitwise-and integer aggregate +2239,1255,0,bitwise-or integer aggregate +2240,1255,0,bitwise-and bigint aggregate +2241,1255,0,bitwise-or bigint aggregate +2242,1255,0,bitwise-and bit aggregate +2243,1255,0,bitwise-or bit aggregate +2556,1255,0,returns database oids in a tablespace +2557,1255,0,convert int4 to boolean +2558,1255,0,convert boolean to int4 +2559,1255,0,current value from last used sequence +2560,1255,0,postmaster start time +2562,1255,0,is below +2563,1255,0,overlaps or is below +2564,1255,0,overlaps or is above +2565,1255,0,is above +2566,1255,0,is below +2567,1255,0,overlaps or is below +2568,1255,0,overlaps or is above +2569,1255,0,is above +2587,1255,0,overlaps or is below +2588,1255,0,overlaps or is above +2578,1255,0,GiST support +2579,1255,0,GiST support +2580,1255,0,GiST support +2581,1255,0,GiST support +2582,1255,0,GiST support +2583,1255,0,GiST support +2584,1255,0,GiST support +2585,1255,0,GiST support +2586,1255,0,GiST support +2591,1255,0,GiST support +2592,1255,0,GiST support +2730,1255,0,gin(internal) +2731,1255,0,gin(internal) +2732,1255,0,gin(internal) +2733,1255,0,gin(internal) +2734,1255,0,gin(internal) +2735,1255,0,gin(internal) +2736,1255,0,gin(internal) +2737,1255,0,gin(internal) +2738,1255,0,gin(internal) +2739,1255,0,gin(internal) +2740,1255,0,gin(internal) +2741,1255,0,gin(internal) +2788,1255,0,gin(internal) +3200,1255,0,transpose a two dimensional matrix +3201,1255,0,perform matrix multiplication on two matrices +3202,1255,0,perform matrix multiplication on two matrices +3203,1255,0,perform matrix multiplication on two matrices +3204,1255,0,perform matrix multiplication on two matrices +3205,1255,0,multiply a matrix by a scalar value +3206,1255,0,multiply a matrix by a scalar value +3208,1255,0,perform matrix addition on two conformable matrices +3209,1255,0,perform matrix addition on two conformable matrices +3210,1255,0,perform matrix addition on two conformable matrices +3211,1255,0,perform matrix addition on two conformable matrices +3212,1255,0,perform matrix addition on two conformable matrices +3213,1255,0,perform matrix addition on two conformable matrices +3214,1255,0,perform matrix addition on two conformable matrices +3215,1255,0,perform matrix addition on two conformable matrices +6003,1255,0,launch mpp backup on outboard Postgres instances +6004,1255,0,launch mpp restore on outboard Postgres instances +6005,1255,0,read mpp backup file on outboard Postgres instances +6006,1255,0,write mpp backup file on outboard Postgres instances +6007,1255,0,view mpp pgdatabase state +6008,1255,0,aggregate preliminary function +3104,1255,0,aggregate preliminary function +6009,1255,0,aggregate preliminary function +6010,1255,0,aggregate preliminary function +3111,1255,0,aggregate preliminary function +6011,1255,0,aggregate preliminary function +6015,1255,0,aggregate inverse preliminary function +3105,1255,0,aggregate inverse preliminary function +6016,1255,0,aggregate preliminary function +3110,1255,0,aggregate inverse preliminary function +6018,1255,0,aggregate preliminary function +6021,1255,0,convert tid to int8 +6022,1255,0,segment executing function +6023,1255,0,Highest oid used so far +6035,1255,0,view mpp distributed transaction state +6036,1255,0,Highest distributed transaction id used so far +6037,1255,0,Current distributed transaction id +6043,1255,0,view logged local transaction status +6044,1255,0,view logged distributed transaction status +7100,1255,0,window immediate function +7101,1255,0,window immediate function +7102,1255,0,window immediate function +7204,1255,0,window preliminary function +7205,1255,0,window preliminary function +7206,1255,0,window preliminary function +7207,1255,0,window preliminary function +7303,1255,0,window final function +7304,1255,0,window final function +7305,1255,0,window final function +7169,1255,0,show append only table tuple distribution across segment databases +7170,1255,0,show append only table tuple distribution across segment databases +7171,1255,0,show append only table compression ratio +7172,1255,0,show append only table compression ratio +7173,1255,0,append only tables utility function +7174,1255,0,append only tables utility function +2743,1255,0,GIN array support +2744,1255,0,GIN array support +2747,1255,0,overlaps +2748,1255,0,contains +2749,1255,0,is contained by +2880,1255,0,obtain exclusive advisory lock +2881,1255,0,obtain shared advisory lock +2882,1255,0,obtain exclusive advisory lock if available +2883,1255,0,obtain shared advisory lock if available +2884,1255,0,release exclusive advisory lock +2885,1255,0,release shared advisory lock +2886,1255,0,obtain exclusive advisory lock +2887,1255,0,obtain shared advisory lock +2888,1255,0,obtain exclusive advisory lock if available +2889,1255,0,obtain shared advisory lock if available +2890,1255,0,release exclusive advisory lock +2891,1255,0,release shared advisory lock +2892,1255,0,release all advisory locks +3050,1255,0,bitmap(internal) +3051,1255,0,bitmap(internal) +3001,1255,0,bitmap(internal) +3002,1255,0,bitmap(internal) +3003,1255,0,bitmap(internal) +3004,1255,0,bitmap(internal) +3005,1255,0,bitmap(internal) +3006,1255,0,bitmap(internal) +3007,1255,0,bitmap(internal) +3008,1255,0,bitmap(internal) +3010,1255,0,bitmap(internal) +3011,1255,0,btree(internal) +16,1247,0,"boolean, 'true'/'false'" +17,1247,0,"variable-length string, binary values escaped" +18,1247,0,single character +19,1247,0,63-character type for storing system identifiers +20,1247,0,"~18 digit integer, 8-byte storage" +21,1247,0,"-32 thousand to 32 thousand, 2-byte storage" +22,1247,0,"array of int2, used in system tables" +23,1247,0,"-2 billion to 2 billion integer, 4-byte storage" +24,1247,0,registered procedure +25,1247,0,"variable-length string, no limit specified" +26,1247,0,"object identifier(oid), maximum 4 billion" +27,1247,0,"(Block, offset), physical location of tuple" +28,1247,0,transaction id +29,1247,0,"command identifier type, sequence in transaction id" +30,1247,0,"array of oids, used in system tables" +210,1247,0,storage manager +600,1247,0,"geometric point '(x, y)'" +601,1247,0,"geometric line segment '(pt1,pt2)'" +602,1247,0,"geometric path '(pt1,...)'" +603,1247,0,"geometric box '(lower left,upper right)'" +604,1247,0,"geometric polygon '(pt1,...)'" +628,1247,0,geometric line (not implemented)' +700,1247,0,"single-precision floating point number, 4-byte storage" +701,1247,0,"double-precision floating point number, 8-byte storage" +702,1247,0,"absolute, limited-range date and time (Unix system time)" +703,1247,0,"relative, limited-range time interval (Unix delta time)" +704,1247,0,"(abstime,abstime), time interval" +718,1247,0,"geometric circle '(center,radius)'" +790,1247,0,"monetary amounts, $d,ddd.cc" +829,1247,0,"XX:XX:XX:XX:XX:XX, MAC address" +869,1247,0,"IP address/netmask, host address, netmask optional" +650,1247,0,"network IP address/netmask, network address" +1033,1247,0,access control list +1042,1247,0,"char(length), blank-padded string, fixed storage length" +1043,1247,0,"varchar(length), non-blank-padded string, variable storage length" +1082,1247,0,ANSI SQL date +1083,1247,0,"hh:mm:ss, ANSI SQL time" +1114,1247,0,date and time +1184,1247,0,date and time with time zone +1186,1247,0,"@ , time interval" +1266,1247,0,"hh:mm:ss, ANSI SQL time" +1560,1247,0,fixed-length bit string +1562,1247,0,variable-length bit string +1700,1247,0,"numeric(precision, decimal), arbitrary precision number" +1790,1247,0,reference cursor (portal name) +2202,1247,0,registered procedure (with args) +2203,1247,0,registered operator +2204,1247,0,registered operator (with args) +2205,1247,0,registered class +2206,1247,0,registered type +403,2601,0,b-tree index access method +405,2601,0,hash index access method +783,2601,0,GiST index access method +2742,2601,0,GIN index access method +3013,2601,0,bitmap index access method +12,2612,0,Built-in functions +13,2612,0,Dynamically-loaded C functions +14,2612,0,SQL-language functions +11,2615,0,System catalog schema +99,2615,0,Reserved schema for TOAST tables +3012,2615,0,Reserved schema for internal relations of bitmap indexes +2200,2615,0,Standard public schema +6104,2615,0,Reserved schema for Append Only segment list and eof tables +10439,1255,0,internal conversion function for SQL_ASCII to MULE_INTERNAL +10440,2607,0,conversion for SQL_ASCII to MULE_INTERNAL +10441,1255,0,internal conversion function for MULE_INTERNAL to SQL_ASCII +10442,2607,0,conversion for MULE_INTERNAL to SQL_ASCII +10443,1255,0,internal conversion function for KOI8R to MULE_INTERNAL +10444,2607,0,conversion for KOI8R to MULE_INTERNAL +10445,1255,0,internal conversion function for MULE_INTERNAL to KOI8R +10446,2607,0,conversion for MULE_INTERNAL to KOI8R +10447,1255,0,internal conversion function for ISO-8859-5 to MULE_INTERNAL +10448,2607,0,conversion for ISO-8859-5 to MULE_INTERNAL +10449,1255,0,internal conversion function for MULE_INTERNAL to ISO-8859-5 +10450,2607,0,conversion for MULE_INTERNAL to ISO-8859-5 +10451,1255,0,internal conversion function for WIN1251 to MULE_INTERNAL +10452,2607,0,conversion for WIN1251 to MULE_INTERNAL +10453,1255,0,internal conversion function for MULE_INTERNAL to WIN1251 +10454,2607,0,conversion for MULE_INTERNAL to WIN1251 +10455,1255,0,internal conversion function for WIN866 to MULE_INTERNAL +10456,2607,0,conversion for WIN866 to MULE_INTERNAL +10457,1255,0,internal conversion function for MULE_INTERNAL to WIN866 +10458,2607,0,conversion for MULE_INTERNAL to WIN866 +10459,1255,0,internal conversion function for KOI8R to WIN1251 +10460,2607,0,conversion for KOI8R to WIN1251 +10461,1255,0,internal conversion function for WIN1251 to KOI8R +10462,2607,0,conversion for WIN1251 to KOI8R +10463,1255,0,internal conversion function for KOI8R to WIN866 +10464,2607,0,conversion for KOI8R to WIN866 +10465,1255,0,internal conversion function for WIN866 to KOI8R +10466,2607,0,conversion for WIN866 to KOI8R +10467,1255,0,internal conversion function for WIN866 to WIN1251 +10468,2607,0,conversion for WIN866 to WIN1251 +10469,1255,0,internal conversion function for WIN1251 to WIN866 +10470,2607,0,conversion for WIN1251 to WIN866 +10471,1255,0,internal conversion function for ISO-8859-5 to KOI8R +10472,2607,0,conversion for ISO-8859-5 to KOI8R +10473,1255,0,internal conversion function for KOI8R to ISO-8859-5 +10474,2607,0,conversion for KOI8R to ISO-8859-5 +10475,1255,0,internal conversion function for ISO-8859-5 to WIN1251 +10476,2607,0,conversion for ISO-8859-5 to WIN1251 +10477,1255,0,internal conversion function for WIN1251 to ISO-8859-5 +10478,2607,0,conversion for WIN1251 to ISO-8859-5 +10479,1255,0,internal conversion function for ISO-8859-5 to WIN866 +10480,2607,0,conversion for ISO-8859-5 to WIN866 +10481,1255,0,internal conversion function for WIN866 to ISO-8859-5 +10482,2607,0,conversion for WIN866 to ISO-8859-5 +10483,1255,0,internal conversion function for EUC_CN to MULE_INTERNAL +10484,2607,0,conversion for EUC_CN to MULE_INTERNAL +10485,1255,0,internal conversion function for MULE_INTERNAL to EUC_CN +10486,2607,0,conversion for MULE_INTERNAL to EUC_CN +10487,1255,0,internal conversion function for EUC_JP to SJIS +10488,2607,0,conversion for EUC_JP to SJIS +10489,1255,0,internal conversion function for SJIS to EUC_JP +10490,2607,0,conversion for SJIS to EUC_JP +10491,1255,0,internal conversion function for EUC_JP to MULE_INTERNAL +10492,2607,0,conversion for EUC_JP to MULE_INTERNAL +10493,1255,0,internal conversion function for SJIS to MULE_INTERNAL +10494,2607,0,conversion for SJIS to MULE_INTERNAL +10495,1255,0,internal conversion function for MULE_INTERNAL to EUC_JP +10496,2607,0,conversion for MULE_INTERNAL to EUC_JP +10497,1255,0,internal conversion function for MULE_INTERNAL to SJIS +10498,2607,0,conversion for MULE_INTERNAL to SJIS +10499,1255,0,internal conversion function for EUC_KR to MULE_INTERNAL +10500,2607,0,conversion for EUC_KR to MULE_INTERNAL +10501,1255,0,internal conversion function for MULE_INTERNAL to EUC_KR +10502,2607,0,conversion for MULE_INTERNAL to EUC_KR +10503,1255,0,internal conversion function for EUC_TW to BIG5 +10504,2607,0,conversion for EUC_TW to BIG5 +10505,1255,0,internal conversion function for BIG5 to EUC_TW +10506,2607,0,conversion for BIG5 to EUC_TW +10507,1255,0,internal conversion function for EUC_TW to MULE_INTERNAL +10508,2607,0,conversion for EUC_TW to MULE_INTERNAL +10509,1255,0,internal conversion function for BIG5 to MULE_INTERNAL +10510,2607,0,conversion for BIG5 to MULE_INTERNAL +10511,1255,0,internal conversion function for MULE_INTERNAL to EUC_TW +10512,2607,0,conversion for MULE_INTERNAL to EUC_TW +10513,1255,0,internal conversion function for MULE_INTERNAL to BIG5 +10514,2607,0,conversion for MULE_INTERNAL to BIG5 +10515,1255,0,internal conversion function for LATIN2 to MULE_INTERNAL +10516,2607,0,conversion for LATIN2 to MULE_INTERNAL +10517,1255,0,internal conversion function for MULE_INTERNAL to LATIN2 +10518,2607,0,conversion for MULE_INTERNAL to LATIN2 +10519,1255,0,internal conversion function for WIN1250 to MULE_INTERNAL +10520,2607,0,conversion for WIN1250 to MULE_INTERNAL +10521,1255,0,internal conversion function for MULE_INTERNAL to WIN1250 +10522,2607,0,conversion for MULE_INTERNAL to WIN1250 +10523,1255,0,internal conversion function for LATIN2 to WIN1250 +10524,2607,0,conversion for LATIN2 to WIN1250 +10525,1255,0,internal conversion function for WIN1250 to LATIN2 +10526,2607,0,conversion for WIN1250 to LATIN2 +10527,1255,0,internal conversion function for LATIN1 to MULE_INTERNAL +10528,2607,0,conversion for LATIN1 to MULE_INTERNAL +10529,1255,0,internal conversion function for MULE_INTERNAL to LATIN1 +10530,2607,0,conversion for MULE_INTERNAL to LATIN1 +10531,1255,0,internal conversion function for LATIN3 to MULE_INTERNAL +10532,2607,0,conversion for LATIN3 to MULE_INTERNAL +10533,1255,0,internal conversion function for MULE_INTERNAL to LATIN3 +10534,2607,0,conversion for MULE_INTERNAL to LATIN3 +10535,1255,0,internal conversion function for LATIN4 to MULE_INTERNAL +10536,2607,0,conversion for LATIN4 to MULE_INTERNAL +10537,1255,0,internal conversion function for MULE_INTERNAL to LATIN4 +10538,2607,0,conversion for MULE_INTERNAL to LATIN4 +10539,1255,0,internal conversion function for SQL_ASCII to UTF8 +10540,2607,0,conversion for SQL_ASCII to UTF8 +10541,1255,0,internal conversion function for UTF8 to SQL_ASCII +10542,2607,0,conversion for UTF8 to SQL_ASCII +10543,1255,0,internal conversion function for BIG5 to UTF8 +10544,2607,0,conversion for BIG5 to UTF8 +10545,1255,0,internal conversion function for UTF8 to BIG5 +10546,2607,0,conversion for UTF8 to BIG5 +10547,1255,0,internal conversion function for UTF8 to KOI8R +10548,2607,0,conversion for UTF8 to KOI8R +10549,1255,0,internal conversion function for KOI8R to UTF8 +10550,2607,0,conversion for KOI8R to UTF8 +10551,1255,0,internal conversion function for UTF8 to KOI8U +10552,2607,0,conversion for UTF8 to KOI8U +10553,1255,0,internal conversion function for KOI8U to UTF8 +10554,2607,0,conversion for KOI8U to UTF8 +10576,2607,0,conversion for WIN1257 to UTF8 +10556,2607,0,conversion for UTF8 to WIN866 +10555,1255,0,internal conversion function for UTF8 to WIN1258 +10558,2607,0,conversion for WIN866 to UTF8 +10577,2607,0,conversion for UTF8 to WIN1258 +10559,2607,0,conversion for UTF8 to WIN874 +10557,1255,0,internal conversion function for WIN1258 to UTF8 +10560,2607,0,conversion for WIN874 to UTF8 +10578,2607,0,conversion for WIN1258 to UTF8 +10561,2607,0,conversion for UTF8 to WIN1250 +10579,1255,0,internal conversion function for EUC_CN to UTF8 +10562,2607,0,conversion for WIN1250 to UTF8 +10580,2607,0,conversion for EUC_CN to UTF8 +10563,2607,0,conversion for UTF8 to WIN1251 +10581,1255,0,internal conversion function for UTF8 to EUC_CN +10564,2607,0,conversion for WIN1251 to UTF8 +10582,2607,0,conversion for UTF8 to EUC_CN +10565,2607,0,conversion for UTF8 to WIN1252 +10583,1255,0,internal conversion function for EUC_JP to UTF8 +10566,2607,0,conversion for WIN1252 to UTF8 +10584,2607,0,conversion for EUC_JP to UTF8 +10567,2607,0,conversion for UTF8 to WIN1253 +10585,1255,0,internal conversion function for UTF8 to EUC_JP +10568,2607,0,conversion for WIN1253 to UTF8 +10586,2607,0,conversion for UTF8 to EUC_JP +10569,2607,0,conversion for UTF8 to WIN1254 +10587,1255,0,internal conversion function for EUC_KR to UTF8 +10570,2607,0,conversion for WIN1254 to UTF8 +10588,2607,0,conversion for EUC_KR to UTF8 +10571,2607,0,conversion for UTF8 to WIN1255 +10589,1255,0,internal conversion function for UTF8 to EUC_KR +10572,2607,0,conversion for WIN1255 to UTF8 +10590,2607,0,conversion for UTF8 to EUC_KR +10573,2607,0,conversion for UTF8 to WIN1256 +10591,1255,0,internal conversion function for EUC_TW to UTF8 +10574,2607,0,conversion for WIN1256 to UTF8 +10592,2607,0,conversion for EUC_TW to UTF8 +10575,2607,0,conversion for UTF8 to WIN1257 +10593,1255,0,internal conversion function for UTF8 to EUC_TW +10594,2607,0,conversion for UTF8 to EUC_TW +10595,1255,0,internal conversion function for GB18030 to UTF8 +10596,2607,0,conversion for GB18030 to UTF8 +10597,1255,0,internal conversion function for UTF8 to GB18030 +10598,2607,0,conversion for UTF8 to GB18030 +10599,1255,0,internal conversion function for GBK to UTF8 +10600,2607,0,conversion for GBK to UTF8 +10601,1255,0,internal conversion function for UTF8 to GBK +10602,2607,0,conversion for UTF8 to GBK +10604,2607,0,conversion for UTF8 to LATIN2 +10606,2607,0,conversion for LATIN2 to UTF8 +10607,2607,0,conversion for UTF8 to LATIN3 +10608,2607,0,conversion for LATIN3 to UTF8 +10609,2607,0,conversion for UTF8 to LATIN4 +10610,2607,0,conversion for LATIN4 to UTF8 +10611,2607,0,conversion for UTF8 to LATIN5 +10612,2607,0,conversion for LATIN5 to UTF8 +10613,2607,0,conversion for UTF8 to LATIN6 +10614,2607,0,conversion for LATIN6 to UTF8 +10615,2607,0,conversion for UTF8 to LATIN7 +10616,2607,0,conversion for LATIN7 to UTF8 +10617,2607,0,conversion for UTF8 to LATIN8 +10618,2607,0,conversion for LATIN8 to UTF8 +10619,2607,0,conversion for UTF8 to LATIN9 +10620,2607,0,conversion for LATIN9 to UTF8 +10621,2607,0,conversion for UTF8 to LATIN10 +10622,2607,0,conversion for LATIN10 to UTF8 +10623,2607,0,conversion for UTF8 to ISO-8859-5 +10624,2607,0,conversion for ISO-8859-5 to UTF8 +10625,2607,0,conversion for UTF8 to ISO-8859-6 +10626,2607,0,conversion for ISO-8859-6 to UTF8 +10627,2607,0,conversion for UTF8 to ISO-8859-7 +10628,2607,0,conversion for ISO-8859-7 to UTF8 +10603,1255,0,internal conversion function for UTF8 to ISO-8859-8 +10629,2607,0,conversion for UTF8 to ISO-8859-8 +10605,1255,0,internal conversion function for ISO-8859-8 to UTF8 +10630,2607,0,conversion for ISO-8859-8 to UTF8 +10631,1255,0,internal conversion function for LATIN1 to UTF8 +10632,2607,0,conversion for LATIN1 to UTF8 +10633,1255,0,internal conversion function for UTF8 to LATIN1 +10634,2607,0,conversion for UTF8 to LATIN1 +10635,1255,0,internal conversion function for JOHAB to UTF8 +10636,2607,0,conversion for JOHAB to UTF8 +10637,1255,0,internal conversion function for UTF8 to JOHAB +10638,2607,0,conversion for UTF8 to JOHAB +10639,1255,0,internal conversion function for SJIS to UTF8 +10640,2607,0,conversion for SJIS to UTF8 +10641,1255,0,internal conversion function for UTF8 to SJIS +10642,2607,0,conversion for UTF8 to SJIS +10643,1255,0,internal conversion function for UHC to UTF8 +10644,2607,0,conversion for UHC to UTF8 +10645,1255,0,internal conversion function for UTF8 to UHC +10646,2607,0,conversion for UTF8 to UHC +10647,1255,0,internal conversion function for EUC_JIS_2004 to UTF8 +10648,2607,0,conversion for EUC_JIS_2004 to UTF8 +10649,1255,0,internal conversion function for UTF8 to EUC_JIS_2004 +10650,2607,0,conversion for UTF8 to EUC_JIS_2004 +10651,1255,0,internal conversion function for SHIFT_JIS_2004 to UTF8 +10652,2607,0,conversion for SHIFT_JIS_2004 to UTF8 +10653,1255,0,internal conversion function for UTF8 to SHIFT_JIS_2004 +10654,2607,0,conversion for UTF8 to SHIFT_JIS_2004 +10655,1255,0,internal conversion function for EUC_JIS_2004 to SHIFT_JIS_2004 +10656,2607,0,conversion for EUC_JIS_2004 to SHIFT_JIS_2004 +10657,1255,0,internal conversion function for SHIFT_JIS_2004 to EUC_JIS_2004 +10658,2607,0,conversion for SHIFT_JIS_2004 to EUC_JIS_2004 http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a485be47/src/test/regress/data/upgrade34/pg_index33.data ---------------------------------------------------------------------- diff --git a/src/test/regress/data/upgrade34/pg_index33.data b/src/test/regress/data/upgrade34/pg_index33.data new file mode 100644 index 0000000..9c5c241 --- /dev/null +++ b/src/test/regress/data/upgrade34/pg_index33.data @@ -0,0 +1,96 @@ +indexrelid,indrelid,indnatts,indisunique,indisprimary,indisclustered,indisvalid,indkey,indclass,indexprs,indpred +2831,2830,2,t,t,f,t,1 2,1989 1978,, +2833,2832,2,t,t,f,t,1 2,1989 1978,, +2835,2834,2,t,t,f,t,1 2,1989 1978,, +2837,2836,2,t,t,f,t,1 2,1989 1978,, +2839,2838,2,t,t,f,t,1 2,1989 1978,, +2841,2840,2,t,t,f,t,1 2,1989 1978,, +2843,2842,2,t,t,f,t,1 2,1989 1978,, +2845,2844,2,t,t,f,t,1 2,1989 1978,, +2847,2846,2,t,t,f,t,1 2,1989 1978,, +2650,2600,1,t,f,f,t,1,1989,, +2651,2601,1,t,f,f,t,1,1986,, +2652,2601,1,t,f,f,t,-2,1989,, +2653,2602,3,t,f,f,t,1 2 3,1989 1989 1976,, +2654,2602,2,t,f,f,t,5 1,1989 1989,, +2655,2603,3,t,f,f,t,1 2 3,1989 1989 1976,, +2656,2604,2,t,f,f,t,1 2,1989 1976,, +2657,2604,1,t,f,f,t,-2,1989,, +2658,1249,2,t,f,f,t,1 2,1989 1986,, +2659,1249,2,t,f,f,t,1 6,1989 1976,, +2676,1260,1,t,f,f,t,1,1986,, +2677,1260,1,t,f,f,t,-2,1989,, +2694,1261,2,t,f,f,t,1 2,1989 1989,, +2695,1261,2,t,f,f,t,2 1,1989 1989,, +6027,6026,1,t,f,f,t,-2,1989,, +6028,6026,1,t,f,f,t,1,1986,, +6041,6040,1,t,f,f,t,1,1989,, +1250,1248,1,t,f,f,t,1,1989,, +2660,2605,1,t,f,f,t,-2,1989,, +2661,2605,2,t,f,f,t,1 2,1989 1989,, +2662,1259,1,t,f,f,t,-2,1989,, +2663,1259,2,t,f,f,t,1 2,1986 1989,, +6029,1260,1,f,f,f,t,12,1989,, +2664,2606,2,f,f,f,t,1 2,1986 1989,, +2665,2606,1,f,f,f,t,6,1989,, +2666,2606,1,f,f,f,t,7,1989,, +2667,2606,1,t,f,f,t,-2,1989,, +2668,2607,4,t,f,f,t,2 4 5 -2,1989 1978 1978 1989,, +2669,2607,2,t,f,f,t,1 2,1986 1989,, +2670,2607,1,t,f,f,t,-2,1989,, +2671,1262,1,t,f,f,t,1,1986,, +2672,1262,1,t,f,f,t,-2,1989,, +2673,2608,3,f,f,f,t,1 2 3,1989 1989 1978,, +2674,2608,3,f,f,f,t,4 5 6,1989 1989 1978,, +2675,2609,3,t,f,f,t,1 2 3,1989 1989 1978,, +2397,2396,2,t,f,f,t,1 2,1989 1989,, +2678,2610,1,f,f,f,t,2,1989,, +2679,2610,1,t,f,f,t,1,1989,, +2680,2611,2,t,f,f,t,1 3,1989 1978,, +2681,2612,1,t,f,f,t,1,1986,, +2682,2612,1,t,f,f,t,-2,1989,, +2683,2613,2,t,f,f,t,1 2,1989 1978,, +2684,2615,1,t,f,f,t,1,1986,, +2685,2615,1,t,f,f,t,-2,1989,, +2686,2616,3,t,f,f,t,1 2 3,1989 1986 1989,, +2687,2616,1,t,f,f,t,-2,1989,, +2688,2617,1,t,f,f,t,-2,1989,, +2689,2617,4,t,f,f,t,1 6 7 2,1986 1989 1989 1989,, +1137,1136,1,t,f,f,t,1,1986,, +2690,1255,1,t,f,f,t,-2,1989,, +2691,1255,3,t,f,f,t,1 13 2,1986 1991 1989,, +2692,2618,1,t,f,f,t,-2,1989,, +2693,2618,2,t,f,f,t,2 1,1989 1986,, +1232,1214,3,f,f,f,t,1 2 3,1989 1989 1989,, +1233,1214,2,f,f,f,t,4 5,1989 1989,, +2696,2619,2,t,f,f,t,1 2,1989 1976,, +2697,1213,1,t,f,f,t,-2,1989,, +2698,1213,1,t,f,f,t,1,1986,, +2699,2620,1,f,f,f,t,7,1986,, +2700,2620,1,f,f,f,t,8,1989,, +2701,2620,2,t,f,f,t,1 2,1989 1986,, +2702,2620,1,t,f,f,t,-2,1989,, +2703,1247,1,t,f,f,t,-2,1989,, +2704,1247,2,t,f,f,t,1 2,1986 1989,, +6101,5000,2,t,f,f,t,1 2,1976 424,, +6102,5000,1,t,f,f,t,3,1976,, +6103,5002,1,t,f,f,t,1,1989,, +6108,5029,1,f,f,f,t,1,1976,, +6109,5030,1,t,f,f,t,1,1976,, +5005,5004,1,t,f,f,t,1,1989,, +5007,6105,1,t,f,f,t,1,1989,, +5012,5010,1,t,f,f,t,-2,1989,, +5017,5010,3,f,f,f,t,1 3 4,1989 1976 424,, +5013,5010,1,f,f,f,t,1,1989,, +5014,5011,1,t,f,f,t,-2,1989,, +5015,5011,3,f,f,f,t,2 3 6,1989 1989 1976,, +5016,5011,1,f,f,f,t,2,1989,, +5026,5011,3,f,f,f,t,1 3 6,1989 1989 1976,, +5031,6110,2,t,f,f,t,1 2,1989 1978,, +10763,10761,2,t,t,f,t,1 2,1989 1978,, +10768,10766,2,t,t,f,t,1 2,1989 1978,, +10773,10771,2,t,t,f,t,1 2,1989 1978,, +10778,10776,2,t,t,f,t,1 2,1989 1978,, +10783,10781,2,t,t,f,t,1 2,1989 1978,, +10788,10786,2,t,t,f,t,1 2,1989 1978,, +10793,10791,2,t,t,f,t,1 2,1989 1978,, http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a485be47/src/test/regress/data/upgrade34/pg_namespace33.data.in ---------------------------------------------------------------------- diff --git a/src/test/regress/data/upgrade34/pg_namespace33.data.in b/src/test/regress/data/upgrade34/pg_namespace33.data.in new file mode 100644 index 0000000..e67cd31 --- /dev/null +++ b/src/test/regress/data/upgrade34/pg_namespace33.data.in @@ -0,0 +1,7 @@ +oid,nspname,nspowner,nspacl +99,pg_toast,10, +3012,pg_bitmapindex,10, +6104,pg_aoseg,10, +11,pg_catalog,10,"{@gpcurusername@=UC/@gpcurusername@,=U/@gpcurusername@}" +2200,public,10,"{@gpcurusername@=UC/@gpcurusername@,=UC/@gpcurusername@}" +10659,information_schema,10,"{@gpcurusername@=UC/@gpcurusername@,=U/@gpcurusername@}"