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

Supabase

Is it possible to do resource embedding on filters when running a delete operation? I want to delete an entry from a table based on embedded columns from a foreign table

Hello <@187012650750836736>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

<@187012650750836736> Yes, that's possible. What have you tried?

You would need to use: https://postgrest.org/en/stable/api.html#embedding-with-top-level-filtering

Hi, I have a table layout like this

```
create table discovery.nft_contracts (
    id serial primary key,
    chain_id integer not null,
    -- TODO(dbmikus) we should lowercase this
    contract_address text not null
);

create table discovery.nfts (
    id bigserial primary key,
    nft_contract_id int references discovery.nft_contracts not null,
    token_id util.uint256 not null
);

create table public.bookmarks (
    user_id uuid references auth.users not null,
    nft_id bigint references discovery.nfts (id) not null,
    created_at timestamptz not null default now(),
    updated_at timestamptz not null default now(),

    primary key (user_id, nft_id)
);
```

I would like to be able to delete a bookmark by specifying `chain_id, contract_address, token_id` instead of by `nft_id`

This is what I had to delete via `nft_id`

```
    const resp = await this.supabaseClient
      .from<sbtypes.definitions['bookmarks']>(LIKES_TABLE)
      .delete()
      .match({ user_id: args.user_id, nft_id: args.nft_id })
```

<@187012650750836736> I see. Actually I've noticed that right now you'd need a function for this. However it will be possible once this issue is solved: https://github.com/PostgREST/postgrest/issues/2323