pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedINSERT OR UPDATE WITHOUT SELECT
2+ messages / 2 participants
[nested] [flat]
* INSERT OR UPDATE WITHOUT SELECT
@ 2006-05-30 20:47 wmiro@ig.com.br <wmiro@ig.com.br>
0 siblings, 1 reply; 2+ messages in thread
From: wmiro@ig.com.br @ 2006-05-30 20:47 UTC (permalink / raw)
To: pgsql-performance
Hi,
Is there a command to Insert a record If It does not exists and a update if
It exists?
I do not want to do a select before a insert or update.
I mean the postgres should test if a record exist before insert and if It
exist then the postgres must do an update instead an insert.
Thanks,
WMiro.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: INSERT OR UPDATE WITHOUT SELECT
@ 2006-06-04 07:40 A. Kretschmer <andreas.kretschmer@schollglas.com>
parent: wmiro@ig.com.br <wmiro@ig.com.br>
0 siblings, 0 replies; 2+ messages in thread
From: A. Kretschmer @ 2006-06-04 07:40 UTC (permalink / raw)
To: pgsql-performance
am 30.05.2006, um 17:47:47 -0300 mailte wmiro@ig.com.br folgendes:
> Hi,
>
> Is there a command to Insert a record If It does not exists and a update if
> It exists?
Not a single command, but a solution:
http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-06-04 07:40 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-30 20:47 INSERT OR UPDATE WITHOUT SELECT wmiro@ig.com.br <wmiro@ig.com.br>
2006-06-04 07:40 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
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