Re: [SQL] Using substr with user defined types

[Tom Lane]

[EMAIL PROTECTED] (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