On Wed, Apr 29, 2015 at 1:05 PM, Melvin Davidson <melvin6...@gmail.com> wrote:
> What you suggest is a new column type, and that would be something that > needs to be reviewed and implemented by the PostgreSQL developers. Since it > is not a SQL standard, I doubt it has much chance of implementation. That > being said, you should understand that all triggers require the need for an > associated trigger function. A simpler way to accomplish "WORM" is with a > RULE. > EG: > CREATE RULE table_worm AS ON UPDATE TO your_table WHERE NEW.your_column <> > OLD your_column DO NOTHING. > > http://www.postgresql.org/docs/9.3/interactive/sql-createrule.html > > > Thanks. I "jumped the gun" and haven't gotten to RULEs in the book yet. Lucky I like to read & have some time right now. > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. > -- If you sent twitter messages while exploring, are you on a textpedition? He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown
