Re: Calling function from VFP changes character field to Memo

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Frank Cazabon <frank(dot)cazabon(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Calling function from VFP changes character field to Memo
Date: 2022-11-15 18:48:32
Message-ID: e1c01985-7080-d404-b269-8ce8507e6c6e@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-11-15 18:52:49 Re: Calling function from VFP changes character field to Memo
Previous Message Tom Lane 2022-11-15 18:44:03 Re: Calling function from VFP changes character field to Memo