I have a postgresql problem. Trying to alias a column with the name gps_p,
but the AS isn't having any effect. The contents of the column are a
calculation in a CASE statement. When I get my result set, the column is
called ?column?. See the CASE statement in the query below. Any ideas on why
this isn't working? Using postgresql 9.0.1.
Thanks,
Carlos
create or replace view categories_gps as
select c.id as id,
c.parent_id as parent_id,
c.name as name,
c.menu_p as menu_p,
c.start_date as start_date,
c.end_date as end_date,
c.createdby as createdby,
(select
(case
when sum(l.latcoord) + sum(l.longcoord) is null then false
else true
end) as gps_p
from locations l
where l.id in (select cl.business_id
from category_lookup cl
where cl.category_id = c.id))
from categories c;
_______________________________________________
PLUG mailing list
[email protected]
http://lists.pdxlinux.org/mailman/listinfo/plug
