Re: Delete de filas que no sean esta, ni esta, ....

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "Pablo Braulio" <brulics(at)gmail(dot)com>
Cc: alejandrob <alejandrob(at)ospsip(dot)org(dot)ar>, pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Delete de filas que no sean esta, ni esta, ....
Date: 2006-08-05 21:39:50
Message-ID: c2d9e70e0608051439o3a3f364fy786d49f4d608b13e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

On 8/5/06, Pablo Braulio <brulics(at)gmail(dot)com> wrote:
> alejandrob escribió:
> > podrias hacer : where fichero not in 80,78,54
> >
>

delete from ficheros_recursos_programas where fichero not in (80, 78, 54);

o si el campo es character

delete from ficheros_recursos_programas where fichero not in ('80', '78', '54');

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Jaime Casanova 2006-08-05 21:58:08 Re: Aspectos internos de PostgreSQL
Previous Message Jaime Casanova 2006-08-05 21:20:16 Re: Traduccion de documentacion fue:(Cursores)