| From: | Jomon Skariah <jomons(at)aztec(dot)soft(dot)net> |
|---|---|
| To: | Rod Taylor <rbt(at)rbt(dot)ca> |
| Cc: | Kris Jurka <books(at)ejurka(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: MINUS & ROWNUM in PostGres |
| Date: | 2003-09-09 04:14:03 |
| Message-ID: | F83B457BE363174B8233DE042A1445705F6E96@maya.aztec.soft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)rbt(dot)ca]
Sent: Monday, September 08, 2003 7:41 PM
To: Jomon Skariah
Cc: Kris Jurka; pgsql-sql(at)postgresql(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | R. van Twisk | 2003-09-09 06:43:47 | Re: plpgsql doesn't coerce boolean expressions to boolean |
| Previous Message | Tom Lane | 2003-09-08 23:35:23 | Re: undefine currval() |