case statement as inline function?
От | Mike Nolan |
---|---|
Тема | case statement as inline function? |
Дата | |
Msg-id | 200403241633.i2OGXeLa032518@gw.tssi.com обсуждение исходный текст |
Ответы |
Re: case statement as inline function?
Re: case statement as inline function? |
Список | pgsql-general |
Periodically I need to write a complex case statement that I'd like to be able to refer to in more than one place in a SQL command without having to make sure that each copy of the case statement remains the same as the query (to produce a mailing) is tailored. Is there any way to treat it like an inline function so that I could write something like the following (highly simplified): select case when A=1 then 1 when B=1 then 2 else null end as mailtype, memname from master where mailtype is not null; I could do it as a user function, though that would be less convenient during the specification phase, which may happen every few days. However, the columns referred to in the case statement can change too. Is there a way to pass the entire set of columns in a table to a function? -- Mike Nolan
В списке pgsql-general по дате отправления: