Mike Mascari wrote:
I have the following view:

create or replace view market.p_areas as
select a.*
from _areas a
where a.area in (
 select b.area
 from _bins b, _inventories i, _offers o, _pricemembers p
 where b.bin = i.bin and
 i.inventory = o.inventory and
 o.pricegroup = p.pricegroup and
 p.buyer in (
  select s.store
  from _stores s, _webusers w
  where w.webuser = getWebuser() and
  w.company = s.company
  select s.store
  from _stores s, _companies c
  where s.company = c.company and
  c.companyid = 'DEFAULT'


I failed to report the version:

select version();

PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.4.0 20040204 (prerelease)


Mike Mascari

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to