On Tue, Nov 23, 2010 at 02:09:19PM +1030, Dan Kortschak wrote: > I want to be able to insert, > uniquely, biological sequences into a table returning the sequence id - > this part is fine. However, if the sequence already exists in the table > I want to return to id.
The term you're looking for is "UPSERT", the following looks relevant: http://stackoverflow.com/questions/1109061/insert-on-duplicate-update-postgresql -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
