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
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.count
>
> 寄件者: "Stephan Szabo" <[EMAIL PROTECTED]>
> 日期: 2005/08/28 星期日 上午 09:03:20 HKT
> 收件者: "Tang Tim Hei" <[EMAIL PROTECTED]>
> 副本:
> 主旨: Re: 回覆： Re: [GENERAL] A strange problem
>
> On Sun, 28 Aug 2005, Tang Tim Hei wrote:
&g
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: [GEN
>
> 寄件者: 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,
&
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
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
