From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | "Andrew G(dot) Hammond" <drew(at)xyzzy(dot)dhs(dot)org>, gntrs(at)hotmail(dot)com (Gintas), pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Help with INSERT into 2 tables |
Date: | 2001-11-16 16:47:47 |
Message-ID: | web-507621@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Andrew,
> I'd really like to figure out how to write a function that doesn't
> return
> anything (a "procedure" for all you pedantic CS types). Oh well.
Easy. Try:
CREATE FUNCTION ... RETURNS OPAQUE AS '
All triggers are expected to return Opaque, that is, nothing.
FYI, A "procedure" in SQL92 terms is waht we in Postgres call a
Function, except that Stored Procedures can return one or more result
sets as well/instead of a value.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Earl | 2001-11-16 16:56:03 | Re: INSERT question |
Previous Message | Josh Berkus | 2001-11-16 16:39:36 | Re: Question |