Postgres Pro
Downloads
Home   >   mailing lists

Change in order of criteria - reg - Mailing list pgsql-hackers

From sri harsha
Subject Change in order of criteria - reg
Date
Msg-id CAP6OGLH63XaFAVMBQzp91DthPU1R_bWUeG4nr24r=pax2kwH4w@mail.gmail.com
Whole thread Raw
Responses Re: Change in order of criteria - reg
Re: Change in order of criteria - reg
List pgsql-hackers
Tree view

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

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: PostmasterPid not marked with PGDLLIMPORT
Next
From: Craig Ringer
Date:
Subject: Re: Question and suggestion about application binary compatibility policy