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

Supabase

How do I use the `exists` function like `select exists(select 1 from contact where id=12)` in supabase?

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

Pinging <@&951828363943759883> so that they see this as well!

**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.

Can you give a bit more detail on what you are asking?  What do you mean by supabase?  The js client?

This does not work for example:
```typescript
const { data } = await supabase.from('profiles').select(`exists( username )`).eq('id', user.id)
```
In postgres, I should be able to return true or false is something exists...

exists is only on the postgres side.  On the JS side the closest to exists would be you get an array with selected data.  So data.length...

If you don't want data returned I guess you could use select with a count only returned

Ok... odd.  When I query something that doesn't exist, I get this error in console.log:
```GET https://22234fdsa.supabase.co/rest/v1/profiles?select=username&id=eq.7b8bca86-47ad-4928-8f56-538638e09774 400```
which I would like to get rid of.

Well you would obviously have to catch the error and do something with it

right, but it prints to the console even when I do that...

I don't have console.log anywhere in my code

No big website I know of have a clean console

Hmm.  IMHO that is bad coding, as errors should be handled correctly.

What is your exact call you get 400 on?   If you request .eq and it does not match you should get empty array

https://tenor.com/view/your-opinion-doesnt-matter-camera-motion-crazy-dance-imgplay-opinion-gif-24241272

But I honestly have no clue how to disable this

I am querying a user record that does not exist.  I would like to not print to the console and check if the user exist.

Please show your query it should return []

```typescript
        const { data, error, status } = await supabase
            .from('profiles')
            .select(`username`)
            .eq('id', user.id)
            .single();
```
It does return [], but it still prints to the console

That means you MUST have one and only 1.  0 is an error, 2 or more is an error.

You can use .maybeSingle() if you are sure it will never be more than one.  Then 0 or 1 result works.

the single fixed the problem.  Thank you sir!

Thread was archived by <@784251474204295218>. Anyone can send a message to unarchive it.