need to do to get it to return the character(30) type?
--
Frank.
Frank Cazabon
On 15/11/2022 2:48 pm, Adrian Klaver wrote:
On 11/15/22 10:43 AM, Frank Cazabon wrote:
Please reply to list als.
Ccing list
Sorry about that, first time using this list and just assumed I was
replying to the list and the list would then notify you
SELECT * FROM public.testFunction
On 15/11/2022 2:44 pm, Tom Lane wrote:
Frank Cazabon writes:
If however I have a function defined like this
CREATE OR REPLACE FUNCTION public.testfunction(
)
RETURNS TABLE
(
Firstname character(30)
)
LANGUAGE 'plpgsql'
AS $BODY$
BEGIN
I don't think that's necessary, I'm 100% certain that it's VFP not able to
interpret the size of what is coming back to it so it just gives it the biggest
type it can.
Thanks
15 Nov 2022 14:59:59 Ron :
> On 11/15/22 12:54, Frank Cazabon wrote:
>>
>> On
On 15/11/2022 2:58 pm, Adrian Klaver wrote:
On 11/15/22 10:54 AM, Frank Cazabon wrote:
On 15/11/2022 2:44 pm, Tom Lane wrote:
Frank Cazabon writes:
If however I have a function defined like this
CREATE OR REPLACE FUNCTION public.testfunction(
)
RETURNS TABLE
