Re: SQL99 functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SQL99 functions
Дата
Msg-id 8783.962095875@sss.pgh.pa.us
обсуждение исходный текст
Ответ на SQL99 functions  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Список pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> I see mention in SQL99 of function definitions which can have IN, OUT,
> and INOUT arguments. Any thoughts on how this could be supported in
> Postgres?

I noticed that but haven't quite figured out how it's supposed to fit
into the SQL worldview at all.  SurelySELECT foo(x) FROM table
shouldn't silently mutate into an UPDATE depending on how foo() is
declared.  Exactly where is a function with OUT args useful in SQL?
        regards, tom lane


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

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Big 7.1 open items
Следующее
От: Philip Warner
Дата:
Сообщение: Re: Proposal: More flexible backup/restore via pg_dump