From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200504030126.j331QYV24193@candle.pha.pa.us>
Subject: Re: Problems with PQfmod() returning -1 on varchar field
In-Reply-To: <491DC5F3D279CD4EB4B157DDD62237F406ABE858@zipwire.esri.com>
To: Jerry Day <jerry_day@esri.com>
Date: Sat, 2 Apr 2005 20:26:34 -0500 (EST)
Cc: "'pgsql-interfaces@postgresql.org'" <pgsql-interfaces@postgresql.org>
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Jerry Day wrote:
> Hi all,
> 
> I've recently encountered a situation where PQfmod() fails to return the
> defined length of a varchar field referenced in a query, as expected -
> returning no information (-1), instead. Has anyone else encountered this
> issue? If so, why does this occur? Can you recommended a method to more
> reliably obtain the length of varchar fields, as defined in the relations
> referenced by a query? 

Can we see the query?  I suspect the column is being manipulated in some
way and the length isn't carried through to the query output --- if so,
there might not be much we can do about it.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073