Re: define type_transform to new user defined type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mohsen SM <mohsensoodkhah(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: define type_transform to new user defined type
Date: 2014-02-25 21:11:46
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Mohsen SM <mohsensoodkhah(at)gmail(dot)com> writes:
> I want to create new type that is similar to varchar.
> its size is variable.
> I use CREATE TYPE query.
> I define for that type this functions:
> 1-typein
> 2-typeoute
> 3-typemodify_input
> 4-typemodify_output
> 5-type_transform
> I can define 1 to 4 functions in CREATE TYPE
> but I can't define type_transform for that type. how did I can define
> type_transform for that type?

There's no such thing as a "type transform". There are transforms
associated with functions ... unfortunately, there's not currently
any provision for defining those at the SQL level. You could poke
an entry into pg_proc.protransform if you're desperate enough.

regards, tom lane

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2014-02-25 21:14:42 Re: [bug fix or improvement?] Correctly place DLLs for ECPG apps in bin folder
Previous Message Peter Eisentraut 2014-02-25 21:11:27 Re: install libpq.dll in bin directory on Windows / Cygwin