Re: Can column name aliases be supported? - Mailing list pgsql-general

From Craig Ringer
Subject Re: Can column name aliases be supported?
Date
Msg-id 50363583.8060608@ringerc.id.au
Whole thread Raw
In response to Re: Can column name aliases be supported?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: Can column name aliases be supported?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
On 08/23/2012 09:32 PM, Gauthier, Dave wrote:

> The view approach for queries is workable, at least for queries.  Thanks for the input on that and the idea to
replicatethe various aliases in the view! 

The key issue with all your approaches is whether the client can ever
`UPDATE` the view. If they can, and you duplicate the column under
multiple aliases, what happens when they `UPDATE` two of the aliases to
different values?

> I too would like to shoot the clients.  But as they say, the customer is always right !

Heh, I wouldn't shoot them. Fire the client means:

     http://sixrevisions.com/project-management/how-to-fire-bad-clients/

--
Craig Ringer



pgsql-general by date:

Previous
From: "Martin French"
Date:
Subject: Re: At what point does a big table start becoming too big?
Next
From: Chris Travers
Date:
Subject: Re: At what point does a big table start becoming too big?