Re: Stored Procedures

Wendy,

> Here I'm referring to a "C struct" ... a data structure containing
> several values.  For instance, I might have a struct defined as
> followed:
>
>   struct person {
>      char name[10],
>       char address[30],
>        int  age };
>
> containing the name, address & age of a particular person.

Ah.  I see what you're attempting.

I'm not sure that you want to operate through functions at all.  There
is a very hefty C library for direct Postgres interaction.  You can
look it up in the online docs, or buy a book (such as Wrox Press's
Postgres book) which covers C + Postgresql programming.

That's as much as I know ... I'm a SQL jockey, and don't do C.

> What do you mean by a record here?  Sorry, I'm new to the postgres
> terminology (although quickly learning!!!).

A RECORD is a data type that holds field data for one to several
fields, and performs ... in PL/pgSQL functions ... a lot like the
Struct you mention.  However, a RECORD must be keyed off a query, as
follows:

DECLARE
    my_rec RECORD;
BEGIN
SELECT id, type INTO my_rec
FROM table1 WHERE id = $1;
IF my_rec.type = 'press contact' THEN

etc.

See the PL/pgSQL documentation (Under "Procedural Langauges" where
you'll find information on C functions as well) for more information
about this.

-Josh Berkus