Typescript return type for Functions

I really appreciate the

supabase gen types typescript

supabase gen types typescript

utility in the CLI tool. One thing I can't get to work is when I define Postgres Functions, it won't determine the return type based on the the function. For example, given this function

create or replace function shifts_by_week(date timestamp default null)
returns setof shifts
as $$
  select * from shifts where date_trunc('week', coalesce($1, current_date) + interval '1 day') - interval '1 day' = date_trunc('week', shifts.date + interval '1 day') - interval '1 day';
$$ language sql;

create or replace function shifts_by_week(date timestamp default null)
returns setof shifts
as $$
  select * from shifts where date_trunc('week', coalesce($1, current_date) + interval '1 day') - interval '1 day' = date_trunc('week', shifts.date + interval '1 day') - interval '1 day';
$$ language sql;

Where I'm specifying the return is

setof shifts

setof shifts

which is a table in my schema. The generated type for this is

    Functions: {
      shifts_by_week: {
        Args: { date: string }
        Returns: unknown
      }
    }

    Functions: {
      shifts_by_week: {
        Args: { date: string }
        Returns: unknown
      }
    }

I can manually update the file, sure, but it is auto-generated, so I'd rather not. And yes, I could also build a bash script that will generate the types and then mutate them at the end, but I'd rather not.

Typescript return type for Functions

I really appreciate the

supabase gen types typescript

supabase gen types typescript

utility in the CLI tool. One thing I can't get to work is when I define Postgres Functions, it won't determine the return type based on the the function. For example, given this function

create or replace function shifts_by_week(date timestamp default null)
returns setof shifts
as $$
  select * from shifts where date_trunc('week', coalesce($1, current_date) + interval '1 day') - interval '1 day' = date_trunc('week', shifts.date + interval '1 day') - interval '1 day';
$$ language sql;

create or replace function shifts_by_week(date timestamp default null)
returns setof shifts
as $$
  select * from shifts where date_trunc('week', coalesce($1, current_date) + interval '1 day') - interval '1 day' = date_trunc('week', shifts.date + interval '1 day') - interval '1 day';
$$ language sql;

Where I'm specifying the return is

setof shifts

setof shifts

which is a table in my schema. The generated type for this is

    Functions: {
      shifts_by_week: {
        Args: { date: string }
        Returns: unknown
      }
    }

    Functions: {
      shifts_by_week: {
        Args: { date: string }
        Returns: unknown
      }
    }

Typescript return type for Functions

Similar Threads

Typescript return type for Functions

Similar Threads

Similar Threads

Similar Threads