Asfand Qazi (Sanger Institute) wrote:
>
> Say I have a table with fields 'template' and 'original_letter', and
> 'new_selected_letter'. 'template' could be 'abcdefg0abcdefg',
> original_letter could be 'A' and new_selected_letter could be 'B'.
>
> I want a view where I see 2 fields: 'original' as 'abcdefgAabcdefg'
> and 'new_selected' as 'abcdefgBabcdefg', where the view has replaced
> the '0' with original_letter or new_selected_letter respectively.
Well, in 8.4.7 you'd use something like:
create view xyz as
select regexp_replace(template, '0', original_letter) as original,
regexp_replace(template, '0', new_selected_letter) as new_selected
from template_table;
Should be the same in 9.x.
(See docs for more info on the regexp_replace() function)
HTH.
Later,
Bosco.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
