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