| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Marcin Wasilewski <marcingrupy(at)poczta(dot)onet(dot)pl> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: ORDER BY ???? |
| Date: | 2001-04-13 23:18:23 |
| Message-ID: | Pine.BSF.4.21.0104131613250.59463-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 11 Apr 2001, Marcin Wasilewski wrote:
> 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??
You probably want the order by on the select queries on "xx". I
believe order bys are only legal on cursor creation and direct select
statements.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nathan Myers | 2001-04-13 23:37:32 | Re: Anyone have any good addresses ... ? |
| Previous Message | The Hermit Hacker | 2001-04-13 23:17:23 | Re: Anyone have any good addresses ... ? |