20210422.spring_data_function.sql

CREATE OR REPLACE FUNCTION some_function(some_ids UUID[])
  RETURNS TABLE (id INTEGER)
  LANGUAGE SQL
AS $$

-- ERROR: function some_function(record[]) does not exist

CREATE OR REPLACE FUNCTION some_function(VARIADIC some_ids UUID[])
  RETURNS TABLE (id INTEGER)
  LANGUAGE SQL
AS $$

// Doesnt work:
@Query(nativeQuery = true, value = "SELECT some_function(ARRAY[:uuids])")
LinkedHashSet<Integer> getSomeFunction(Collection<UUID> uuids);

// Works with VARIADIC
@Query(nativeQuery = true, value = "SELECT some_function(:uuids)")
LinkedHashSet<Integer> getSomeFunction(Collection<UUID> uuids);