devthejo
16b7e7d6aa
All checks were successful
/ build (map[dockerfile:./services/hasura/Dockerfile name:hasura]) (push) Successful in 47s
/ build (map[dockerfile:./services/web/Dockerfile name:web]) (push) Successful in 1m47s
/ build (map[dockerfile:./services/watchers/Dockerfile name:watchers]) (push) Successful in 2m37s
/ build (map[dockerfile:./services/files/Dockerfile name:files]) (push) Successful in 2m52s
/ build (map[dockerfile:./services/api/Dockerfile name:api]) (push) Successful in 3m2s
/ build (map[dockerfile:./services/app/Dockerfile name:app]) (push) Successful in 31s
/ build (map[dockerfile:./services/tasks/Dockerfile name:tasks]) (push) Successful in 2m44s
/ deploy (push) Successful in 48s
10 lines
470 B
PL/PgSQL
10 lines
470 B
PL/PgSQL
CREATE FUNCTION public.computed_archived_message__avatar_image_file_uuid(message_row public.archived_message) RETURNS uuid
|
|
LANGUAGE sql STABLE
|
|
AS $$
|
|
SELECT "image_file_uuid" FROM "user_avatar" WHERE "user_id" = message_row.user_id
|
|
$$;
|
|
CREATE FUNCTION public.computed_archived_message__username(message_row public.archived_message) RETURNS text
|
|
LANGUAGE sql STABLE
|
|
AS $$
|
|
SELECT COALESCE("username",'') FROM "user" WHERE "id" = message_row.user_id
|
|
$$;
|