Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNF98-00AMrD-5u for pgsql-sql@arkaria.postgresql.org; Tue, 09 Jan 2024 16:40:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rNF97-00EFwk-8c for pgsql-sql@arkaria.postgresql.org; Tue, 09 Jan 2024 16:40:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNF96-00EFwY-3E for pgsql-sql@lists.postgresql.org; Tue, 09 Jan 2024 16:40:08 +0000 Received: from mx0b-000e5c14.pphosted.com ([148.163.137.209]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNF91-000g91-6M for pgsql-sql@lists.postgresql.org; Tue, 09 Jan 2024 16:40:06 +0000 Received: from pps.filterd (m0206232.ppops.net [127.0.0.1]) by mx0a-000e5c14.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 409DKnAR010454; Tue, 9 Jan 2024 10:39:59 -0600 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=express-scripts.com; h=from : to : date : message-id : references : in-reply-to : content-type : mime-version : subject; s=pod140124231234; bh=4/WL6eEnNkTieUQDaQ/PQyahxnLCtCYR+Aq6Cqz4+sM=; b=VcXJBy161gHp9G8AxQ4rtDB/eJPIcm0lcAKVIf9dlr/UWD2BI0xRkH3BT5FEmxs5Gl66 0WnFP4FGBsFQ+0mqWuiTro1yHhbRESjdYkl5YpMWvuvGg6VhB+KPLXftKSb2DdPFYp8Y fekkTX6/qar7ew9xGZ/qNFTSMwIghCqRqVxFaiyixchcGOqJ5IKL9V0C1A1EsAW3N+kJ rztiCogJ2XRv4iBz4zX06iohJ/SNqEbpJEtwywu6zrEY+ZaPm36XwbLAdNDh5OXzrLWY Lo3Zs9/CanuMPhwTRgwONu821w1YGQa+rF3lVdwovcwkL+bJ3vm37V0gHxRs7vwj52rp Ng== Received: from eiaappxp0012.gid.prd.globalcore.com (lyncav03.cigna.com [170.48.19.151]) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3vf52b06d7-3 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Tue, 09 Jan 2024 10:39:59 -0600 Received: from cvlappxp20753.internal.cigna.com (HELO PS2PW1012186.accounts.root.corp) ([10.36.52.89]) by EIAAPPXP0012.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 09 Jan 2024 16:39:58 +0000 Received: from PS2PW1012186.accounts.root.corp (10.221.225.154) by PS2PW1012186.accounts.root.corp (10.221.225.154) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1258.27; Tue, 9 Jan 2024 11:39:58 -0500 Received: from PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad]) by PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad%6]) with mapi id 15.02.1258.027; Tue, 9 Jan 2024 11:39:58 -0500 From: "Wetmore, Matthew (CTR)" To: intmail01 , "pgsql-sql@lists.postgresql.org" Thread-Topic: [EXTERNAL] How to use one function which can be accessed for all schemas Thread-Index: AQHaQtOS8qS1GUTgY0Oay/GnEpsPr7DRrraQ Date: Tue, 9 Jan 2024 16:39:58 +0000 Message-ID: <5d61c61ce2574b969895d5a4b6ba2602@express-scripts.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.222.252.1] x-proofpoint-routing: 000e5c14 Content-Type: multipart/alternative; boundary="_000_5d61c61ce2574b969895d5a4b6ba2602expressscriptscom_" MIME-Version: 1.0 X-CFilter-Loop: Reflected Subject: How to use one function which can be accessed for all schemas X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.272,Aquarius:18.0.997,Hydra:6.0.619,FMLib:17.11.176.26 definitions=2024-01-09_08,2024-01-09_02,2023-05-22_02 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_5d61c61ce2574b969895d5a4b6ba2602expressscriptscom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 U2NoZW1hIHF1YWxpZnkgeW91ciBmdW5jdGlvbiBhbmQgdHJpZ2dlciBuYW1lcy4gIFNjaGVtYSBx dWFsaWZ5IGV2ZXJ5dGhpbmcsIGl04oCZcyBnb29kIHByYWN0aWNlIGFuZCBkb2VzbuKAmXQgbmVl ZCB0byByZWx5IG9uIHNlYXJjaF9wYXRoLg0KDQpUaGlzIGVycm9yIHNheSBleGFjdGx5IHRoYXQu DQoNCkNSRUFURSBGVU5DVElPTiB0ZXN0KOKApg0KDQpDUkVBVEUgRlVOQ1RJT04gbXlzY2hlbWEu dGVzdCgNCg0KRnJvbTogaW50bWFpbDAxIDxpbnRtYWlsMDFAZ21haWwuY29tPg0KU2VudDogVHVl c2RheSwgSmFudWFyeSA5LCAyMDI0IDEyOjE1IEFNDQpUbzogcGdzcWwtc3FsQGxpc3RzLnBvc3Rn cmVzcWwub3JnDQpTdWJqZWN0OiBbRVhURVJOQUxdIEhvdyB0byB1c2Ugb25lIGZ1bmN0aW9uIHdo aWNoIGNhbiBiZSBhY2Nlc3NlZCBmb3IgYWxsIHNjaGVtYXMNCg0KSGksDQoNCkkgaGF2ZSBzZXZl cmFsIHNjaGVtYXMgaW4gbXkgZGF0YWJhc2UsIEkgd2FudCB0byBjcmVhdGUganVzdCBvbmUgZnVu Y3Rpb24gdG8gdXNlIHdpdGggYWxsIHRoZXNlIHNjaGVtYS4NCkkgY3JlYXRlIHRoZSBmdW5jdGlv biBpbiBhIG1haW4gc2NoZW1hIHRoZW4gdGhlIHRyaWdnZXIgY2FsbCB0aGUgZnVuY3Rpb24gYW5k IGVycm9yIG9jY3VycyA6ICJObyBmdW5jdGlvbiBtYXRjaGVzIHRoZSBnaXZlbiBuYW1lIGFuZCBh cmd1bWVudCB0eXBlcy4gWW91IG1pZ2h0IG5lZWQgdG8gYWRkIGV4cGxpY2l0IHR5cGUgY2FzdHMu Ig0KDQpIb3cgdG8gdXNlIGp1c3Qgb25lIGZ1bmN0aW9uIHdoaWNoIGNhbiAgYmUgd29yayBhbW9u Z3N0IGFsbCBzaGVtYXMgaW4gdGhlIGRiID8NCk15IG9iamVjdGl2ZSBpcyB0byByZWR1Y2UgdXBk YXRlIG9mIGZ1bmN0aW9ucyBjb2RlIGp1c3Qgb25jZSBub3QgZm9yIG1hbnkgc2NoZW1hcy4gSSBk b250IHdhbnQgdG8gZHVwbGljYXRlIG15IGZ1bmN0aW9ucyBmb3IgZWFjaCBzY2hlbWEuDQoNClRo YW5rcw0K --_000_5d61c61ce2574b969895d5a4b6ba2602expressscriptscom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9 DQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCglj b2xvcjojMDU2M0MxOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBz cGFuLk1zb0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xv cjojOTU0RjcyOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KcC5tc29ub3JtYWwwLCBs aS5tc29ub3JtYWwwLCBkaXYubXNvbm9ybWFsMA0KCXttc28tc3R5bGUtbmFtZTptc29ub3JtYWw7 DQoJbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87DQoJbWFyZ2luLXJpZ2h0OjBpbjsNCgltc28tbWFy Z2luLWJvdHRvbS1hbHQ6YXV0bzsNCgltYXJnaW4tbGVmdDowaW47DQoJZm9udC1zaXplOjEyLjBw dDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9DQpzcGFuLkVtYWlsU3R5 bGUxOA0KCXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1yZXBseTsNCglmb250LWZhbWlseToiQ2Fs aWJyaSIsc2Fucy1zZXJpZjsNCgljb2xvcjojMUY0OTdEO30NCi5Nc29DaHBEZWZhdWx0DQoJe21z by1zdHlsZS10eXBlOmV4cG9ydC1vbmx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIixzYW5zLXNl cmlmO30NCkBwYWdlIFdvcmRTZWN0aW9uMQ0KCXtzaXplOjguNWluIDExLjBpbjsNCgltYXJnaW46 MS4waW4gMS4waW4gMS4waW4gMS4waW47fQ0KZGl2LldvcmRTZWN0aW9uMQ0KCXtwYWdlOldvcmRT ZWN0aW9uMTt9DQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVk ZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAyNiIgLz4NCjwveG1sPjwhW2VuZGlmXS0t PjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVsYXlvdXQgdjpleHQ9ImVkaXQiPg0K PG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQo8L286c2hhcGVsYXlvdXQ+PC94bWw+ PCFbZW5kaWZdLS0+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJFTi1VUyIgbGluaz0iIzA1NjNDMSIg dmxpbms9IiM5NTRGNzIiPg0KPGRpdiBjbGFzcz0iV29yZFNlY3Rpb24xIj4NCjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90 O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMUY0OTdEIj5TY2hlbWEgcXVhbGlmeSB5 b3VyIGZ1bmN0aW9uIGFuZCB0cmlnZ2VyIG5hbWVzLiZuYnNwOyBTY2hlbWEgcXVhbGlmeSBldmVy eXRoaW5nLCBpdOKAmXMgZ29vZCBwcmFjdGljZSBhbmQgZG9lc27igJl0IG5lZWQgdG8gcmVseSBv biBzZWFyY2hfcGF0aC48YnI+DQo8YnI+DQo8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFz cz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTom cXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+VGhpcyBlcnJvciBz YXkgZXhhY3RseSB0aGF0LjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3Jt YWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGli cmkmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMUY0OTdEIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bh bj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBw dDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3 RCI+Q1JFQVRFIEZVTkNUSU9OIHRlc3Qo4oCmPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xh c3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6 JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMxRjQ5N0QiPjxvOnA+Jm5ic3A7 PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250 LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtj b2xvcjojMUY0OTdEIj5DUkVBVEUgRlVOQ1RJT04gbXlzY2hlbWEudGVzdCg8bzpwPjwvbzpwPjwv c3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEx LjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFG NDk3RCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+ PGI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJy aSZxdW90OyxzYW5zLXNlcmlmIj5Gcm9tOjwvc3Bhbj48L2I+PHNwYW4gc3R5bGU9ImZvbnQtc2l6 ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmIj4gaW50 bWFpbDAxICZsdDtpbnRtYWlsMDFAZ21haWwuY29tJmd0Ow0KPGJyPg0KPGI+U2VudDo8L2I+IFR1 ZXNkYXksIEphbnVhcnkgOSwgMjAyNCAxMjoxNSBBTTxicj4NCjxiPlRvOjwvYj4gcGdzcWwtc3Fs QGxpc3RzLnBvc3RncmVzcWwub3JnPGJyPg0KPGI+U3ViamVjdDo8L2I+IFtFWFRFUk5BTF0gSG93 IHRvIHVzZSBvbmUgZnVuY3Rpb24gd2hpY2ggY2FuIGJlIGFjY2Vzc2VkIGZvciBhbGwgc2NoZW1h czxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7 PC9vOnA+PC9wPg0KPGRpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5IaSw8bzpwPjwv bzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7 PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+SSBoYXZlIHNl dmVyYWwgc2NoZW1hcyBpbiBteSBkYXRhYmFzZSwgSSB3YW50IHRvIGNyZWF0ZSBqdXN0IG9uZSBm dW5jdGlvbiB0byB1c2Ugd2l0aCBhbGwgdGhlc2Ugc2NoZW1hLjxvOnA+PC9vOnA+PC9wPg0KPC9k aXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+SSBjcmVhdGUgdGhlIGZ1bmN0aW9uIGlu IGEgbWFpbiBzY2hlbWEgdGhlbiB0aGUgdHJpZ2dlciBjYWxsIHRoZSBmdW5jdGlvbiBhbmQgZXJy b3Igb2NjdXJzIDogJnF1b3Q7Tm8gZnVuY3Rpb24gbWF0Y2hlcyB0aGUgZ2l2ZW4gbmFtZSBhbmQg YXJndW1lbnQgdHlwZXMuIFlvdSBtaWdodCBuZWVkIHRvIGFkZCBleHBsaWNpdCB0eXBlIGNhc3Rz LiZxdW90OzxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1h bCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9y bWFsIj5Ib3cgdG8gdXNlIGp1c3Qgb25lIGZ1bmN0aW9uIHdoaWNoIGNhbiZuYnNwOyBiZSB3b3Jr IGFtb25nc3QgYWxsIHNoZW1hcyBpbiB0aGUgZGIgPzxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8 ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+TXkgb2JqZWN0aXZlIGlzIHRvIHJlZHVjZSB1cGRh dGUgb2YgZnVuY3Rpb25zIGNvZGUganVzdCBvbmNlIG5vdCBmb3IgbWFueSBzY2hlbWFzLiBJIGRv bnQgd2FudCB0byBkdXBsaWNhdGUgbXkgZnVuY3Rpb25zIGZvciBlYWNoIHNjaGVtYS48bzpwPjwv bzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7 PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+VGhhbmtzPG86 cD48L286cD48L3A+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2JvZHk+DQo8L2h0bWw+DQo= --_000_5d61c61ce2574b969895d5a4b6ba2602expressscriptscom_--