From: | Travis Bauer <trbauer(at)indiana(dot)edu> |
---|---|
To: | Anand Raman <araman(at)india-today(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: problem with nested views |
Date: | 2000-04-29 05:34:55 |
Message-ID: | Pine.GSO.4.21.0004290028180.12129-100000@mantaray.cs.indiana.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
> > ----------------------------------------------------------------
> >
>
From | Date | Subject | |
---|---|---|---|
Next Message | Marcel Sierra | 2000-04-29 11:32:17 | Objective : 1st. aplication with Tcl/Tk and Postgres |
Previous Message | Tom Lane | 2000-04-29 04:01:24 | Re: 7.0RC1: possible query and backend problem |