X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2DB4C3A55B0 for ; Mon, 24 Jan 2005 17:14:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66630-08 for ; Mon, 24 Jan 2005 17:14:28 +0000 (GMT) Received: from mail01.connectcomputer.com (unknown [66.6.71.66]) by svr1.postgresql.org (Postfix) with ESMTP id E5B673A5595 for ; Mon, 24 Jan 2005 17:14:23 +0000 (GMT) Received: from mail04.CONNECT.CONNECTAPPS.NET (unknown [172.16.2.17]) by mail01.connectcomputer.com (Postfix) with ESMTP id 630BC2575E for ; Mon, 24 Jan 2005 12:14:22 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C50238.257D822E" Subject: Moving from Transact SQL to PL/pgSQL Date: Mon, 24 Jan 2005 12:14:22 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Moving from Transact SQL to PL/pgSQL Thread-Index: AcUCOCV9giD8lznFSumhkTjNVMrl2Q== From: "Kevin Duffy" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.749 tagged_above=0 required=5 tests=FROM_ENDS_IN_NUMS, HTML_FONT_BIG, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200501/230 X-Sequence-Number: 20018 This is a multi-part message in MIME format. ------_=_NextPart_001_01C50238.257D822E Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello: =20 I am starting a project using Postgres. The requirements are very = similar to work I have done in the past using M$-SQL. Therefore, there = are many Transact SQL stored procedures I need to port over to PL/pgSQL. =20 Where would I find documentation on PL/pgSQL, with examples?=20 =20 How close to Oracle PL-SQL is Postgres? Would a Oracle PL-SQL book = cover the basics? =20 Remember be kind to the newbee. =20 =20 Kevin Duffy =20 ------_=_NextPart_001_01C50238.257D822E Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello:

I am = starting a=20 project using Postgres. The requirements are very similar to work = I have=20 done in the past using M$-SQL. Therefore, there are many Transact = SQL=20 stored procedures I need to port over to PL/pgSQL.

Where = would I find=20 documentation on PL/pgSQL, with examples?

How = close to Oracle=20 PL-SQL is Postgres? Would a Oracle PL-SQL book cover the=20 basics?

Remember be kind to=20 the newbee.

Kevin Duffy

------_=_NextPart_001_01C50238.257D822E--