Hello
On 11/12/2007, Pau Marc Munoz Torres <paumarc@xxxxxxxxx> wrote:> could i use a sentence similar to the mysql sentence>> insert if not exist into SP values ('cesp','sp');>
insert into sp select 'cesp','sp' except select * from SP;
RegardsPavel Stehule
> 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.munoz@xxxxxxxxxxxxxx
---------------------------(end of broadcast)---------------------------TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
