Sql result b where condition - Mailing list pgsql-performance

From ramasubramanian
Subject Sql result b where condition
Date
Msg-id C4A7A9FD054F4922BF24B03489A3F2FE@ramasubramanian
Whole thread Raw
In response to Dynamic sql example  ("ramasubramanian" <ramasubramanian.g@renaissance-it.com>)
Responses Re: Sql result b where condition
List pgsql-performance
Hi all,
    I have a table emp. using where condition can i get the result
prioritized.
Take the example below.

select ENAME,ORIG_SALARY from employee where (ename='Tom' and
orig_salary=2413)or(orig_salary=1234 )

if the fist condition(ename='Tom' and orig_salary=2413) is satified then 10
rows will be returned, for the second condition (orig_salary=1234 ) there
are 20 rows will be returned.
The order of display should be

The first 10 rows then
next 20 rows.
Thanks & Regards,
Ram



pgsql-performance by date:

Previous
From: Reid Thompson
Date:
Subject: Re: Fragmentation/Vacuum, Analyze, Re-Index
Next
From: "A. Kretschmer"
Date:
Subject: Re: Sql result b where condition