From: | "UAP2" <pactsec(at)cwjamaica(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | plpgsql function docs |
Date: | 2002-03-15 05:29:18 |
Message-ID: | 000501c1cbe2$5c45a4c0$1000a8c0@cwjamaica.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-03-15 05:32:51 | Re: pgmonitor |
Previous Message | Lance Ellinghaus | 2002-03-15 05:18:50 | pgmonitor |