pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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)




view thread (8+ messages)  latest in thread

Message-ID: <F83B457BE363174B8233DE042A1445705F6E96@maya.aztec.soft.net>
Permalink:  ../F83B457BE363174B8233DE042A1445705F6E96@maya.aztec.soft.net/
Also on:    postgresql.org/message-id/F83B457BE363174B8233DE042A1445705F6E96@maya.aztec.soft.net

 · 

reply

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