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
> > ----------------------------------------------------------------
> >
>