commit df54b1d8a344d1ad0dad41ae116ca0c1042ab34c
parent 518e6a884345b6f6b2e7090c755cf07cf1bbc36a
Author: Andreas Gruhler <andreas.gruhler@adfinis.com>
Date: Sun, 23 Jul 2023 10:28:57 +0200
fix(distinct_startlist): field type text
Diffstat:
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/README.md b/README.md
@@ -44,8 +44,8 @@ create or replace view score_summary as
-- Create distinct set of athletes (startlist) from a set of heats
create or replace function distinct_startlist(heat_ids numeric[])
-returns table(id bigint, athlete bigint, nr bigint, firstname varchar, lastname varchar,
-birthday date, school varchar)
+returns table(id bigint, athlete bigint, nr bigint, firstname text, lastname text,
+birthday date, school text)
language plpgsql
as $$
begin