寄件者: Stephan Szabo [EMAIL PROTECTED]
日期: 2005/08/28 星期日 上午 09:03:20 HKT
收件者: Tang Tim Hei [EMAIL PROTECTED]
副本: pgsql-general@postgresql.org
主旨: Re: 回覆: Re: [GENERAL] A strange problem
On Sun, 28 Aug 2005, Tang Tim Hei wrote:
±H¥???: Stephan Szabo [EMAIL PROTECTED
On Sun, 2005-08-28 at 16:22 +0800, Tang Tim Hei wrote:
The following commands are little different from the previous one.
(1) select A.* from test.currency A, test.price_list B where
A.curr_cd=B.curr_cd and A.curr_cd='USD'
(2) select A.* from test.currency A, test.price_list B, test.country
On Sun, 28 Aug 2005, Tang Tim Hei wrote:
Well, you have to write your queries to do what you want depending on such
things. For example, the above doesn't constrain the join from currency
and country and so you get multiple copies of the USD currency info for
each country. If you want
On Sat, 27 Aug 2005, Tang Tim Hei wrote:
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?
Not really. You're doing a
Tang Tim Hei [EMAIL PROTECTED] writes:
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,
寄件者: Stephan Szabo [EMAIL PROTECTED]
日期: 2005/08/27 星期六 下午 11:25:49 HKT
收件者: Tang Tim Hei [EMAIL PROTECTED]
副本: pgsql-general@postgresql.org
主旨: Re: [GENERAL] A strange problem
On Sat, 27 Aug 2005, Tang Tim Hei wrote:
Hi,
I'm new to postgresql. Anytime I type the following
On Sun, 28 Aug 2005, Tang Tim Hei wrote:
?H: Stephan Szabo [EMAIL PROTECTED]
: 2005/08/27 ?P ?U?? 11:25:49 HKT
??: Tang Tim Hei [EMAIL PROTECTED]
: pgsql-general@postgresql.org
?D??: Re: [GENERAL] A strange problem
On Sat, 27 Aug 2005, Tang Tim Hei wrote