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/