Re: Using substr with user defined types

darcy@druid.net (D'Arcy J.M. Cain) writes:
>> Not with that much info.  Sooner or later you're going to have to
>> show us your C code...

> char *
> chkpass_rout(chkpass *password)
> {
>     char       *result;

>     if (password == NULL)
>         return (NULL);

>     if ((result = (char *) palloc(16)) != NULL)
>         strcpy(result, password->password);

>     return (result);
> }

That doesn't return "text", so you can't tell the system it does.
Type text is a varlena type, ie, length word followed by data.
        regards, tom lane