plpgsql function docs

Поиск
Список
Период
Сортировка
Искать
От
UAP2
Тема
plpgsql function docs
Дата
Msg-id
000501c1cbe2$5c45a4c0$1000a8c0@cwjamaica.com
Список
Дерево обсуждения
plpgsql function docs "UAP2" <pactsec@cwjamaica.com>
Re: plpgsql function docs Jean-Michel POURE <jm.poure@freesurf.fr>
Re: plpgsql function docs Jeff Fitzmyers <flume33@yahoo.com>
I've been searching google for most of the morning trying to find docs on
plpgsql functions, but haven't had much luck. Can someone point me in the
right direction?

What I need to do is delete all the records in tableA that has and id that's
not listed in tableB. well actually i want it to insert it to another table
then delete, but I just need some pointers on how to find the records that
aren't in the table.

Ok if you want to know why i want to do this, it is because the literacy
project i am working for has many different sites, and at best the sites
have a dialup connection. I want it so that the data is stored locally until
they click the upload button, at which time the data is uploaded. the
problem is if they delete a record it won't be deleted on my end since it
only uploads the new data. Therefore i want the clients to send a list of
all the id's and then check for ones that aren't there, and therefore
must've been deleted.

Well anyway that is the situation i'm in. All I need is a pointer to the
docs that will tell me how to do this, but I can't find it. Thanks for your
help.

Andrew

В списке pgsql-general по дате отправления
От: Masaru Sugawara
Дата:
От: Dave Smith
Дата:
FAQ