Re: Using substr with user defined types - Mailing list pgsql-sql

From Tom Lane
Subject Re: Using substr with user defined types
Date
Msg-id 18662.961775545@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using substr with user defined types  (darcy@druid.net (D'Arcy J.M. Cain))
Responses Re: Using substr with user defined types
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Jeff Hoffmann
Date:
Subject: Re: Merging two columns into one
Next
From: Tom Lane
Date:
Subject: Re: Orderby two different columns