Order in CREATE VIEW

From: "Marcin Wasilewski" <marcingrupy(at)poczta(dot)onet(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Order in CREATE VIEW
Date: 2001-04-11 08:25:24
Message-ID: 9b148t$l66$1@news.tpi.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello everybody,
Can you help me?

I have POSTGRESQL 7.0.3,
I try to create simple view by typing.

create view "xx" as select "aa.yy", "bb.yy" from "yy" order by "bb.yy"

the problem is that parameter order is not implemented with create view.
so how can I create such simple query??

Best regards
Marcin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anand Raman 2001-04-11 08:58:37 Re: plpgsql -- arrays/temporary tables?
Previous Message Alessio Bragadini 2001-04-11 07:49:16 Re: personel appliactions?