From: | Gregory Holston <holston(at)itd(dot)nrl(dot)navy(dot)mil> |
---|---|
To: | Jan Wieck <jwieck(at)debis(dot)com> |
Cc: | pgsql-sql(at)hub(dot)org |
Subject: | Re: [SQL] Unable to read from a view |
Date: | 1999-02-24 22:03:18 |
Message-ID: | Pine.SUN.3.91.990224170139.20096D-100000@shell |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Wed, 24 Feb 1999, Jan Wieck wrote:
> >
> >
> > Hi all,
> >
> > I just created a view and have been unable to read from it. I am
> > Apache/1.3.1 (Unix) PHP/3.0.3 and Postgres 6.4. When I tried to do a
> > select it gives the following error message:
> >
> > real=> select * from pubsearch;
> > ERROR: nodeRead: Bad type 0
> >
> > I created the view with the following select statment:
> >
> > select distinct users.firstname, users.lastname, publication.title,
> ^^^^^^^^
>
> DISTINCT isn't supported in view definitions. You can SELECT
> from view's distinct, but you cannot define them to be. Nor
> could you define views with group by and order by.
I have tried to drop the view and it gives the same error message. Is
there any way to get rid of them (2).
Thanks for the help,
-Greg
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Hagerty | 1999-02-25 01:25:12 | OUTER JOINS in 6.4.2?? Work around?? |
Previous Message | Jan Wieck | 1999-02-24 22:01:38 | Re: [SQL] Unable to read from a view |