On Mon, Aug 08, 2011 at 10:20:18PM -0400, David Johnston wrote: > > > > > 8.X in this context means "8 point something, but I can't recall > > which something". Could be 8.2, 8.3 or 8.4. Thus, in effect, asking > > those replying to restrict themselves to 8 series features, as > > opposed to 9 series features. > > > > There are a lot of features added between 8.0 and 8.4; WITH and > WINDOW being two major ones, that just saying 8 is not helpful. In > the future please take the time to issue a SELECT pg_version() before > asking others to take time to help. It is for your own benefit and > makes it easier for those wanting to help to give useful advice. It'd be great if select pg_version() worked, but PG doesn't recognize the function, when issued from the PG prompt. I had to go all the way back to aptitude to find out it's verson 8.3.1-1 running under Debian unstable. Paul -- Paul M. Foster http://noferblatz.com http://quillandmouse.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general