'create view' error

From: Dong Calmada <dongski(at)popdem(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: 'create view' error
Date: 2001-09-06 15:08:08
Message-ID: 01090623080800.02225@dongski.popdem.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-admin by date

  From Date Subject
Next Message Jeremy Buchmann 2001-09-06 16:22:29 Re: Vacuum and deadlock.
Previous Message Dong B Calmada 2001-09-06 14:26:33 'create view' error