On Tue, 2025-04-29 at 08:36 +1000, Tim Starling wrote:
> My code would be like
>
> function upsert( $table, $names, $values, $key, $set ) {
> if ( $this->type === 'mysql' ) {
> $conflict = 'ON DUPLICATE KEY UPDATE';
> } else {
> $conflict = "ON CONFLICT ($key) DO UPDATE SET";
> }
> return $this->query( "INSERT INTO $table ($names) " .
> "VALUES ($values) $conflict $set" );
> }
>
> The parameters are a little bit more structured than that, but that
> gives you the idea.
Another litle "if" to cater for PostgreSQL's "EXCLUDED." would be
such a big problem?
Yours,
Laurenz Albe