Generating fields in views with search/replace?

From: "Asfand Qazi (Sanger Institute)" <aq2(dot)sanger(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Generating fields in views with search/replace?
Date: 2011-05-05 14:09:56
Message-ID: BANLkTinzm6szm2TXGQbaagKY3iK1YehptQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Thanks. Regards,
Asfand Qazi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-05-05 14:30:08 Re: Generating fields in views with search/replace?
Previous Message Scott Ribe 2011-05-05 14:04:39 Re: SSDD reliability