if exists...does it exists for insert statments?

From: "Pau Marc Munoz Torres" <paumarc(at)gmail(dot)com>
To: "PgSQL General ML" <pgsql-general(at)postgresql(dot)org>
Subject: if exists...does it exists for insert statments?
Date: 2007-12-11 16:32:47
Message-ID: 19b5841a0712110832r27a875e9r58454a4b9c6ab09b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

could i use a sentence similar to the mysql sentence

insert if not exist into SP values ('cesp','sp');

in postgresql?

pau

--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent
Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

telèfon: 93 5812807
Email : paumarc(dot)munoz(at)bioinf(dot)uab(dot)cat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message luca.ciciriello 2007-12-11 16:36:26 POSIX and libpq
Previous Message Raymond O'Donnell 2007-12-11 16:31:40 Re: Hijack!