Condition in a calculated field

Поиск
Список
Период
Сортировка
От JORGE MALDONADO
Тема Condition in a calculated field
Дата
Msg-id CAAY=A78wDyHXXbZGZtL5TcHwcXzUEkCUgezK22Nj7=nV4Mi_8A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Condition in a calculated field
Список pgsql-novice
Дерево обсуждения
Can I use a calculated field in a WHERE condition of a SELECT statement? I get a "column 'total' does not exist" error when I run the statement below. 'total' is a field generated by a SUM and I want to use it in the WHERE condition.

SELECT 
  facturas.fce_id,
  facturas.fce_numero_factura,
  facturas.fce_fecha,
  compradores.com_nombre,
  facturas.fce_subdivision,
  facturas.fce_valor_comercial,
  SUM(facsub.fce_valor_comercial) AS total
FROM
  trafico.facturas_exportacion facturas
  INNER JOIN trafico.cat_compradores compradores ON (facturas.fce_comprador = compradores.com_clave)
  INNER JOIN trafico.facturas_exportacion facsub ON (facturas.fce_id = facsub.fce_id_factura_original)
WHERE
  facturas.fce_subdivision = true AND facturas.fce_valor_comercial > total
GROUP BY facturas.fce_id,compradores.com_clave

Respectfully,
Jorge Maldonado

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