Skip site navigation (1) Skip section navigation (2)

Re: Should we drop the "object" from ORDBMS?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: chris(dot)travers(at)gmail(dot)com, direvus(at)gmail(dot)com, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Should we drop the "object" from ORDBMS?
Date: 2012-04-27 06:44:48
Message-ID: 1335509088.28653.67.camel@jdavis (view raw, whole thread or download thread mbox)
Lists: pgsql-advocacy
On Thu, 2012-04-26 at 07:12 -0500, Kevin Grittner wrote:
> We use dot syntax heavily, and I consider it a valuable feature.  For
> example, names are stored in our database with separate columns for
> last name, first name, middle name, suffix (Jr., III, etc.), but we
> want to put those together in a canonical form for searching.  Prior
> to PostgreSQL we have a trigger-maintained column in the database for
> this for each name.  With PostgreSQL we were able to replace the
> column with a function without changing any of our application code
> or the queries they use.

Interesting hack; I hadn't thought of that.

I don't quite understand what you are advocating below:
> I would be very unhappy to see this feature deprecated or removed.  I
> would much rather see functions which qualify as "generated columns"
> (i.e., they have as their only parameter the record type of a table)
> listed in the \d display for a table.

But if you are saying we should have explicit support for generated
columns, that sounds reasonable to me. That matches more closely what
you are trying to do, and keeps the namespace cleaner.

Another concept similar to generated columns is if we had simple-to-use
updatable views.

	Jeff Davis

In response to

pgsql-advocacy by date

Next:From: Jeff DavisDate: 2012-04-27 07:05:52
Subject: Re: Should we drop the "object" from ORDBMS?
Previous:From: Josh BerkusDate: 2012-04-26 19:48:48
Subject: Re: Should we drop the "object" from ORDBMS?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group