plpgsql function docs

Started by UAP2about 24 years ago3 messagesgeneral
Jump to latest
#1UAP2
pactsec@cwjamaica.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

#2Jean-Michel POURE
jm.poure@freesurf.fr
In reply to: UAP2 (#1)
Re: plpgsql function docs

Le Vendredi 15 Mars 2002 06:29, UAP2 a écrit :

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?

Interactive docs : http://www.postgresql.org/idocs/
Pro. languages : http://www.postgresql.org/idocs/index.php?programmer-pl.html

pgAdmin2 (http://pgadmin.postgresql.org) provides a GUI for writing plpgsql
functions, with syntax code highlight. It also provides PostgreSQL 7.2
documentation in winhelp format.

Cheers,
Jean-Michel POURE

#3Jeff Fitzmyers
flume33@yahoo.com
In reply to: UAP2 (#1)