Re: [GENERAL] ERROR: JOIN/USING types 'integer' and 'character

2003-12-12 Thread Tom Lane
Oliver Elphick <[EMAIL PROTECTED]> writes: > I think the error means that you are joining on columns of differing > types. (E.g.: SELECT * FROM a JOIN b ON a.id = b.id, where a.id and > b.id are of different types.) More specifically, SELECT ... FROM a JOIN b USING (foo), where a.foo and b.foo ar

Re: [GENERAL] ERROR: JOIN/USING types 'integer' and 'character

2003-12-11 Thread Oliver Elphick
On Thu, 2003-12-11 at 20:14, Michael . wrote: > I had an error before involving a temporary table, and > that has been taken care of... > The last message I wrote where it seemed to have > needed it after I added it was because of different > \connects. Could someone please help me with this > nex