Re: conditional insert

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_eater(at)gmx(dot)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(at)postgresql(dot)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(dot)munoz(at)bioinf(dot)uab(dot)cat*