X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 61D9A53344 for ; Sat, 2 Apr 2005 01:21:21 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04705-05 for ; Sat, 2 Apr 2005 00:21:12 +0000 (GMT) Received: from esri3.esri.com (esrismtp2.esri.com [198.102.62.103]) by svr1.postgresql.org (Postfix) with ESMTP id 5484053783 for ; Sat, 2 Apr 2005 01:21:11 +0100 (BST) Received: from zipwire.esri.com (zipwire.esri.com [10.48.4.9]) by esri3.esri.com (8.11.6+Sun/8.11.6) with ESMTP id j320LD122550 for ; Fri, 1 Apr 2005 16:21:13 -0800 (PST) Received: by zipwire.esri.com with Internet Mail Service (5.5.2657.72) id ; Fri, 1 Apr 2005 16:21:14 -0800 Message-ID: <491DC5F3D279CD4EB4B157DDD62237F406ABE858@zipwire.esri.com> From: Jerry Day To: "'pgsql-interfaces@postgresql.org'" Subject: Problems with PQfmod() returning -1 on varchar field (libpq-8.0.0 )? Date: Fri, 1 Apr 2005 16:21:03 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/8 X-Sequence-Number: 5424 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? Thanks, Jerry L. Day