computed-email-column.sql

-- Deploy 0814-tenants-and-users:users/computed-email-column to pg
-- requires: users/users
-- requires: email-addresses/email-addresses

BEGIN;

\ir ../../defaults.sql

select format(
  $SQL$
    create or replace function %1$I.users_email("user" %1$I.users)
    returns citext
    as $$
      select email_address
      from %1$I.user_email_addresses as uea
      where uea.id = "user".id
    $$ language sql stable parallel safe;

    comment on function %1$I.users_email("user" %1$I.users) is E'@filterable\n@sortable';
  $SQL$,
  :'id_schema'
)\gexec

COMMIT;