Re: How do I...

Paul Tomblin <ptomblin(at)xcski(dot)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