From: | Dong B Calmada <dongski(at)popdem(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | 'create view' error |
Date: | 2001-09-06 13:54:56 |
Message-ID: | 20010906215456.A2065@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 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(at)yahoo(dot)com
dongski(at)calban(dot)org
-----------------------------------
Information is power! Set it free!
From | Date | Subject | |
---|---|---|---|
Next Message | Dong B Calmada | 2001-09-06 14:26:33 | 'create view' error |
Previous Message | Richard NAGY | 2001-09-06 12:14:16 | Need help or advices : databases and tables invisibles and not accessibles ! |