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 1ouzyz-0003B9-1Z for pgsql-general@arkaria.postgresql.org; Tue, 15 Nov 2022 17:44:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ouzyw-0002DP-OA for pgsql-general@arkaria.postgresql.org; Tue, 15 Nov 2022 17:44:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ouzyw-0002CH-Ba for pgsql-general@lists.postgresql.org; Tue, 15 Nov 2022 17:44:22 +0000 Received: from mail-vs1-xe31.google.com ([2607:f8b0:4864:20::e31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ouzyu-0003aa-07 for pgsql-general@lists.postgresql.org; Tue, 15 Nov 2022 17:44:21 +0000 Received: by mail-vs1-xe31.google.com with SMTP id t14so15413442vsr.9 for ; Tue, 15 Nov 2022 09:44:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:subject:from:to:content-language :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=LJeLT7HlkHNJWVn6Y4QIbiocGLirYxsbtvgJrf4N5HM=; b=bHsASYBQlrJtpj8zVKiCPuA7/3MJREhu88/QLqpacOum8me4pCO5zrxs7B02QQw22v t1KXAalPhqRL/kW7kMmKtOccPPcpfx4kAfxGuWJG4uPjpz4AvGVBS7lXidcCkA4zw89z eGzTEYFtJtr1YBXd8z83Bfl8PBdstRdsWPB6uVW/yuFfhokfEDkdACyjCORbu4U1+JgE wgSSwuPz8FSxYAk/vGBXDw1Mb1MKLFbCjviOxie/fkngn9VM97AS2tBpiaTdXyfDmPDl 6ZREZuTGJ815Yx1DvlldkgMrCuf+T2SGvfnHs8lcjKObdpD06yPes1MjbhcyIpqjeG4l 63Ag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:subject:from:to:content-language :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=LJeLT7HlkHNJWVn6Y4QIbiocGLirYxsbtvgJrf4N5HM=; b=WSZRHSAZAWli/mFldte9lDp6G7Gdv8Rug8T/co/RBbE5bUxwO2WM1/JLqo3DsyuF7Z RSxSMUV26FqNbNW3Uyq4YZLC46lJKJhtnwpXT13UnNe+IdUFziuJ6Ujy4Ph4/87VoaZo /uMp/kbarUr2ZptpPoNAbiCIVQVFBLNjq5LS7OgrV6McBLCwXnviIVx8xJXYn4dTyM7K Oypxv7Ll/0u90UI7kuspuvXzPgwL+dB2zkb26Ke0BNOxDwAK+ew3UTzI2StIE8I3UfAz YnalB+fWU6n414A1JWSPIRUEggs5GcK3pBvd2MwQb5ppJxGtVCefMAQTKDXV6JZKF2WJ OCJw== X-Gm-Message-State: ANoB5pnqFf83D5cJBuLGIfKSbJ2R5pP2ezMT/KDNLsQnoMmOravu8Nsp zOueyJSD7Y30NqjiAQI3AY9Is4nXqaw= X-Google-Smtp-Source: AA0mqf51D5HL5ZnOXgdA7McoRyBPF7b7IBXy8840YWqa4iYsGd4fyaqMmRRl8/ULAf0HXs/famjs2w== X-Received: by 2002:a05:6102:6d6:b0:3a7:6dd6:8ca9 with SMTP id m22-20020a05610206d600b003a76dd68ca9mr10542601vsg.68.1668534257220; Tue, 15 Nov 2022 09:44:17 -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 n138-20020a1f2790000000b003a9e489ca92sm1766338vkn.44.2022.11.15.09.44.15 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 15 Nov 2022 09:44:15 -0800 (PST) Message-ID: Date: Tue, 15 Nov 2022 13:44:13 -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 Content-Language: en-GB To: pgsql-general@lists.postgresql.org From: Frank Cazabon Subject: Calling function from VFP changes character field to Memo Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, I have a simple table Patients with one field FirstName of type character(30). If I SELECT FirstName From public.patients; I get back the expected character(30) field. 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     RETURN QUERY SELECT p.cFirstName FROM patients p; END; $BODY$; And I call: SELECT * 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? -- Frank. Frank Cazabon