Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit

SELECT 1

create table users 
           ( id         integer  generated always as identity
                                 primary key 
           , name       text 
           , email      text
           , created_ts timestamp default now()
           );
 
insert into users (name, email)  
    values ('first user', 'first.user@goodoldboys.com')
         , ('second user', 'first.user@goodoldboys.com'); 

select * 
  from users; 

CREATE TABLE

INSERT 0 2

id
name
email
created_ts

1
first user
first.user@goodoldboys.com
2023-04-23 22:59:21.024789

2
second user
first.user@goodoldboys.com
2023-04-23 22:59:21.024789

SELECT 2

with old_row as 
     ( select email   
         from users 
        where id = 1
      ) 
   , new_row as 
     ( update users 
          set email = 'example@example.com'
        where id=1
     ) 
select * 
  from old_row; 
  
email

first.user@goodoldboys.com

SELECT 1

select * 
  from users; 

id
name
email
created_ts

2
second user
first.user@goodoldboys.com
2023-04-23 22:59:21.024789

1
first user
example@example.com
2023-04-23 22:59:21.024789

SELECT 2

id	name	email	created_ts
1	first user	first.user@goodoldboys.com	2023-04-23 22:59:21.024789
2	second user	first.user@goodoldboys.com	2023-04-23 22:59:21.024789