plpgsql function docs
От | UAP2 |
---|---|
Тема | plpgsql function docs |
Дата | |
Msg-id | 000501c1cbe2$5c45a4c0$1000a8c0@cwjamaica.com обсуждение исходный текст |
Ответы |
Re: plpgsql function docs
Re: plpgsql function docs |
Список | pgsql-general |
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 по дате отправления: