well sorry for bothering this list and answering myself, I just came across
the array operators.
this does the trick
drop table if exists test;
create table test (id serial, data text );
insert into test VALUES(DEFAULT, 'testdata');
drop function if exists testfct();
CREATE OR REPLACE FUNCTION
Greetings!
I need the following: create an index on multiple values for a single row. My
other solution consists of a lot of duplicated rows in seperate tables and
triggers and indexes, resulting in slower performance.
The following fails on 9.2, it says ERROR: index expression cannot return a
