| From: | Camaleon <tarsis(dot)lima(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | what's wrong in this procedure? |
| Date: | 2011-02-25 17:46:57 |
| Message-ID: | 080608d1-b5ea-4b40-8042-f21867f97cc8@glegroupsg2000goo.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
This error is returned Erro de SQL:
ERROR: column "Aguardando Pagto" does not exist at character 352 >>>
create or replace function get_historico() RETURNS SETOF twiste.type_cur__historico AS '
SELECT o.data_fim, sum(t.num_itens * t.valor) AS total, count(t.*) AS transacoes
FROM ofertas o
JOIN transacao t ON o.ofertas_id = t.ofertas_id
JOIN municipio m ON o.municipio_id = m.municipio_id
WHERE o.data_fim <= now() AND t.status IN("Aguardando Pagto", "Em análise", "Aprovado", "Completo")
GROUP BY o.data_fim;
'
language 'sql';
>> the column is t.status and not "Aguardando Pagto";
>> what's wrong ? thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2011-02-25 18:33:57 | Re: what's wrong in this procedure? |
| Previous Message | Isaac Dover | 2011-02-24 22:51:56 | Re: Compare two Data bases Structure |