Re: Stored Procedures

Wendy,

> Is it possible to write a stored procedure which takes a struct as a
> parameter? I'd like to be able to pass in some info via a struct &
> return some info via another struct something like this:

What's a "Struct"? It's not a standard SQL term, and I don't recognize
it.

> struct in_struct {
> integer i, j;
> }
>
> struct out_struct {
> integer k;
> char p;
> }

Are you trying for a custom data type, or more of a record? Postgres
supports both.

> create function myfunc(in_struct, out_struct) .....

Postgres does not support output parameters, at present. Functions
have one return value of a defined data type (which may be a custom
data type or a record, if you wish).

-Josh Berkus