On Mon, 20 Jun 2011 15:32:31 -0400, Leon Match wrote:
> Hello,
>
> I am trying to re-create few objects from oracle into postgres.
>
>
I have a problem inserting a timestamp value into the table:
>
>
insert into request_queue (request_id, received_time
>
> )
>
>
values (new.request_id, SYSTIMESTAMP
>
> );
>
> How can I insert a
dynamic timestamp value in postgress, please?
>
> Thank you,
>
>
Leon
>
> leon(dot)match(at)convergia(dot)net
May be: insert into request_queue
(request_id, received_time) values (new.request_id,
(abstime(('now'::text)::timestamp(6) with time zone))::integer);
--
Regards,
Condor