Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ov13X-0007EC-P6 for pgsql-general@arkaria.postgresql.org; Tue, 15 Nov 2022 18:53:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ov13W-00008n-Jf for pgsql-general@arkaria.postgresql.org; Tue, 15 Nov 2022 18:53:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ov13W-00008S-7D for pgsql-general@lists.postgresql.org; Tue, 15 Nov 2022 18:53:10 +0000 Received: from mail-vk1-xa30.google.com ([2607:f8b0:4864:20::a30]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ov13T-000259-99 for pgsql-general@postgresql.org; Tue, 15 Nov 2022 18:53:09 +0000 Received: by mail-vk1-xa30.google.com with SMTP id v81so7067614vkv.5 for ; Tue, 15 Nov 2022 10:53:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=f7Weu8nir7KmPlms8RlipPizH82BYUZWbu5d+SBiubA=; b=pPbfVw+3oGj3/sDELA73rf+TF3oocVDKRpYS7Faqcln5AWpAWCbFm1GyZk2RvVyzhn KwgxcSpJpDmdRpRcPfLnh7CdUYCDo7dAs0mhkXqGFgQJT15d9frYNVKBU48rInYDH1HQ l9uss44d0rucvMihCLpijbJjkUu2YEePLq+JHzHoTdGxUCl+KZxztcoWLsEXXDdf0CoM OQ4UeDvBqKkthHOGYXEpMs2mbLHF1lscHTCzjXfV7+STo36Bu3Srv2DruY2KIKDiUCbR jWZbU5fuQJB8OZ4CLn7qX+br+glTOhSO6qWzYsKJ0tv8k95+gpjEf+jg4s3GtEto/Q6U 2HLA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=f7Weu8nir7KmPlms8RlipPizH82BYUZWbu5d+SBiubA=; b=gIOx1O+dNMcd64gLpH2l7qq8JaSa5n4HrMHtPv24QyD5dTNjbYsp4vlFrIHHswWl/g W/M0k1lev7H7BBXaqdXu/aAO7ctvsfp3dbMtIC73JvmOjKCukc7FeRroWzshzk6moKTT XCLOA48kG4a0Bz/fWf8+OTEklVbc///IVMfyFPjWW36C9GgUbABSyqrgNpQsuu8VDPcL Ni8O78HCzwZbzUaATeaCoYR60eoJvXpWEsfHLtrsboe1eWLcelU3fzvPTps4ZdYWG8CX y/zKeuBHJHLTGzL20Gln8fKzCWhBAIpP4ZGAkGQydHuKj3JQcsXUg5BDmfCadRLNo0iw /WYA== X-Gm-Message-State: ANoB5pmEQKWxS1darD9TXNR8ITaL3/XK9yj9h8rUs8MXn5e/QzJ0eih0 zDCrcQ1zv60iIkzIPWB7bwNms9S8dl0= X-Google-Smtp-Source: AA0mqf67+5VvvNQCLQesJmhU88iLJ85DctOHb8/fFHnH03RbDEo6ETjKsMEWdLyL78vf3XjvzjGLNQ== X-Received: by 2002:a05:6122:da9:b0:3bb:e20d:8641 with SMTP id bc41-20020a0561220da900b003bbe20d8641mr10402096vkb.29.1668538386489; Tue, 15 Nov 2022 10:53:06 -0800 (PST) Received: from ?IPV6:2803:1500:e01:d97d:9c6f:aa78:3036:459b? ([2803:1500:e01:d97d:9c6f:aa78:3036:459b]) by smtp.gmail.com with ESMTPSA id i20-20020ab029d4000000b0040c7fa8a644sm1894307uaq.36.2022.11.15.10.53.05 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 15 Nov 2022 10:53:05 -0800 (PST) Message-ID: <5d995cf0-1692-412a-8a9b-3a946819f0d5@gmail.com> Date: Tue, 15 Nov 2022 14:53:03 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: Calling function from VFP changes character field to Memo Content-Language: en-GB To: Adrian Klaver Cc: pgsql-general References: <144d91c5-e0e6-4669-6c88-700ddaeee52b@aklaver.com> <95255a88-2b7b-9072-0cb0-1045dfc4310d@gmail.com> From: Frank Cazabon In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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(); >>> >>> SELECT firstname from FROM public.testFunction(); >> This has the same result. > > How about?: > > SELECT firstname::varchar(30) from FROM public.testFunction(); That does work, thanks, but it may cause me some logic problems in the rest of the code. I'll try the type suggestion from Tom and see if that works and then decide which is my best approach. Thanks > >>> >>>> >>>> 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? >>>> >>> >>> > >