Postgres 16

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

CREATE TABLE customer (
  id SERIAL NOT NULL PRIMARY KEY,
  name TEXT NOT NULL ,
  email TEXT NOT NULL DEFAULT ''
);

CREATE TABLE


INSERT INTO customer(name, email)
VALUES 
  ('Vasya', 'vasya@email.com'), 
  ('Petya', 'petya@email.com');

INSERT 0 2


CREATE OR REPLACE FUNCTION find_customer_name_by_email(email TEXT) 
RETURNS TABLE(name TEXT)
LANGUAGE plpgsql    
AS $$
BEGIN
    RETURN QUERY
    SELECT c.name 
    FROM customer AS c
    WHERE c.email = find_customer_name_by_email.email;
END;$$

CREATE FUNCTION


SELECT find_customer_name_by_email('petya@email.com');


find_customer_name_by_email


Petya



SELECT 1