Done a bit of hunting and can't seem to find an answer as to if this sort of thing is possible:
SELECT * FROM mail WHERE recipients ILIKE 'david%';
Where recipients is a VARCHAR(128)[]
The above doesn't work but thats the sort of thing I want to do...
If this is possible and can use an index as well that would be wonderful...
--