Postgres Pro
Downloads
Home   >   mailing lists

Re: Type scale returned by PQfmod() 65531 for time/timestamp output parameter? - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Type scale returned by PQfmod() 65531 for time/timestamp output parameter?
Date
Msg-id 13939.1518794152@sss.pgh.pa.us
Whole thread Raw
In response to Re: Type scale returned by PQfmod() 65531 for time/timestamp outputparameter?  (Sebastien FLAESCH <sf@4js.com>)
Responses Re: Type scale returned by PQfmod() 65531 for time/timestamp outputparameter?  (Sebastien FLAESCH <sf@4js.com>)
List pgsql-interfaces
Tree view 
Sebastien FLAESCH <sf@4js.com> writes:
> Would be nice however to have some clear documentation about PQfmod() interpretation...
> What means exactly 65531/0xFFFB?

You could try running it through the typmodout function for the column's
datatype.  I don't offhand know of any built-in types for which that would
be a really plausible typmod, though.  Are you sure your client code isn't
mistakenly narrowing it to int16 somewhere?

            regards, tom lane

pgsql-interfaces by date:

Previous
From: Sebastien FLAESCH
Date:
Subject: Re: Type scale returned by PQfmod() 65531 for time/timestamp outputparameter?
Next
From: "Greg Sabino Mullane"
Date:
Subject: DBD::Pg version 3.7.4 released