[postgis-users] PostGIS query layer in ArcMap - Double valueslooklike integers

[Sheara Cohen]

Rob - That was exactly the problem. I had no idea that setting was in there (or where it was). Thank you!

Sheara


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of Robert_Clift at doh.state.fl.us
Sent: Tue 6/28/2011 1:06 PM
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] PostGIS query layer in ArcMap - Double valueslooklike integers
 
Could it be the Rounding settings in the Number Format dialog? You can
access the Number Format dialog by clicking the [...] to the right of
the word "Numeric" in the Field Properties dialog.
 
-Rob
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Sheara Cohen
Sent: Tuesday, June 28, 2011 3:17 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] PostGIS query layer in ArcMap - Double values
looklike integers



Does anyone know why the values in a double field would appear like
integers when a PostGIS file is viewed as a query layer in ArcMap?

In other words, I've added a PostGIS table as a query layer to ArcMap,
and when I open the attribute table, several fields only have integer
values (no decimal places) even though you can check the properties of
those fields and verify that they are indeed double. When the same table
is viewed in PGAdmin the values display with all their appropriate
decimal places.

What gives?

Thank you.

Sheara 


-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3651 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110628/8fa2ae32/attachment.bin>