Thread: 'create view' error
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!
Dong B Calmada writes: > "ERROR: ORDER BY and DISTINCT on views are not implemented." Upgrade to 7.1.3. -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
I was also thinking of that. Thanks. On Fri Sep 07, 2001 at 03:38:17PM +0200, Peter Eisentraut (peter_e@gmx.net) wrote: > Dong B Calmada writes: > > > "ERROR: ORDER BY and DISTINCT on views are not implemented." > > Upgrade to 7.1.3. > > -- > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- 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!
I was also thiking of that. Thanks. On Fri Sep 07, 2001 at 03:38:17PM +0200, Peter Eisentraut (peter_e@gmx.net) wrote: > Dong B Calmada writes: > > > "ERROR: ORDER BY and DISTINCT on views are not implemented." > > Upgrade to 7.1.3. > > -- > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- 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!
I was also thinking of that. Thanks. On Fri Sep 07, 2001 at 03:38:17PM +0200, Peter Eisentraut (peter_e@gmx.net) wrote: > Dong B Calmada writes: > > > "ERROR: ORDER BY and DISTINCT on views are not implemented." > > Upgrade to 7.1.3. > > -- > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- 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!