X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D4C9DD1B4FF for ; Tue, 9 Sep 2003 12:19:34 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 92747-02 for ; Tue, 9 Sep 2003 09:19:06 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id DAA32D1B508 for ; Tue, 9 Sep 2003 09:19:02 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 294661024D; Tue, 9 Sep 2003 08:10:37 -0400 (EDT) Received: from [192.168.1.200] (dyn-133-83.tor.dsl.tht.net [134.22.133.83]) by mailav.tor1.inquent.com (Postfix) with ESMTP id F3DED10248; Tue, 9 Sep 2003 08:10:34 -0400 (EDT) Subject: Re: MINUS & ROWNUM in PostGres From: Rod Taylor To: Jomon Skariah Cc: Kris Jurka , pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-6LCwGqYFSI1/b8Y/3+zS" Message-Id: <1063109954.65347.93.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Tue, 09 Sep 2003 08:19:14 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/60 X-Sequence-Number: 15038 --=-6LCwGqYFSI1/b8Y/3+zS Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > The problem is we are using PostGres 7.1.In this version REPLACE() is not > available. It sounded like you were just starting to work on the change over. I highly suggest upgrading to 7.3 at the very least, 7.4 if you're going to be a few months prior to going to production. A ton of good work has been put into PostgreSQL in the last couple of years. Anyway, you'll need to write your own replace() if you stick with that release. --=-6LCwGqYFSI1/b8Y/3+zS Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD8DBQA/XcVB6DETLow6vwwRApwyAJ4rxKsroQ3jQqb61bvDT8qv6NpdJgCcC7yF FZUg4oTIoK2ZJmm+L2ftlkg= =gqSo -----END PGP SIGNATURE----- --=-6LCwGqYFSI1/b8Y/3+zS--