From: Jomon Skariah <jomons@aztec.soft.net>
To: Rod Taylor <rbt@rbt.ca>
Cc: Kris Jurka <books@ejurka.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: MINUS & ROWNUM in PostGres
Date: Tue, 9 Sep 2003 09:44:03 +0530
Message-ID: <F83B457BE363174B8233DE042A1445705F6E96@maya.aztec.soft.net> (raw)
Hi,
Thanx for your reply.
The problem is we are using PostGres 7.1.In this version REPLACE() is not
available.
Regards
Jomon
-----Original Message-----
From: Rod Taylor [mailto:rbt@rbt.ca]
Sent: Monday, September 08, 2003 7:41 PM
To: Jomon Skariah
Cc: Kris Jurka; pgsql-sql@postgresql.org
Subject: RE: [SQL] MINUS & ROWNUM in PostGres
On Mon, 2003-09-08 at 09:44, Jomon Skariah wrote:
> Hi,
>
> Do we have any replacement for REPLACE() of Oracle in PostGres?
What does replace() do? String replacement?
http://www.postgresql.org/docs/7.3/interactive/functions-string.html
replace(string text, from text, to text)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jomons@aztec.soft.net, rbt@rbt.ca, books@ejurka.com
Subject: Re: MINUS & ROWNUM in PostGres
In-Reply-To: <F83B457BE363174B8233DE042A1445705F6E96@maya.aztec.soft.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox