Re: Where Clauses: IN versus =

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 12 Sep 2005 16:15:36 -0700
Message-ID: <1126566887.169629@yasure>

Tim Marshall wrote:
> DA Morgan wrote:
>

>> If your question was
>>
>> WHERE some_column = 10
>> versus
>> WHERE some_column IN (10)
>>
>> your question would make sense.

>
>
> That's actually what the question was, sorry if I garbled it.

If that was the question ... I think Andy gave you the answer.

I think the former is preferable in all cases in that it is far easier to read. Though you might want to think more in terms of x := 10; followed by WHERE some_column = x.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Sep 12 2005 - 18:15:36 CDT