Received-SPF: pass (loft7616.startdedicated.de: connection is authenticated)
Message-ID: <010d77a8-4338-5dc0-d055-e25782ef825c@a-kretschmer.de>
Date: Sat, 21 May 2022 15:36:15 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.8.1
Subject: Re: Writing my first trigger
Content-Language: en-US
To: pgsql-novice@lists.postgresql.org
References: 
 <CAPhBOiiW8jk_2wcKvCik1eXNejS10qwfGuuovPk0Q=5kvHNxNw@mail.gmail.com>
 <81b6ada5-7274-b260-2a59-19c6e450fb30@a-kretschmer.de>
From: Andreas Kretschmer <andreas@a-kretschmer.de>
In-Reply-To: <81b6ada5-7274-b260-2a59-19c6e450fb30@a-kretschmer.de>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/010d77a8-4338-5dc0-d055-e25782ef825c%40a-kretschmer.de>
Precedence: bulk


Am 20.05.22 um 17:06 schrieb Andreas Kretschmer:
>
> your table doesn't contain the field "updatedA". I would suggest to 
> calculate the fullName at select-time and not via TRIGGER.

other solution, generated colums:

postgres=# create table employee (firstname text, prefered_firstname 
text, lastname text, fullname text generated always as 
(coalesce(prefered_firstname,firstname) || ' ' || lastname) stored);
CREATE TABLE
postgres=#
postgres=#
postgres=# insert into employee values ('max',null, 'mueller');
INSERT 0 1
postgres=# insert into employee values ('susann','susi', 'scholz');
INSERT 0 1
postgres=# select * from employee ;
  firstname | prefered_firstname | lastname |  fullname
-----------+--------------------+----------+-------------
  max       |                    | mueller  | max mueller
  susann    | susi               | scholz   | susi scholz
(2 rows)

postgres=#


Regards, Andreas

-- 
2ndQuadrant, an EDB company
www.2ndQuadrant.com / www.enterprisedb.com