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(at)test(dot)com, test2(at)test(dot)com,
test3(at)test(dot)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(at)test(dot)com
test | test2(at)test(dot)com
test | test3(at)test(dot)com
any help appreciated
- Martin -