pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Eric McKeown <ericm@palaver.net>
To: pgsql-sql@postgresql.org
Subject: first post
Date: Fri, 15 May 1998 23:48:43 -0500
Message-ID: <355D1AAA.E0F1C3CF@palaver.net> (raw)

Hi there, folks.  This is my first post to this list, and I'm hoping I'm
posting to the right list from the Postgres page.  I looked at several
different ones, and this seemed to be the one most suited to this
question.

I'm using Postgresql version 6.3.1, and I'm trying to execute the
following query:


select make, model, price, yr, mileage, extcol, intcol, image from
usedcars where (make='Ford' or make='Lincoln' ) and (model='Continental
Executive' );

First results:
make|model|price|yr|mileage|extcol|intcol|image
----+-----+-----+--+-------+------+------+-----
(0 rows)

Next query:
select make, model, price, yr, mileage, extcol, intcol, image from
usedcars where (make='Lincoln' or make='Ford') and (model='Continental
Executive') ;

Results:
make   |model                |price|  yr|mileage|extcol|intcol
|image
-------+---------------------+-----+----+-------+------+------------+-----

Lincoln|Continental Executive|12000|1993|  69000|blue  |blue leather|
(1 row)

I thought these two queries were logically identical, so I don't quite
understand the differing results.  Finally, one more query.  I repeat
the first query, and:

 select make, model, price, yr, mileage, extcol, intcol, image from
usedcars where (make='Ford' or make='Lincoln') and (model='Continental
Executive') ;


make   |model                |price|  yr|mileage|extcol|intcol
|image
-------+---------------------+-----+----+-------+------+------------+-----

Lincoln|Continental Executive|12000|1993|  69000|blue  |blue leather|
(1 row)

Surprise!!!  Would anybody be able to offer me a clue on this
behavior??  I'm pretty stumped.

TIA...

eric
--
***********************************************************
Eric McKeown                              ericm@palaver.net
Palaver                              http://www.palaver.net
332 N. Market St.                    Phone:  (219) 253-8131
Monon, IN 47959                        Fax:  (219) 253-6800
***********************************************************





Message-ID: <355D1AAA.E0F1C3CF@palaver.net>
Permalink:  ../355D1AAA.E0F1C3CF@palaver.net/
Also on:    postgresql.org/message-id/355D1AAA.E0F1C3CF@palaver.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: ericm@palaver.net
  Subject: Re: first post
  In-Reply-To: <355D1AAA.E0F1C3CF@palaver.net>
  References: <355D1AAA.E0F1C3CF@palaver.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox