Stored Procedures - Mailing list pgsql-novice

From Wendy Powley
Subject Stored Procedures
Date
Msg-id 3CD6CDE6.6000909@cs.queensu.ca
Whole thread Raw
Responses Re: Stored Procedures
List pgsql-novice
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:

struct in_struct {
   integer i, j;
}

struct out_struct {
   integer k;
    char p;
}

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

Any comments?  From what I've read today, it doesn't look like I can do
this!

I'd appreciate any help.

Wendy (wendy@cs.queensu.ca)



pgsql-novice by date:

Previous
From: Richard A Lough
Date:
Subject: Re: Date Formatting
Next
From: "Michael Barber"
Date:
Subject: Cascaded updates / deletes don't work on inherited tables