Skip to content

Tilda Database functions: Array In

Laurent Hasson edited this page Sep 17, 2019 · 1 revision

<-- Common Helper Database Functions

Source code in PostgreSQL.helpers-start.sql

Array In

A simple set of functions to help with the sometimes awkward syntax of PostgreSQL operators. There are 3 functions that allow to test if elements of one array are included in another array.

select Tilda.In(ARRAY[1,2,3], ARRAY[2,3]);  -- For INTEGER and BIGINT
select Tilda.In(ARRAY['a','b','c'], ARRAY['a','b']);  -- For TEXT
Clone this wiki locally