Re: How do I...

Paul Tomblin <ptomblin@xcski.com> writes:
> Oh, and if I try and cast them both to varchar, the thing freaks out:

>     waypoint=> select b.id, a.icao,a.faa_host_id from dafif_arpt a, waypoint b
>     where b.id::varchar = a.icao::varchar;
>     pqReadData() -- backend closed the channel unexpectedly.
>             This probably means the backend terminated abnormally
>             before or while processing the request.

What in the world...!?

What version are you running?  What is the full schema for both tables?
("pg_dump -s -t tablename dbname" is the best way to get the complete
schema info.)

            regards, tom lane