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

Supabase

Hey im working in PLpgSQL and i want to work with IN clause which takes value from an array of strings i pass from my server but i cant get it to work, like idk how to pickup that array in plpgsql and put it in the IN clause

Hey

Quite sure you can use  = ANY( instead of in for arrays and get the same result.

See https://www.postgresql.org/docs/current/functions-comparisons.html

```pl
create or replace function test_api(search_country TEXT[])
```

It’s


= ANY(search_country)

You need both keywords and parentheses.

```json
{
    "success": false,
    "log": "Could not choose the best candidate function between: public.test_api(search_country => character varying), public.test_api(search_country => text[])"
}
```

[ "Korea", "America" ] this is the array im passing

```sql
-- drop function test_api
create or replace function test_api(search_country TEXT[])
    returns table
            (
                user_id        uuid,
                image_url        varchar,
                name           varchar,
                username       varchar
            )
AS
$$
BEGIN
    return query (
        SELECT U.id user_id,
               U.image_url,
               U.name,
               U.username
        FROM "Users" as U
          WHERE U.country = ANY(search_country::TEXT[])
        );
        END
$$
    language plpgsql;
```

The cast is on the parameter as you call the function. It’s already typed once inside the function so no need to cast there.