Re: problem using regexp_replace - Mailing list pgsql-sql

From gherzig@fmed.uba.ar
Subject Re: problem using regexp_replace
Date
Msg-id 4b9e9f07701f20f59fa63e18f73cb311.squirrel@www.webmail.fmed.uba.ar
Whole thread Raw
In response to Re: problem using regexp_replace  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-sql
> On 2010-01-11, gherzig@fmed.uba.ar <gherzig@fmed.uba.ar> wrote:
>
>> CREATE FUNCTION valores_sustitucion(valor_ingresado varchar[])
>> returns varchar
>> as
>> $$
>> select case
>>   $1[1] when 'Action_1' then
>>     (select descripcion from load_by_cod($1[2]))
>>
>>    when 'Action_2' then (select descripcion from pay_by_view($1[2])
>>
>>  else 'FALSE'
>> end;
>> $$ language sql;
>
>> Anybody has a hint?
>
> you are missing a )
>

Oh, thats a copy-paste problem, sory about that.
I forgot to mention, this is a 8.3 running on linux.

Gerardo



pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: problem using regexp_replace
Next
From: Andy Shellam
Date:
Subject: CHECK constraint removing brackets