Reuse previously calculated column in sql query?

Поиск
Список
Период
Сортировка
От Philippe Lang
Тема Reuse previously calculated column in sql query?
Дата
Msg-id 6C0CF58A187DA5479245E0830AF84F42080442@poweredge.attiksystem.ch
обсуждение исходный текст
Ответы Re: Reuse previously calculated column in sql query?
Список pgsql-sql
Hello,

Is it possible to reuse a previously calculated column in a following
column, like:

SELECT
foo.val1 AS col1,
long_calculation(foo.val1) AS col2,
COL2 * 0.75 AS col3
FROM foo;

instead of writing:

SELECT
foo.val1 AS col1,
long_calculation(foo.val1) AS col2,
long_calculation(foo.val1) * 0.75 AS col3
FROM foo;


Philippe


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: SQL update function faililed in Webmin Interface
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: Reuse previously calculated column in sql query?