That's great, thank you! worked like a charm.
On Wed, Jun 12, 2013 at 8:31 PM, Alvaro Herrera wrote:
> Rebecca Clarke escribió:
> > Hi all.
> >
> > I have a function that has an attribute with datatype of character
> varying.
> > In the pg_type table the oid of the data type points to type varch
Rebecca Clarke escribió:
> Hi all.
>
> I have a function that has an attribute with datatype of character varying.
> In the pg_type table the oid of the data type points to type varchar
>
> Is there somewhere that identifies the alias for each type?
Cast the type name to regtype. That outputs t