order after WHERE clause

From: Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: order after WHERE clause
Date: 2001-05-28 16:37:18
Message-ID: Pine.LNX.4.21.0105281833300.14681-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu
http://www.math.u-szeged.hu/~kovzol
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-05-28 17:47:00 Re: Problems with pg_dump (on Debian i386)
Previous Message Linh Luong 2001-05-28 16:24:41 Seq Scan