Received: from mail2.panix.com (mail2.panix.com [166.84.0.213]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1BIUkE70702 for ; Mon, 11 Feb 2002 13:30:46 -0500 (EST) (envelope-from tomg@admin.nrnet.org) Received: from mailhost.nrnet.org (unknown [166.84.192.39]) by mail2.panix.com (Postfix) with ESMTP id E9A0C8E9F; Mon, 11 Feb 2002 13:29:33 -0500 (EST) Received: from admin.nrnet.org (uucp@localhost) by mailhost.nrnet.org (8.11.4/8.11.4) with UUCP id g1BIN9I07592; Mon, 11 Feb 2002 13:23:09 -0500 Received: from localhost (tomg@localhost) by admin.nrnet.org (8.9.1/8.9.1) with ESMTP id NAA24122; Mon, 11 Feb 2002 13:30:36 -0500 Date: Mon, 11 Feb 2002 13:30:36 -0500 (EST) From: Thomas Good To: "Andrew G. Hammond" Cc: Unnikrishnan Menon , pgsql-sql@postgresql.org Subject: Re: Oracle "Jobs" in PostgreSQL In-Reply-To: <20020211175408.GA26318@xyzzy.dhs.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200202/116 X-Sequence-Number: 6544 On Mon, 11 Feb 2002, Andrew G. Hammond wrote: > On Mon, Feb 11, 2002 at 08:37:21PM +0530, Unnikrishnan Menon wrote: > > Hi, > > > > I have certain packages and procedures being run as jobs in Oracle. > > How do i get to run them in PostgreSQL. > > We'd like to help you, but with a question as vague as this, it's > pretty hard. If you give us more details... I found the following doc pretty useful: http://openacs.org/doc/openacs/html/oracle-to-pg-porting.html It covers things like SYSDATE to current_date, NVL, Sequences...etc. Good luck! ------------------------------------------------------------------------ Thomas Good tomg@admin.nrnet.org Programmer/Analyst thomas@sqlclinic.net Residential Services, Behavioral Health Services Saint Vincent Catholic Medical Centers -- SQL Clinic - An Open Source Clinical Record www.sqlclinic.net ------------------------------------------------------------------------