Richard Broersma Jr wrote: > --- On Mon, 12/10/07, Ted Byers <r.ted.byers@xxxxxxxxxx> wrote: > > > but how do you > > do it using SQL in an RDBMS? > > I believe that there is an ANSI SQL command "MERGE" that is yet to be implemented into PostgreSQL. IIRC the standard's definition of MERGE is still subject to the race condition :-) It seems mostly defined for OLAP, and assumes rather static data. -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J "La tristeza es un muro entre dos jardines" (Khalil Gibran) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
