Re: Help with INSERT into 2 tables

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Help with INSERT into 2 tables
Дата
Msg-id web-507621@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Re: Help with INSERT into 2 tables  ("Andrew G. Hammond" <drew@xyzzy.dhs.org>)
Список 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
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


В списке pgsql-sql по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: between syntax
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: between syntax