order after WHERE clause - Mailing list pgsql-sql

From Kovacs Zoltan
Subject order after WHERE clause
Date
Msg-id Pine.LNX.4.21.0105281833300.14681-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
Responses Re: order after WHERE clause  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Is it possible that I get different query result time if I change two
parts of the WHERE clause? I.e.,

SELECT * FROM table WHERE col1 = 5 AND col2 = 6;

and

SELECT * FROM table WHERE col2 = 6 AND col1 = 5;

In general, is it important how I define the ordering in a WHERE clause?

TIA, Zoltan

--                         Kov\'acs, Zolt\'an                        kovacsz@pc10.radnoti-szeged.sulinet.hu
          http://www.math.u-szeged.hu/~kovzol                        ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz
 



pgsql-sql by date:

Previous
From: Linh Luong
Date:
Subject: Seq Scan
Next
From: Tom Lane
Date:
Subject: Re: order after WHERE clause