Re: OOP real life example (was Re: Why is MySQL more chosen - Mailing list pgsql-hackers

From Curt Sampson
Subject Re: OOP real life example (was Re: Why is MySQL more chosen
Date
Msg-id Pine.NEB.4.44.0208121447550.2317-100000@angelic.cynic.net
Whole thread Raw
In response to Re: OOP real life example (was Re: Why is MySQL more chosen  (Don Baccus <dhogaza@pacifier.com>)
List pgsql-hackers
On Sun, 11 Aug 2002, Don Baccus wrote:

> I've been wanting to point out that SQL views are really, when
> scrutinized, "just syntactic sugar" ...

Oh? Ok, please translate the following into equivalant SQL that
does not use a view:
   CREATE TABLE t1 (key serial, value1 text, value2 text);   CREATE VIEW v1 AS SELECT key, value1 FROM t1;   GRANT
SELECTON v1 TO sorin;
 

cjs
-- 
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org   Don't you know, in this new Dark Age, we're
alllight.  --XTC
 



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: cash_out bug
Next
From: Tom Lane
Date:
Subject: Re: cash_out bug