Stored Procedures

From: Wendy Powley <wendy(at)cs(dot)queensu(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Stored Procedures
Date: 2002-05-06 18:39:34
Message-ID: 3CD6CDE6.6000909@cs.queensu.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cs(dot)queensu(dot)ca)

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew McMillan 2002-05-06 19:59:21 Re: search and replace possible on SQL?
Previous Message Michael Barber 2002-05-06 18:14:14 Cascaded updates / deletes don't work on inherited tables