select IN problem

From: Doug Silver <dsilver(at)quantified(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: select IN problem
Date: 2002-02-22 21:36:27
Message-ID: Pine.LNX.4.21.0202221326400.10661-100000@danzig.sd.quantified.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I've read the IN chapter in Bruce M.'s Postgresql book, but I still can't
seem to get my select/IN to work. I have two tables, transactions and
transactions_detail, with the transaction_id field as the reference in
the transactions_detail table.

# select transaction_id from transactions where enter_date> cast('2002-02-22' as date);
transaction_id
----------------
2043
2044
2045

purchases=# select transaction_id from transactions_detail where transaction_id>2042;
transaction_id
----------------
2043
2044
2045

purchases=# \d transactions_detail
Table "transactions_detail"
Attribute | Type | Modifier
----------------+-----------------------+----------
transaction_id | smallint |
products | character varying(20) |
quantities | smallint |

But the following query causes it to hang, after 10 seconds I finally stop
it.

purchases=# select transaction_id from transactions_detail where
purchases=# transaction_id IN (
purchases=# select transaction_id from transactions where enter_date> cast('2002-02-22' as date)
purchases=# );

Any suggestions?

Thanks!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Network Manager
Quantified Systems, Inc
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Pam Wampler 2002-02-22 21:51:08 Question 7.1.3>>7.2
Previous Message john-paul delaney 2002-02-22 21:11:42 Re: Nu-B\Column:Alter type