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 cartesian join between test.currency and test.country. If there are no rows in test.country, there are no rows in the output of the from clause. > select A.* from test.currency A, test.country B where A.curr_cd='USD' ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
