My latest try is like the below, still not working as expected const { data, error } = await supabase .from('users') .select('phone_number') .in('phone_number', LIKE ANY(ARRAY[@contacts]))

The code should be converted to dart format

how about converting contacts into an array via dart first (so that it looks like

['%91960000000', '%7780000000', ...]

), then

const { data, error } = await supabase
  .from('users')
  .select('phone_number')
  .in('phone_number', @contacts)

assuming your phone numbers stored in the db also are prefixed with '%'. else, you should remove them first

Phone numbers are not stored with % sign in the database, with the percentage sign I am doing pattern matching. Contacts as an array, thats how I initially tried, that didn't work. I got a promising solution from one of the forums, but still not quite there. The solution was to create a function in Supabase and then call the function using postgrest. Example of a function -

CREATE FUNCTION users_with_matching_phone_number(contacts text[]) RETURNS TABLE(phone_number text) as $$
SELECT * FROM users WHERE phone_number LIKE ANY(contacts);
$$ language sql;

Please just link to the answer on the discussion board next time https://github.com/supabase/supabase/discussions/2938#discussioncomment-1225339

Sure @User

Still working on the solution, calling the function in dart with arguments is not working for me as of now.

I've posted a solution on the discussion thread

Thanks @User , really appreciate it.

How do I get an approximate row count with the Supabase security enforcing a 1000 read limit for malicious read protection?

You can override this in Settings > API > Settings > Max Rows (and btw whole table count with

count

overrides that setting)

> (and btw whole table count with count overrides that setting) What does this mean? I set the setting

count

to

estimated

and I get 1000 (when I know it's more - over 1600)

Does it still give 1000 when you use

count: 'exact'

?

It gives the correct number. I'm worried about using "exact" for performance

Yeah

estimated

uses the Postgres stats collector so the number tends to be off

It is suspiciously the same as the security limit

It is 1001 though so maybe it is just the estimate

guys, what is a safe way to drop all tables quickly? Can I just run this script as I would do in a normal Postgres DB, or will it mess up some Supabase-specific stuff?

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;

(Background: I'm coding a tool that migrates an Airtable base to Postgres / Supabase and need to "reset" the target Supabase tables frequently. So it is a dev/test project at the moment, but once I get the migration right, I want to continue to develop the live app on top of it, so I'm a bit paranoid it will mess up something in long run)

Drop all tables

Hello, how can I do "select sum(column) from table group by other_column" with the API? Is it possible?

How to refert to the object being posted in policy?

i mean inserted

or any operation

Use a function inside the database and call it via the

.rpc

method

It's probably to explain what you are trying to accomplish than how to refer object in policy, there might be a better way of doing this or a different approach

Sorry i guess my question wasnt clear

Like if am creating policy on say "messages" table

i want to do:

create policy blah blah using ( msg.user = auth.uid() AND msg.type = text )

like that