Wiki Sumber Informasi iSIKHNAS

Text array

The SQL is required. It returns an array of ID values for the codes in the input array. The requirements are rather special:

• two %s parameters
  • First one: select %s from
  • Second one: (select unnest(regexp_matches(%s,'([a-z]+)', 'igx')) as code) as dat
• join to main table: left outer join diseases s on upper(dat.code) = upper(s.code)
  • table must be aliased 's'
• other join clauses and filters