Anonymous code blocks

Поиск
Список
Период
Сортировка
От Mike Ellsworth
Тема Anonymous code blocks
Дата
Msg-id 219951fd0911230701s708c799bo1c05172ae96520a6@mail.gmail.com
обсуждение исходный текст
Ответы Re: Anonymous code blocks  (Joshua Tolley <eggyknap@gmail.com>)
Список pgsql-novice
Reading through 'Anonymous Code Blocks' and DO statement to be in 8.5
& it isn't clear to me if user expressions could take advantage of it
- or not.

If I wanted to use this new feature in user expressions so that:

DO.this= round("ben_stmt"."base_pay") +
round("ben_stmt"."incent_comp") + round("ben_stmt"."advance_ben_dol")
+ round("ben_stmt"."er_cont_other")
DO.that = round(DO.this/12)
DO.yada = if(DO.that < 1000, 'consider a vegetable garden.','')

would it be possible - or is that off into lambda calculus discussion
that seems to be an associated thread?

No apologies for the question.  After all, it is Novice. :-)
--
Mike Ellsworth

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

Предыдущее
От: "Jean-Yves F. Barbier"
Дата:
Сообщение: Re: Postgres blob question - insert from basic.
Следующее
От: richard terry
Дата:
Сообщение: Re: Postgres blob question - insert from basic.