Re: problem using regexp_replace

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: problem using regexp_replace
Date: 2010-01-11 08:28:36
Message-ID: hienfk$8da$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2010-01-11, gherzig(at)fmed(dot)uba(dot)ar <gherzig(at)fmed(dot)uba(dot)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 )

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message gherzig 2010-01-11 10:33:33 Re: problem using regexp_replace
Previous Message gherzig 2010-01-11 00:29:07 problem using regexp_replace