Received: from mta1.snfc21.pbi.net (mta1.snfc21.pbi.net [206.13.28.122]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA75330 for ; Tue, 28 Dec 1999 15:41:04 -0500 (EST) (envelope-from russ@psyex.com) Received: from [216.103.219.237] by mta1.snfc21.pbi.net (Sun Internet Mail Server sims.3.5.1999.09.16.21.57.p8) with ESMTP id <0FNG0088JXG49Z@mta1.snfc21.pbi.net> for pgsql-sql@postgresql.org; Tue, 28 Dec 1999 12:40:55 -0800 (PST) Date: Tue, 28 Dec 1999 13:56:27 -0800 From: Russ McBride Subject: Oracle sql queries To: pgsql-sql@postgresql.org Message-id: MIME-version: 1.0 Content-type: text/plain; charset="us-ascii" Will any legal Oracle sql syntax work in postgresql? I'm worried about whether tcl scripts that make sql calls to an Oracle db can be used in a postgresql without problems. I guess that brings up two issues: 1- Is the version of sql that Oracle uses legal in postgres? 2- Even if the sql is transferrable, will Oracle's odd way of handling dates screw up an attempt to transfer the sql calls? On an unrelated note: how important is having a shared sql cashe,and parallel queries for speed (which I gather postgresql doesn't have)? Tia. Russ