PostgreSQL Discussion - Re: ?^???G Re: A strange problem

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: ?^???G Re: A strange problem

Bruno Wolff III

2005-08-28, 3:23 am

On Sun, Aug 28, 2005 at 08:46:56 +0800,
Tang Tim Hei <timheit@netvigator.com> wrote:
>
> In the above command, I just add another table reference to it and it gives me two different results.
> Even I add columns like B.* to it, it do the same things too. Is it not consistance?
> In real world, I don't know the 'country' table is empty or not.
> Sometime it is empty and sometime it is not empty, this will confuse me whether my program has bug or not.

You might want some sort of outer join in that case.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links