On Wed, Jun 22, 2011 at 3:37 PM, Joshua D. Drake <j...@commandprompt.com>wrote:
> Per: > > http://archives.postgresql.**org/pgsql-hackers/2010-11/**msg02043.php<http://archives.postgresql.org/pgsql-hackers/2010-11/msg02043.php> > > It seems we did come up with a use case in the procpid discussion. The > ability to change the names of columns/databases etc, to handle the fixing > of bad decision decisions during development over time. > > Thoughts? > Instead of just synonyms of columns, why don't we think about implementing virtual columns (feature as named in other RDBMS). This is the ability to define a column in a table which is derived using an expression around other non-virtual columns. I agree it would be much more difficult and some may even argue it is pointless in the presence of views and expression indexes, but I leave that as an exercise for others. Regards, -- Gurjeet Singh EnterpriseDB Corporation The Enterprise PostgreSQL Company