'create view' error - Mailing list pgsql-admin

From Dong Calmada
Subject 'create view' error
Date
Msg-id 01090623080800.02225@dongski.popdem.org
Whole thread Raw
List pgsql-admin
Hi. This is a newbie concern.

I'm trying to create a view from a relation called 'words'. This is what my
command looked like:

create view v_words as select term, meaning1 from words order by term;

I was greeted with an error message, that is:
"ERROR: ORDER BY and DISTINCT on views are not implemented."

I'm using version 7.0.2-17.

Thanks for your help.


pgsql-admin by date:

Previous
From: Dong B Calmada
Date:
Subject: 'create view' error
Next
From: Jeremy Buchmann
Date:
Subject: Re: Vacuum and deadlock.