Re: Easy form of "insert if it isn't already there"?
| От | Bartosz Dmytrak |
|---|---|
| Тема | Re: Easy form of "insert if it isn't already there"? |
| Дата | |
| Msg-id | CAD8_UcZY0_V8R5HDt_nFGWnax5aLuze_uR5LEGExNH1+r2SuKA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Easy form of "insert if it isn't already there"? (Chris Angelico <rosuav@gmail.com>) |
| Ответы |
Re: Easy form of "insert if it isn't already there"?
|
| Список | pgsql-general |
Yes it is.
You can implement trigger on table to check if inserted record is new. Still it is on DB side.
I don't know PHP well enough but I think You can call function e.g. SELECT myschema."InsertWhenNew" ("val1", "val2", "val3"); in the same way as You call INSERTS
Regards,
Bartek
Bartek
2012/2/15 Chris Angelico <rosuav@gmail.com>
On Wed, Feb 15, 2012 at 5:26 PM, Bartosz Dmytrak <bdmytrak@eranet.pl> wrote:Ah, thanks for that!
> Hi,
> similar topic is in NOVICE mailing
> list: http://archives.postgresql.org/pgsql-novice/2012-02/msg00034.php
>
> e.g. You can use BEGIN... EXCEPTION.... END, good example of
> such approach is
> there: http://www.postgresql.org/docs/9.1/static/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE;
Currently the query is a single PHP pg_query_params() call, and it's
inside a larger transaction. By the look of it, this requires writing
a function to do the job, rather than embedding the logic straight
into the query - is this correct?
ChrisA
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: