Re: Returning setof records - Mailing list pgsql-admin

"Scott Schulthess" <scott@topozone.com> 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