On Thu, May 5, 2011 at 9:09 AM, Asfand Qazi (Sanger Institute) <aq2.sanger@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
