Re: [SQL] Unable to read from a view - Mailing list pgsql-sql

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


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #