Search Postgresql Archives

Re: Generating fields in views with search/replace?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, May 5, 2011 at 8:37 PM, Bosco Rama <postgres@xxxxxxxxxxxxx> wrote:
> 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.
>


Ah.... thanks, that's perfect.

I won't be using a '0', I'll be using some non-printable ASCII
character in the template, but the concept was the same.

Again, many thanks.  Regards,
      Asfand Qazi

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux