Am 09.03.2007 um 05:30 schrieb Tom Lane:
Charlie Clark <charlie@xxxxxxxxxxxxxx> 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
