Re: Calling function from VFP changes character field to Memo - Mailing list pgsql-general

On 11/15/22 10:43 AM, Frank Cazabon wrote:

Please reply to list als.
Ccing list

>>> SELECT * FROM public.testFunction();
>>
>> SELECT firstname from FROM public.testFunction();
> This has the same result.

How about?:

SELECT firstname::varchar(30) from FROM public.testFunction();

>>
>>>
>>> Then FirstName returns as a Memo field (similar to a Text field).
>>>
>>> Any idea what I need to do to get it to return the character(30) type?
>>>
>>
>>


-- 
Adrian Klaver
adrian.klaver@aklaver.com