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 1po7oS-0007si-8P for pgsql-general@arkaria.postgresql.org; Sun, 16 Apr 2023 19:13:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1po7oP-0007xM-OP for pgsql-general@arkaria.postgresql.org; Sun, 16 Apr 2023 19:13:21 +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 1po7oP-0007xD-DD for pgsql-general@lists.postgresql.org; Sun, 16 Apr 2023 19:13:21 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1po7oL-003HhU-FL for pgsql-general@lists.postgresql.org; Sun, 16 Apr 2023 19:13:20 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id C4A053200A5D; Sun, 16 Apr 2023 15:13:13 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Sun, 16 Apr 2023 15:13:14 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type: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=fm2; t= 1681672393; x=1681758793; bh=eE5wM+PSFRM0OID00rsnnFf9ZwQDwt5hT+Y JY5KEi/M=; b=FQSdJZlO8N11aQbA3EfvYlbp1hLNHkrdFiz3CwkHOsVuFHhniOs TUB9HZoIMRA3rnQLtEFGbBT/LsqZ8+dZQtfomZAgcQh+mx6JpITrrfwKvgOCZ5cm rJRhgblzY79VK9Y7IDFhSk4zbs5Iu8HsHE3OWrlZrdkNAsFudqen5fjHu5LFvi01 LgXBtBM5iCRkM6XhfBKfdNFrk0CNl50e8GYaI2d71AqrZj91B3zKTJgDbCFjn76X h4wpXzxlorKTyxjBn+gdbGPYXVJonHdkZzx7JHjQJQqEcPbrAXuB6XUwVsbIDVKZ ksfoaLE46Ag6bsRfatqhqgrEMI9cyiTG6iw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type: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=fm3; t= 1681672393; x=1681758793; bh=eE5wM+PSFRM0OID00rsnnFf9ZwQDwt5hT+Y JY5KEi/M=; b=FaetASA6AY5cdzWerCE6JkLBPUbYZoxYVXKAvn6Dm8KfPQcf4A3 PLQ9EEGauy0OFmxUNvwbNgtSoAtE5exC7MJ6Zu6A8xKeZyQrG8WbSLzlV+W/K6pa lCBcbtcQk8raSK1VAjmgJLCqe36rR14mBUyoQwSD1rfSVQWW9UxXCykrkoFvyAAk V6bbt1dzQdVP7vPMvU5e8RiYIng/AUyhmYn0+YZ7zUoIEOm1Eue5vAfKZftjwu6M MoyC0zOgkbFCE5LI/iNiKK5vg/GC73dUX7SGQqaLhqCbSGOES6I3QhhPtL2IPkme V7jBYRTe0iXoYv6RgjP3jqXDK6H9f3czjRg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrvdelgedgledvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddtfeejnecuhfhrohhmpeetughr ihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtg homheqnecuggftrfgrthhtvghrnhephedugfethfettdehieevteeukedtjedvhfevkefg udefgeevteduvdeuvdeggeegnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpe hmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 16 Apr 2023 15:13:12 -0400 (EDT) Message-ID: Date: Sun, 16 Apr 2023 12:13:12 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: Call a Normal function inside a Trigger Function Content-Language: en-US To: =?UTF-8?Q?FOUTE_K=2e_Jaur=c3=a8s?= , Pavel Stehule Cc: PostgreSQL General References: From: Adrian Klaver In-Reply-To: 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 On 4/16/23 11:47, FOUTE K. Jaurès wrote: > Can I have an example please? Or a link create table trg_test (id integer, fld_1 varchar, fld_2 boolean); CREATE OR REPLACE FUNCTION public.child_fnc(token character varying) RETURNS void LANGUAGE plpgsql AS $function$ BEGIN IF token = 'yes' THEN RAISE NOTICE 'Child'; END IF; END; $function$ ; CREATE OR REPLACE FUNCTION public.parent_fnc() RETURNS trigger LANGUAGE plpgsql AS $function$ BEGIN RAISE NOTICE 'Id is %', NEW.id; RAISE NOTICE 'Fld_1 is %', NEW.fld_1; RAISE NOTICE 'Parent'; PERFORM child_fnc('yes'); RETURN NEW; END; $function$ ; create trigger test_trg before insert on trg_test for each row execute function parent_fnc(); insert into trg_test values (1, 'dog', 'f'); NOTICE: Id is 1 NOTICE: Fld_1 is dog NOTICE: Parent NOTICE: Child INSERT 0 1 > > On Sun, 16 Apr 2023, 17:08 Pavel Stehule, > wrote: > > Hi > > > ne 16. 4. 2023 v 16:15 odesílatel FOUTE K. Jaurès > > napsal: > > Hello, > > Is it possible to call a function inside a trigger function ? > Any idea or link are welcome. Thanks in advance > > > sure, there is not any limit. > > Regards > > Pavel > > > Best Regards > -- > Jaurès FOUTE > -- Adrian Klaver adrian.klaver@aklaver.com