Re: Proposal for SYNONYMS

On Thu, Mar 09, 2006 at 04:42:43PM -0500, Jonah H. Harris wrote:
> On 3/9/06, Josh Berkus <josh@agliodbs.com> wrote:
> 
>     1) Is there a SQL standard for this?
> 
> 
> Nope.
> 
> 
>     2) For my comprehension, what's the difference between a SYNONYM and a
>     single-object (possibly updatable) view?
> 
> 
> Not a whole lot actually.  If we had updateable views, I'd suggest that people
> change their create synonym syntax to create view.  However, it would take
> substantially more work to implement updatable views than synonyms and the
> functionality of updatable views is substantially different than the use of
> synonyms alone.  If/when updatable views are implemented, I wouldn't have a
> problem switching create synonym to actually create a view.

Since updateable views are relatively easy to construct using rules
I'm not sure an entire new syntax is necessary.

--elein
elein@varlena.com

> 
> --
> Jonah H. Harris, Database Internals Architect
> EnterpriseDB Corporation
> 732.331.1324