Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-21 Thread Leon Match
Kussama [mailto:osvaldo.kuss...@gmail.com] Sent: Monday, June 20, 2011 3:45 PM To: Leon Match Subject: Re: [GENERAL] insert a SYSTIMESTAMP value in postgres 2011/6/20 Leon Match : > Hello, > > I am trying to re-create few objects  from oracle into postgres. > > I have a prob

Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-20 Thread Jaime Casanova
El 20/06/2011 14:33, "Leon Match" escribió: > > 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 > >

Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-20 Thread Condor
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_

Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-20 Thread David Johnston
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Leon Match Sent: Monday, June 20, 2011 3:33 PM To: pgsql-general@postgresql.org Subject: [GENERAL] insert a SYSTIMESTAMP value in postgres Hello, I am trying to re-create few objects from orac

Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-20 Thread Scott Ribe
On Jun 20, 2011, at 1:32 PM, Leon Match wrote: > How can I insert a dynamic timestamp value in postgress, please? < http://www.postgresql.org/docs/9.0/static/functions-datetime.html> -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via p

[GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-20 Thread Leon Match
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, SYSTIME