From: | sri harsha <sriharsha9992(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Change in order of criteria - reg |
Date: | 2016-06-01 04:07:26 |
Message-ID: | CAP6OGLH63XaFAVMBQzp91DthPU1R_bWUeG4nr24r=pax2kwH4w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi,
In PostgreSQL , does the order in which the criteria is given matter ??
For example
Query 1 : Select * from TABLE where a > 5 and b < 10;
Query 2 : Select * from TABLE where b <10 and a > 5;
Are query 1 and query 2 the same in PostgreSQL or different ?? If its
different , WHY ??
Thanks,
Harsha
From | Date | Subject | |
---|---|---|---|
Next Message | Venkata Balaji N | 2016-06-01 05:54:58 | Re: After replication failover: could not read block X in file Y read only 0 of 8192 bytes |
Previous Message | Tom Lane | 2016-06-01 03:46:42 | Re: postgres_fdw and Kerberos authentication |
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2016-06-01 04:15:01 | Re: Question and suggestion about application binary compatibility policy |
Previous Message | Craig Ringer | 2016-06-01 04:06:25 | Re: PostmasterPid not marked with PGDLLIMPORT |