Change in order of criteria - reg

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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