Skip site navigation (1) Skip section navigation (2)

Re: Problems with PQfmod() returning -1 on varchar f

From: Jerry Day <jerry_day(at)esri(dot)com>
To: "'Michael Fuhr'" <mike(at)fuhr(dot)org>, Jerry Day <jerry_day(at)esri(dot)com>
Cc: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Problems with PQfmod() returning -1 on varchar f
Date: 2005-04-04 18:00:56
Message-ID: 491DC5F3D279CD4EB4B157DDD62237F406ABE85A@zipwire.esri.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Michael,

The relevant column is defined as 'DATA VARCHAR(20) NOT NULL'. Query
attname, attnum, atttypid, atttypmod returns:

"data";1;"character varying";24
"int16_col";2;"smallint";-1
"int64_col";3;"bigint";-1
"float32_col";4;"real";-1
"float64_col";5;"double precision";-1
"date_col";6;"timestamp without time zone";-1
"row_id";7;"integer";-1

Thanks,

Jerry

_|_|
_|_| ESRI
Jerry L. Day
Software Developer
(909)793-2853 Ext. 1477
jerry_day(at)esri(dot)com

-----Original Message-----
From: Michael Fuhr [mailto:mike(at)fuhr(dot)org]
Sent: Saturday, April 02, 2005 5:56 PM
To: Jerry Day
Cc: 'pgsql-interfaces(at)postgresql(dot)org'
Subject: Re: [INTERFACES] Problems with PQfmod() returning -1 on varchar
field (libpq-8.0.0 )?


On Fri, Apr 01, 2005 at 04:21:03PM -0800, Jerry Day wrote:
> 
> 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? 

Are you sure the column has a length specifier?  What does "\d tablename"
show, or what's the result of the following query?

SELECT attname, attnum, atttypid::regtype, atttypmod
FROM pg_attribute
WHERE attrelid = 'tablename'::regclass
  AND attnum >= 1
  AND attisdropped IS FALSE
ORDER by attnum;

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-interfaces by date

Next:From: Marvin BellamyDate: 2005-04-04 20:58:12
Subject: libpq and referencing data type OIDs
Previous:From: Jerry DayDate: 2005-04-04 17:54:15
Subject: Re: Problems with PQfmod() returning -1 on varchar f

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group