Tom Lane wrote:
>"Oliver Elphick" <[EMAIL PROTECTED]> writes:
>> A view creates a virtual table; there is no implicit ordering in a table,
>> so it follows that you should not be able to impose one in a view.
>
>This is indeed the pure-SQL attitude, but it may be worth pointing out
>th
"Oliver Elphick" <[EMAIL PROTECTED]> writes:
> A view creates a virtual table; there is no implicit ordering in a table,
> so it follows that you should not be able to impose one in a view.
This is indeed the pure-SQL attitude, but it may be worth pointing out
that Postgres 7.1 does allow ORDER B
On Wed, Apr 11, 2001 at 10:25:24AM +0200, 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 no
"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.
