Re: changing multiple pk's in one update - Mailing list pgsql-sql

From Richard Broersma
Subject Re: changing multiple pk's in one update
Date
Msg-id 396486430904131002p3faa978fn69bab2872a017436@mail.gmail.com
Whole thread Raw
In response to Re: changing multiple pk's in one update  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-sql
On Fri, Apr 10, 2009 at 11:20 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:

> Generally speaking, when you need to do this more than once or twice
> in the lifetime of your data, there's something wrong with your data
> model.

True, but there are a few non-traditional data models that would
benefit from this feature.   The two that come to my mind are the
Celko nested set tree model, and sequenced temporal tables.


-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug


pgsql-sql by date:

Previous
From: Stuart McGraw
Date:
Subject: Re: changing multiple pk's in one update
Next
From: Stuart McGraw
Date:
Subject: Re: changing multiple pk's in one update