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(at)indiana(dot)edu>
> To: <pgsql-general(at)postgresql(dot)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
> > ----------------------------------------------------------------
> >
>