Thread: 'create view' error

'create view' error

From
Dong B Calmada
Date:
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!

Re: 'create view' error

From
Peter Eisentraut
Date:
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


Re: 'create view' error

From
Dong B Calmada
Date:
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!

Re: 'create view' error

From
Dong B Calmada
Date:
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!

Re: 'create view' error

From
Dong B Calmada
Date:
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!