Re: Generating fields in views with search/replace?

On Thu, May 5, 2011 at 9:09 AM, Asfand Qazi (Sanger Institute)
<aq2(dot)sanger(at)gmail(dot)com> wrote:
> Hi,
>
> 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.
>
> Sorry for the silly example, but is there a way for me to do this in
> Postgresql?  I'm using Postgresql 9

The mechanics of making a view do something like that is trivial, but
your example doesn't make clear why the character '0' is special and
is the one translated?

merlin