'create view' error - Mailing list pgsql-admin

From Dong B Calmada
Subject 'create view' error
Date
Msg-id 20010906215456.A2065@popdem.org
Whole thread Raw
Responses Re: 'create view' error
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 words_v 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.

--
DONG B. CALMADA
Polmap Chief Information Officer
Institute for Popular Democracy
http://www.ipd.ph
Tel. (63-2) 4346674
Fax (63-2) 9262893
Mobile Phone No. 0917-9339099
Alternate email addresses:
dongski4martin@yahoo.com
dongski@calban.org

-----------------------------------
Information is power!  Set it free!

pgsql-admin by date:

Previous
From: Dong B Calmada
Date:
Subject: 'create view' error
Next
From: Dong Calmada
Date:
Subject: 'create view' error