In addition to my previous message: The next query do the same (crashes postmaster and closes all backends). > select day,sum(bto+proxy) as sum1,sum(bfrom) as sum2 > from traf2 > where uzer=320 > and day>='1/08/1999' > and day<'1/09/1999' > group by day > union > select NULL as day,sum(bto+proxy) as sum1,sum(bfrom) as sum2 > from traf2 > where > day>='1/08/1999' > and day<'1/09/1999' > and uzer=320 > group by uzer At the same time all these two selects acts Ok. I checked these queries when answers were empty tuples. In addition, I use Postgres on Linux, kernel 2.2.5. Please, help Pavel Mamin, Network Programmer, SkyNet Co. ISP, Yekaterinburg, Russia ************
