| 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: | Whole Thread | Raw Message | 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 ! |