Skip to content

Supabase type error when querying computed field of rpc result #1366

Open
@gwax

Description

@gwax

Bug report

  • I confirm this is a bug with Supabase, not with my own application.
    I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

Supabase supports selecting computed fields from RPC results via postgrest but the type system shows an error when attempting to do so.

Errors show up as SelectQueryError<"column ... does not exist on ..."> but the query still works as expected.

To Reproduce

Minimal reproduction is available in the gwax/rpc-compted-fields branch here: https://github.com/manapoolinc/supabase-playground/tree/gwax/rpc-computed-fields

  1. Make a table returning rpc: https://github.com/manapoolinc/supabase-playground/blob/gwax/rpc-computed-fields/supabase/migrations/20250127194033_create_country_fns.sql#L1
  2. Make a computed field on the returned table type: https://github.com/manapoolinc/supabase-playground/blob/gwax/rpc-computed-fields/supabase/migrations/20250127194033_create_country_fns.sql#L11
  3. Query the rpc with a select containing the computed field: https://github.com/manapoolinc/supabase-playground/blob/gwax/rpc-computed-fields/src/lib/db/countries.ts#L37
  4. See type error in IDE and typescript compiler: https://github.com/manapoolinc/supabase-playground/blob/gwax/rpc-computed-fields/src/lib/db/countries.ts#L61

Expected behavior

No Type Errors in reproduction code

System information

  • Version of supabase: 2.6.8
  • Version of supabase-js: 2.48.1

Activity

added
bugSomething isn't working
on Jan 28, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      Supabase type error when querying computed field of rpc result · Issue #1366 · supabase/supabase-js