# Re: Another motivational example for inverse view

From: NENASHI, Tegiri <tnmail42_at_gmail.com>

Date: Wed, 15 Nov 2006 17:06:17 +0100 (CET)

Message-ID: <Xns987C710B1479Aasdgba_at_194.177.96.26>

Date: Wed, 15 Nov 2006 17:06:17 +0100 (CET)

Message-ID: <Xns987C710B1479Aasdgba_at_194.177.96.26>

"Aloha Kakuikanu" <aloha.kakuikanu_at_yahoo.com> wrote in news:1163554254.753687.167440_at_f16g2000cwb.googlegroups.com:

> Consider

*>
**> table PolarCoordinates (
**> theta real,
**> R real,
**> )
**>
**> with constraints R>0, 0<=theta<pi
**>
**> view CartesianCoordinates
**> select R*cos(theta) AS x, R*sin(theta) AS y
**> from PolarCoordinates
**>
**> This view is clearly updateable, all we need to do is to apply inverse
**> mapping to the any tuple inserted/updated/deleted.
**>
**> We can even write inverse view explicitly:
**>
**> view PolarCoordinates
**> select sqrt(x*x+y*y) AS R, arcsin(y/sqrt(x*x+y*y)) as theta
**> from PolarCoordinates
**>
*

-- TegiReceived on Wed Nov 15 2006 - 17:06:17 CET