© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
3 replies
fuyu

plpgsql: filter new value's array field

I have a database function that goes like:
declare
    ftl sometype[] := /*filter new.items that has field x as True*/;
begin
  IF pg_trigger_depth() = 1 then
declare
    ftl sometype[] := /*filter new.items that has field x as True*/;
begin
  IF pg_trigger_depth() = 1 then

how can I filter
new.items
new.items
? is that a thing in postgres? I tried
SELECT
SELECT
ing from
new.items
new.items
but that didn't work.
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Filter based on a plpgsql function already defined
SupabaseSSupabase / help-and-questions
4y ago
Notices for plpgsql
SupabaseSSupabase / help-and-questions
4y ago
REST URL Filter: Column contains value
SupabaseSSupabase / help-and-questions
3y ago
Unable to filter on jsonb array column
SupabaseSSupabase / help-and-questions
4y ago