A strange problem

From: Tang Tim Hei <timheit(at)netvigator(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: A strange problem
Date: 2005-08-27 15:00:07
Message-ID: 20050827150007.JIDL22426.wmail03dat.netvigator.com@mail.netvigator.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I'm new to postgresql. Anytime I type the following command to the database to run, it give me no result record if table 'country' is empty but can get result if 'country' is not empty. Is this so strange?

select A.* from test.currency A, test.country B where A.curr_cd='USD'

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-08-27 15:24:34 Re: A strange problem
Previous Message Tom Lane 2005-08-27 14:48:32 Re: POSS. FEATURE REQ: "Dynamic" Views