Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.4.1 distinct query WITHOUT order by - Mailing list pgsql-sql

From msi77
Subject Re: 8.4.1 distinct query WITHOUT order by
Date
Msg-id 10421261465901@webmail111.yandex.ru
Whole thread Raw
In response to 8.4.1 distinct query WITHOUT order by  (Gary Chambers <gwchamb@gmail.com>)
Responses Re: 8.4.1 distinct query WITHOUT order by  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-sql
Tree view 
> What are the ramifications of renaming the table (containing 8000
> rows) and creating a view of the same name?

View does not admit ORDER BY clause, at least, Standard does not. 

Sergey

pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: 8.4.1 distinct query WITHOUT order by
Next
From: Scott Marlowe
Date:
Subject: Re: 8.4.1 distinct query WITHOUT order by