From: Tom Lane <tgl@sss.pgh.pa.us>
To: aditya desai <admad123@gmail.com>
cc: "Voillequin, Jean-Marc" <Jean-Marc.Voillequin@moodys.com>,
        pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: Convert text to user defined datatype
In-reply-to: 
 <CAN0SRDFGYOKxvpR5svU8s2rjmQ9+tr5+jGdnfSYvn6eMPJ1PFQ@mail.gmail.com>
References: 
 <CAN0SRDFsxNhWMOdSj_gveb3=7E6ktRR_q1Masr6EmiLGg5J53A@mail.gmail.com>
 <MN2PR20MB27357EFC60D632C6315A02D5BE819@MN2PR20MB2735.namprd20.prod.outlook.com>
 <CAN0SRDFGYOKxvpR5svU8s2rjmQ9+tr5+jGdnfSYvn6eMPJ1PFQ@mail.gmail.com>
Comments: In-reply-to aditya desai <admad123@gmail.com>
	message dated "Sat, 23 Oct 2021 20:01:52 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3094021.1634999943.1@sss.pgh.pa.us>
Date: Sat, 23 Oct 2021 10:39:03 -0400
Message-ID: <3094022.1634999943@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3094022.1634999943%40sss.pgh.pa.us>
Precedence: bulk

aditya desai <admad123@gmail.com> writes:
> Thanks Jean. However I am trying this inside procedure and getting an
> error. Will try to send screenshot.

That's frowned on around here.  Can't you copy-and-paste the code
and the error message?

As Jean-Marc says, you shouldn't really need a defined CAST
object to cast to or from text; Postgres will interpret that
as a request to apply the datatype's I/O functions.

You can formalize that by creating a cast "WITH INOUT", but
you shouldn't need to, so I think your problem here is something
different from what you said.  Hard to give more advice without
seeing the problem code and the specific error.

			regards, tom lane