Re: Assign User Defined DataType To Columns

Seriously, you sent this to three lists at the same time? I'm surprised it
came through moderation...

Anyway, my response on the admin list is below - though none of the lists
you picked were actually the appropriate one. You want the -general list.

On Wed, Aug 2, 2023 at 9:42 AM David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Wed, Aug 2, 2023 at 9:24 AM Phani Prathyush Somayajula <
> phani(dot)somayajula(at)pragmaticplay(dot)com> wrote:
>
>> Hi All,
>>
>>
>>
>> I’ve a user defined data type as :
>>
>> CREATE TYPE uibackend."_operation" (
>>
>
> If you find yourself writing user-space code that uses "_{data type}" you
> are doing something wrong. That implementation detail is not something
> that is exposed to the user. If you want to deal with arrays of a type you
> say: {data type}[]
>
> So casting some random text column to an array of operation is simply:
>
> operation_text_col::operation[]
>
> And you can get rid of the above CREATE TYPE command altogether.
>
> David J.
>
>