Timestamp Resolution in Postgres

Hi All,

Apologies if I posted to the wrong groups.

I am trying to use the timestamp column type in postgres. It appears that
postgres is rounding
the milliseconds to the nearest 10ms. I'm running on Solaris 8 - and my
app is written in
java which is returning dates with a 1ms accuracy. Is there a setting
somewhere to adjust
the resolution of the timestamp field? I haven't seen anything in the
documentation. Enclosed below
is a simple example which exhibits the behavior.

Thanks for any help!

Mike

Let's say I have a table called person:

create table person (
OBJECTID VARCHAR( 56),
BIRTHDAY TIMESTAMP,
NAME VARCHAR(256)
);

If I run the following command in psql:

update table person set birthday = '2001-05-03 11:12:56.343' where objectid
= '34';

followed by

select * from person where objectid = '34';

I get :

2001-05-03 11:12:56.34-07