Re: Bypassing useless ORDER BY in a VIEW

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Tom Lane" <tgl@xxxxxxxxxxxxx>
Subject: Re: Bypassing useless ORDER BY in a VIEW
From: "Robins Tharakan" <tharakan@xxxxxxxxx>
Date: Fri, 29 Feb 2008 17:27:55 +0530
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <8366.1204218820@xxxxxxxxxxxxx>
References: <36af4bed0802280631ja29c636w2256fb329e14b95e@xxxxxxxxxxxxxx> <8366.1204218820@xxxxxxxxxxxxx>

Frankly put, i didn't know that this perspective exists and then thanks for putting it that way then !!

Guess I should take a relook at how I plan to use those VIEWS.

Thanks
Robins

A rule of thumb is that ORDER BY in a view is bad design, IMHO.

regards, tom lane

References:
- Bypassing useless ORDER BY in a VIEW
  - From: Robins Tharakan
- Re: Bypassing useless ORDER BY in a VIEW
  - From: Tom Lane

Prev by Date: Re: Bypassing useless ORDER BY in a VIEW
Next by Date: 12 disks raid setup
Previous by thread: Re: Bypassing useless ORDER BY in a VIEW
Next by thread: 12 disks raid setup
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux