X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 339219DC8A2 for ; Fri, 20 Jan 2006 12:39:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02029-10 for ; Fri, 20 Jan 2006 12:39:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 98E1B9DC804 for ; Fri, 20 Jan 2006 12:39:12 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k0KGdC9V018728; Fri, 20 Jan 2006 11:39:12 -0500 (EST) To: "Scott Schulthess" cc: pgsql-admin@postgresql.org Subject: Re: Returning setof records In-reply-to: <4BF377919225F449BB097CB76FFE9BC83DD7EC@ptolemy.topozone.com> References: <4BF377919225F449BB097CB76FFE9BC83DD7EC@ptolemy.topozone.com> Comments: In-reply-to "Scott Schulthess" message dated "Fri, 20 Jan 2006 11:12:18 -0500" Date: Fri, 20 Jan 2006 11:39:12 -0500 Message-ID: <18727.1137775152@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.094 required=5 tests=[AWL=0.094] X-Spam-Score: 0.094 X-Spam-Level: X-Archive-Number: 200601/240 X-Sequence-Number: 20328 "Scott Schulthess" writes: > select * from placenamesearch('Cheshire',9,'New Haven','text', 'text') > as (FeatureName varchar, CountyName varchar, State varchar, featuretype > varchar, Elevation int4,CellName varchar, PrimaryLatDD float8, > PrimaryLonDD float8); ... > state char(2), You've got the State output column declared as varchar, but actually it's char. PG will often do automatic conversion from one type to the other, but in this context it's picky... regards, tom lane