due to situations beyond my control i have a field that holds comma separated
email addresses.
create table filters (name varchar(64), filter text);
insert into filters values ('test', 'test1@test.com, test2@test.com,
test3@test.com');
filter is the field that holds the email addresses.
how do i make postgres split for me the email addresses and return me a table
so that for 'test' I get:
name | email
---------------------
test | test1@test.com
test | test2@test.com
test | test3@test.com
any help appreciated
- Martin -