i don't see it clear, let me put an example i got the following table
molec varchar(30) seq varchar(100) where I insert my values lets image that i have a record introduced as ('ubq', 'aadgylpittrs') how i can prevent to insert another record where molec='ubq' ? thanks 2011/9/5 Thomas Kellerer <spam_ea...@gmx.net> > Pau Marc Muñoz Torres, 05.09.2011 11:38: > > Hi follk >> >> i trying to performe a conditional insert into a table, indeed, what >> i'm trying to do is not insert a record into the table if that record exist >> >> googleling i found something like >> >> insert into XX values (1,2,3) where not exist (select ....); >> >> but i'm having and error near where... >> anyone knows how do i can perfome this insert? >> > > INSERT INTO xxx > SELECT 1,2,3 > WHERE NOT EXISTS (SELECT ...) > > Regards > Thomas > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> > -- *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: (+34)935 86 89 39* Email : paumarc.mu...@bioinf.uab.cat*