Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hello please I need help. I'm getting an error when trying to return a custom record from this query. 
```sql
  select type, total 
  from aggregate_business_transaction('b579f1b2-4c20-4d54-a3aa-4728b2ca32da') 
        as (type varchar, total int8)
```

This is the content of my SQL function. ```sql
create or replace function aggregate_business_transaction(business_id uuid)
returns table(
  type varchar, 
  total int8
)
as $$
BEGIN
  RETURN QUERY SELECT
    type,
    SUM(amount_in_base) as total
  FROM transactions
  WHERE "business_id" = business_id
  GROUP BY type;
END;
$$ language plpgsql
```

What is your error?  Try select * from function(..); also

So i changed that to this:
```sql

create or replace function aggregate_business_transaction(business_col_id uuid)
returns table(
  transaction_type varchar, 
  total int8
)
as $$
BEGIN
  RETURN QUERY SELECT
    type as transaction_type,
    SUM(amount_in_base) as total
  FROM transactions
  WHERE "business_id" = business_col_id
  GROUP BY transaction_type;
END;
$$ language plpgsql
```

Now! i'm getting this error <@!764524500162445402> : `structure of query does not match function result type`

I'm not good enough with postgres to just look and see the issue.  But it is complaining your query types are not matching the two return values.  What is the type of amount_in_base?  Is it int8? total will be what ever type amount_in_base is.

So if it were me muddling thru it I would run just the select in sql editor and see if the result is what I expect.  Records with two columns named transaction_type and total. Basically you are dealing with postgres so your world of info is far beyond just the supabase discord.  There are 1/2 dozen or so SQL gurus who wander around this user channel otherwise.

I could show you the returned record tho.

I would not expect total to be in quotes...

I used `numeric` instead of `int8` or any other data type.

This one works:
```sql
create or replace function aggregate_business_transaction(business_col_id uuid)
returns table(
  transaction_type varchar, 
  total numeric
)
as $$
BEGIN
  RETURN QUERY SELECT
    type as transaction_type,
    SUM(amount_in_base) as total
  FROM transactions
  WHERE "business_id" = business_col_id
  GROUP BY transaction_type;
END;
$$ language plpgsql
```

yeah that is a bit different than int8....   carry on