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, test.country B where A.curr_cd='USD'
You're doing an unconstrained join on "currency" and "country", and if one of those two tables is empty the result will be empty. -Doug ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
