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


2012/2/15 Chris Angelico <rosuav@gmail.com>
On Wed, Feb 15, 2012 at 5:26 PM, Bartosz Dmytrak <bdmytrak@eranet.pl> wrote:
> 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;

Ah, thanks for that!

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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: High checkpoint_segments
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: High checkpoint_segments