Thanks for that - yes very helpful. Good to know what is possible. Dan On Tue, 2010-11-23 at 10:27 +0100, Matthieu Huin wrote: > A similar question was discussed here about 3 weeks ago : > http://archives.postgresql.org/pgsql-general/2010-11/msg00110.php > > The "UPSERT" facility not being implemented yet, I don't think it is > possible to do much better than what you came up with. > > Assuming the column(s) holding the distinctive sequence data are defined > with the UNIQUE constraint, you could adapt the example function given > in the link to the documentation in the previous thread to achieve what > you want. > > Hope this helps, > > Matthieu -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
