Re: Weird behaviour on a join with multiple keys - Mailing list pgsql-general

From Tom Lane
Subject Re: Weird behaviour on a join with multiple keys
Date
Msg-id 21218.1173414634@sss.pgh.pa.us
Whole thread Raw
In response to Weird behaviour on a join with multiple keys  (Charlie Clark <charlie@begeistert.org>)
Responses Re: Weird behaviour on a join with multiple keys
List pgsql-general
Charlie Clark <charlie@begeistert.org> writes:
> I'm getting unexpected results on a query which involves joining two
> tables on two common variables (firstname and lastname).

That looks like it should work.  Given that you describe the columns as
"names" I'm supposing they are of textual datatypes.  Maybe you have a
messed-up encoding or locale situation that is causing the sorts to not
work properly?  What PG version is this exactly, on what platform, and
what do "show lc_collate" and "show server_encoding" say?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: On default privilege/access behavior and how to change it?
Next
From: "Ted Byers"
Date:
Subject: Re: security permissions for functions