Postgres Pro
Downloads
Home   >   mailing lists

Re: simple query join - Mailing list pgsql-performance

From Dennis Bjorklund
Subject Re: simple query join
Date
Msg-id Pine.LNX.4.44.0403080846350.13979-100000@zigo.dhs.org
Whole thread Raw
In response to simple query join  ("Chris Smith" <chris@interspire.com>)
List pgsql-performance
Tree view 
On Mon, 8 Mar 2004, Chris Smith wrote:

>  assetid        | integer                     | not null default 0

>  assetid    | character varying(255) | not null default '0'

The types above does not match, and these are the attributes you use to
join.

--
/Dennis Björklund

pgsql-performance by date:

Previous
From: "Steven Butler"
Date:
Subject: Re: simple query join
Next
From: "Eric Jain"
Date:
Subject: Re: Fixed width rows faster?