Re: Type scale returned by PQfmod() 65531 for time/timestamp output parameter?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sebastien FLAESCH <sf(at)4js(dot)com>
Cc: pgsql-interfaces(at)lists(dot)postgresql(dot)org
Subject: Re: Type scale returned by PQfmod() 65531 for time/timestamp output parameter?
Date: 2018-02-16 15:15:52
Message-ID: 13939.1518794152@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Sebastien FLAESCH <sf(at)4js(dot)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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Greg Sabino Mullane 2018-02-18 15:32:32 DBD::Pg version 3.7.4 released
Previous Message Sebastien FLAESCH 2018-02-16 08:56:05 Re: Type scale returned by PQfmod() 65531 for time/timestamp output parameter?