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 1ov0eH-0005bE-MC for pgsql-general@arkaria.postgresql.org; Tue, 15 Nov 2022 18:27:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ov0eG-0004xA-Ht for pgsql-general@arkaria.postgresql.org; Tue, 15 Nov 2022 18:27:04 +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 1ov0eE-0004wx-Em for pgsql-general@lists.postgresql.org; Tue, 15 Nov 2022 18:27:04 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ov0eA-00040E-Dp for pgsql-general@lists.postgresql.org; Tue, 15 Nov 2022 18:27:02 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 3C26F5C02AE; Tue, 15 Nov 2022 13:26:55 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Tue, 15 Nov 2022 13:26:55 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to; s=fm3; t=1668536815; x= 1668623215; bh=qkz9xPB4bd03cI+5cf8XWJ7R9UerOlnJekQ1Q2M0HD4=; b=u y6ww+JvpvtpXjqc+dFMCBzcAR8OUO4nPhMQsPgu7/V+bzJPaySZQVu6QQfhZo02x GWT0/qrERdeNfCPh7f+/wpAc0t8lt0GVYQZhergCdN4+kYkM+PZh3noTU3FCaBfI I3L0bUVCg/uLQ6Gt6tQtq8eqMai/KKqOltItnWpY4F1YpZa8a6M8SM5y8w6907yy YhHa474JctSFINq+RrAbXWi9rIMorruFIbQGsIzUk8xfpLJkrDpTlb01J9s6unD3 kqUPqmwtY56aXEHlC9d1DAmqU8Kg6zrPR9aEGT4IfxvKGEXXYZ4y8UnJcrNKXpfh RnnO1PFn+I1wPV59YJIOQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:date:feedback-id:feedback-id:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1668536815; x=1668623215; bh=q kz9xPB4bd03cI+5cf8XWJ7R9UerOlnJekQ1Q2M0HD4=; b=qSEl63yX/VBL26Zdo 3LqyQNc9dw220ggFhc2dptlYhaYoXIPOSkND/Dsh8/P29uojnl0AcguZwEzN4W3U jGhad5OY7vQ5sntyfcq0P3e9Mj0qodS9WwbOvrCzgHeHEJEQVbaGrgUBV6ErOwxy Xp8Wlpthjq1wqEuK+3mOtr5qZolR3Bae/iDImdLL9jJ7NU2UULiI4xu3lHyZ/Mvy B83GVwjq/+0koC98vuis65r+lDUy3SAIUG8QEVmvJNEgEbttnr8xlbdfGp8sub3g GRDQMdMwzt1uRRhXFzhrEw6xHl9H6p8gih4g1OHP36pzRGN5VKQ6olZjVFN4EUY7 AN4mw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvgedrgeeggdduuddvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhkffffgggjggtgfesthekredttdefjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeevveefveefueegffekkefhgeeiueffgfetueejvdfg hfeujeejhfekjeelgedtgeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 15 Nov 2022 13:26:54 -0500 (EST) Subject: Re: Calling function from VFP changes character field to Memo To: Frank Cazabon , pgsql-general@lists.postgresql.org References: From: Adrian Klaver Message-ID: <144d91c5-e0e6-4669-6c88-700ddaeee52b@aklaver.com> Date: Tue, 15 Nov 2022 10:26:53 -0800 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/15/22 9:44 AM, Frank Cazabon wrote: > 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; In the first query the field name is FirstName not cFirstName. Is this a typo or are they different fields? > END; > $BODY$; > > And I call: > > SELECT * FROM public.testFunction(); SELECT firstname 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