Re: "SQL" REPLACE SYNTAX - Mailing list pgsql-php

From Francisco Reyes
Subject Re: "SQL" REPLACE SYNTAX
Date
Msg-id 20020122225144.S43699-100000@zoraida.natserv.net
Whole thread Raw
In response to "SQL" REPLACE SYNTAX  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: "SQL" REPLACE SYNTAX  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-php
On Wed, 23 Jan 2002, Christopher Kings-Lynne wrote:

> Here's an idea:  look at their code to see what kind of SQL jiggery pokery
> they needed to implement it and then implement it ourselves...

I wish PostgreSQL got this functionality.
>
> BTW, from my estimates you'd need at least 4 - 6 sql queries to simulate the
> REPLACE syntax for Postgres, so why on earth would you use it?
> Chris

Why so many? It is simple enough to attempt a delete and then do an
insert.


pgsql-php by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: "SQL" REPLACE SYNTAX
Next
From: Francisco Reyes
Date:
Subject: Re: Long running queries and timeouts