Re: problem with nested views

What do you mean by "properly qualifying?"  The query would look something
like this:

select keyword.token, keyword.value as kvalue, globalkw.value from
keyword, globalkw where keyword.token=globalkw.token;

A single record in globalkw should match multiple records in keyword.  The
single record in globalkw comes from an agregate function over
keyword.

The curious thing is that if I execute the command:

create table tglobalkw as select * from globalkw;

Then run the above select statement over tglobalkw instead of over
globalkw, then it works fine.

Any advice on this would help me a lot.  If this doesn't work, my Java
application has to do a lot more work.  I'm trying to pass off these
calculations to the database.

----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

On Sat, 29 Apr 2000, Anand Raman wrote:

> Hi Travis
> technically there shouldnt be any problems with such a setup.. Are u
> properly qualifying all the columns.. Just a thought
> Hope this helps
> Anand
>
> ----- Original Message -----
> From: Travis Bauer <trbauer@indiana.edu>
> To: <pgsql-general@postgresql.org>
> Sent: Friday, April 28, 2000 10:08 PM
> Subject: [GENERAL] problem with nested views
>
>
> > Can I create views based on a combination of an existing view and the
> > table on which it was originally based?  When I try this, I am getting no
> > error, but the numbers in some columns of the resulting view are not
> > correct.
> >
> > Thanks,
> >
> > ----------------------------------------------------------------
> > Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
> > ----------------------------------------------------------------
> >
>