Re: Like con variable

From: "Milton Galo Patricio" <minoztro(at)gmail(dot)com>
To: "Gabriel Ferro" <gabrielrferro(at)yahoo(dot)com(dot)ar>
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Like con variable
Date: 2007-02-18 22:45:37
Message-ID: 172699c50702181445x1a841881x86732139e6c540af@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

hola:

> DELETE FROM "RecibidasDes" where "Sumario" IN (SELECT "Sumario" FROM
> "Recibidas" WHERE LIKE '%Depta');

delete from "RecibidasDes" where "Sumario" IN (select "Sumario" from
"Recibidas" where like '||Depta||');

aca tienes un ejemplo que funciona:

informacion:='dbname='||$1||' user='||$2||' password='||$3||' host='||$4;

es una variable en la cual concateno algunas otras variables.

salu2!!

--
Milton Inostroza Aguilera

In response to

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Daniel Medina 2007-02-19 00:56:27 Re: [pgsql-es-ayuda] tabla pg_user Ayuda......
Previous Message Gabriel Ferro 2007-02-18 21:50:36 Like con variable