RE: Convert text to user defined datatype
От | Voillequin, Jean-Marc |
---|---|
Тема | RE: Convert text to user defined datatype |
Дата | |
Msg-id | MN2PR20MB27357EFC60D632C6315A02D5BE819@MN2PR20MB2735.namprd20.prod.outlook.com обсуждение исходный текст |
Ответ на | Convert text to user defined datatype (aditya desai <admad123@gmail.com>) |
Ответы |
Re: Convert text to user defined datatype
|
Список | pgsql-sql |
Maybe needless,
xxx=> create type t2 as (t2 varchar(30)[]);
CREATE TYPE
xxx=> select ('("{a,b,c}")')::t2;
t2
-------------
("{a,b,c}")
(1 row)
From: aditya desai <admad123@gmail.com>
Sent: Saturday, October 23, 2021 11:40 AM
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Convert text to user defined datatype
CAUTION: This email originated from outside of Moody's. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Hi,
I have a user defined data type as below.
postgres=# \d t2;
Composite type "public.t2"
Column | Type | Collation | Nullable | Default
--------+-------------------------+-----------+----------+---------
t2 | character varying(30)[] | | |
I need to cast values to the above type. Getting error below.
postgres=# CREATE CAST (text as t2) without function;
ERROR: source and target data types are not physically compatible
If I have to create a CAST with function. Could you please suggest how to write this function?
Regards,
Aditya.
В списке pgsql-sql по дате отправления: