SELECT INTO behavior in SQL functions

Поиск
Список
Период
Сортировка
От Fran Fabrizio
Тема SELECT INTO behavior in SQL functions
Дата
Msg-id 3C87E2EA.4070208@mmrd.com
обсуждение исходный текст
Список pgsql-general
Do PostgreSQL SQL functions have any behavior similar to SQL92 SELECT
INTO so that I can have variables to use later in the function?  This
function deletes one or more rows and updates the rest of the rows in
the table, but the updates require some of the data from the deleted
rows.  I was going to try SELECT foo, bar INTO myfoo, mybar .... until I
noticed in the docs that PostgreSQL overrides this behavior.  Does it
provide any alternates, or do I need to just go ahead and write a
plpgsql function instead?

-Fran


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

Предыдущее
От: teg@redhat.com (Trond Eivind Glomsrød)
Дата:
Сообщение: Re: Installing 7.2 on RedHat 7.1
Следующее
От: Rob Hoopman
Дата:
Сообщение: SERIAL datatype, int or bigint?