From: | Charlie Clark <charlie(at)begeistert(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Weird behaviour on a join with multiple keys |
Date: | 2007-03-09 09:23:42 |
Message-ID: | 44B978AF-E683-40ED-AA2E-DCB3BC10130C@begeistert.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Am 09.03.2007 um 05:30 schrieb Tom Lane:
> Charlie Clark <charlie(at)begeistert(dot)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?
I'm running PostgreSQL 8.1.4 on Mac OS X
psytec=# show lc_collate;
lc_collate
-------------
de_DE.UTF-8
(1 row)
psytec=# show server_encoding;
server_encoding
-----------------
LATIN1
(1 row)
I thought that it might be something to do with the encoding - one of
the tables has just been imported and I had some "fun" doing that but
it "looks" okay now. Is there a way of checking?
Charlie
--
Charlie Clark
Helmholtzstr. 20
Düsseldorf
D- 40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-03-09 09:45:18 | Re: Solaris and Ident |
Previous Message | John Sidney-Woollett | 2007-03-09 08:32:02 | Re: Anyone know a good opensource CRM that actually installs with Posgtres? |