--- Erik Jones <erik@xxxxxxxxxx> wrote: > > On Dec 6, 2007, at 2:36 PM, Ted Byers wrote: > > [snip] > What you want to do here for handling the update v. > insert is called > an "UPSERT". Basically, what you do is run the > update as if the row > exists and catch the exception that is thrown if it > doesn't at which > point you insert the record with the end date = > now(). After that > you can proceed normally with creating the new > record with start date > = now() and end date = NULL. > Thanks Eric. Do you know of an URL where this is discussed or where I can find an example. None of my books discuss this, and my search using google has so far produced only noise. Thanks again. Ted ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
