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