Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o9p4f-00019P-Gp for pgsql-general@arkaria.postgresql.org; Fri, 08 Jul 2022 14:35:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o9p4e-0005Cn-1K for pgsql-general@arkaria.postgresql.org; Fri, 08 Jul 2022 14:35:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o9p4d-00057C-D6 for pgsql-general@lists.postgresql.org; Fri, 08 Jul 2022 14:35:15 +0000 Received: from sonic315-13.consmr.mail.bf2.yahoo.com ([74.6.134.123]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1o9p4W-0008KV-ON for pgsql-general@lists.postgresql.org; Fri, 08 Jul 2022 14:35:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aol.com; s=a2048; t=1657290906; bh=ZMkelqTot2ZVTo158M7ggYjcEPakrVt6QELIaagZ7HA=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=fvpY93lcfkmZH9wdGOizKntDH3UM4NHUKob9+wEdyevjCBy90TqxmxXwM4qgJcwgToGiPLbfaMzLMysfvLuj0xzd4tMzk4a3OnpvYATkuR5+lkrrxoYlr/iGrLM1BjdlYT6KZsyQ+nRLJQdVo90b1ZNHYjP3pu4Wez9Y1tFmKgM75VmBflE07pRGlU//bZ58VIa7/+EGiBhgjsvr7f9L18eMuUWDkReMIG9gpzv5dnx21uPbyvHzT7t8uhppHw6Ux0250lfJDwhAtvxYtcZnCQk2Jk3EZ4E2ppdm1W2FkU5EHTdRVRi0HlOCFXSwVuBCKbqTEqmGHLaqWf/jyGIfpg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1657290906; bh=CWXU/++yjWJNxl5T4BdowjwRvT58zL6O1APk/6eq0j/=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=WBCov6cvzJ7HApEPzshJCIVGxcT9vgs/XqXv+rAutTSGoFYdN6srkpBb0LuGL6DENyUKNuhCvJ8HW+XC80qqsPLzRJ7N4VoNcg0DwW8VvfJmTTGBlg+HBz50VFEn8JNW2nHMp3/jilPvIQT7Jte5TMvVhthT57LrUwhHre3pyHqEjEzyXHjAG2k5HlkZbCgqOhiaFxpiORuJs9nvCa6HnG76XOIIAqjK7BsL6EG33aholRxUvFbm7uF0r6j7plEVnuecavQ9Xd+nXiz1uGN9WpCK5ULTkefeXMdCC0aNs1ztcXbSjapM8oMjeazgEarCiLg4yXD61UHUmW/+gwxNzg== X-YMail-OSG: jUNV9tQVM1mL_49_T0nEGOZZeLhC6qR2sdz0caM1TB6DiPLONGhXe_d1Hk0c8fB 14Cjs6PeCQl1buaTCQhSxJ8S9JeECt6wjiEbg3KZqpGZb_Vid.4iQ3mu8Ybl870sCXCWcwZCE227 RqaHodVRJpmIlp9E0Z0lQHJU.dNYOHwRZheOgwxlpBPf8WkysSugv1tjSWVqkc72lmH3THkUzRzU KSty7dUkNbbcIDAIq0kjFnqCJgJdSNm2J2axHUUE4wyfJ0TtIm0oWF6rlBjyBf4ER5WRVQjCBMmf Q5rCrgjpDnal5miXOWfm_EKoGbGYgfytTIaqufX6cGD55c4UrpCLpuC05pUK0Z8Ug4z.paVxcw1A SKSy0Odzi863fWkI.jHRweoZfc08j52_U2XToBYapXJur9Y.WRjkkFTOQbdTs7S5t5m1t0zGrkY9 T5v9fAoOIt08MWz0I3bmZn8D1A9Gh_M49JWZRw5Y_o5d8KEbt8szxiQR9zpaAOmszFXNF0w3R4Z7 WtT3gF59uLZb3fH93WjTe8AVP.MiMmr8h20oQ.DOt2Ti53dfKA_l.ASBU11tQS1j0BENbbNfHDCg mNE3bjGsp6j4eJJGZlZXP8VaeOYhVZpJFESGQYdbYEHnOD3hCoDkX0LU1PYtfmaYehvn5Og0qV_8 f6wfVk5JnDgQC5s6a8ZodChbeJsYttcwSV7aBVzPnuxzyldzz1RhzoEHCjGoXkwgyOhqpR4eMsex dhmlPUEpOhrgCpziUtqmJrGnsV3A9WLV2nGf6oZJUvfTgm6d5VP6lbpmdTgyyZ5rjQggnS4Y50zz aNDNIPEwC_PL4Z45zSeKG.VAtIouD51tZr47IgK.xtHMjOuDMHTQMKqQ4O4PD6i7_64u._MZ3Yqn rjs2Cn31yjt8XpbXuGZZg67D4i3mYBMf6TfXhM7k163nemVu0g6w6lyk6YbrJOxQmxqUiI_kvzS. 2Bkso51mGwYoj0rcpPCp3HdfcpV_SfGFsqr2JC.PDGSf_sXdTVsIZq_ZtyJK0GO0y7gJs6Z0weXf mMWcF6XNy3Ij5g7j5D03oDNCXq359N1TRcq792OkuRzeAV.UlppJWjhEXdBQcxeZvFxwug4jUk0c vXB2H6g0axb7cq0oF7W3mdyf9uvZhYFk77rLCE15R.Hcty6e6zv6EGbC1cj8cWi7dRl2y_yulPfb MOM3anwJ9HmuAP3tlAn3dwFi7RlxOQtOumRWggzkrWqCFcvJsgByrYQXHZNBhxDLYYiUWzCOjdHx Fq_zomV834X4SHJk3rmeb5LkQ3I9RobZGDo8uaegtTtWhzMrjun.tf0qGUQrDGUuGvaDZSiepp9Z eqWDMDM9eWNbdd5dXLUn20.pXTcGgm3c_uBKM_2WV8Uq4zV5BULXRv4BIfiZmfTPeNLTOK0sI1jD u_UiPRA9ni7Sh6CiErn.kVSwpIe8qMLOTBN5.AKvirBXd89xORkoH4CRksxDdnsQLFdv2lm3wIBg EnWlxyYg116mj.GMLioWxyMcmTnbcNpK4f4DepqY7eHfdNqBv8lI7b.67svP.BGlozCuD8L9ZiYp k_0_hovQAxYZBpcX3day0.B_rwstAsnwHvBm2aOOozNk4BieFm83L6WSqASPwEbQZs1ucWRs4fhZ 1p62xx4VsMW7tVk..Kj4grUfWIlY4DdsHWre43PulJ2a8ns9w2K5uva0lT8NvJBFKgwDGOc8pAXL J2O6Chb.QEPm_eniMN4a7Wl7MfT3wIur.LTPbTDOs_0fIctsvZ7Uvz_bcNx7GvawEwoTx_IHnIYW u9w5Eoqq25jOoBax9JYhqZKXk2ZRyv3cAAB4yXagEIwp4jg.lI7gEsueLKiQLieyFko1.WEppESU kkZbhSdovh9IaOFl1TR9qYClPQk_H1kRP5gwiR34GP_AFwQzvX28QVRq08UdLKTYnoLMFBwB2w9E EadeFYC3gc0UEgPnhNeqQyIZejg85PO50cqEJn9i0hSSL1.v6jkFJdLV0.DC4jAJd.TdKMiihw5f EzojZTklTmYB8SEhZbKmLxy20EqCXOJir8hwRfWnevoOZJCvTfec6MxZ8YFdFdT9J5DEs_LiTpWr aJ9LSkGe3jnqlFItvgys7L_6Gi8xqSF4y1HfS1YxqA_j9Ha_zH3DIS7cUqyBFcWw.ScdN2COM5kE Bi9KCcn2xFDJpXcsZikGxEDJe0JGBA1p0AqBqWUQ3WmKtn_UaPOlqj6uUDhEl4_JQqFVuxY1D7g- - X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.bf2.yahoo.com with HTTP; Fri, 8 Jul 2022 14:35:06 +0000 Date: Fri, 8 Jul 2022 14:35:05 +0000 (UTC) From: Ravi Krishna To: "pgsql-general@lists.postgresql.org" , Rajesh S Message-ID: <1535945057.1729527.1657290905981@mail.yahoo.com> In-Reply-To: <7f97243d-db62-199a-8412-5637963d117e@fincuro.com> References: <7f97243d-db62-199a-8412-5637963d117e@fincuro.com> Subject: Re: - operator overloading not giving expected result MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Mailer: WebService/1.1.20381 AolMailNorrin Content-Length: 145 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk LANGUAGE 'edbspl' This is the root cause of your issue. You are not using PGSQL, but EDB version of it which is compatible with Oracle PL/SQL.