with queries

Hullo.

I've been a Postgresql user for many years, so forgive me if I'm doing 
something really stupid.

I cannot get 'with' queries to work at all. The test query that I've 
entered below (as an example) is direct from the section '7.8 WITH 
Queries' of the manual, so I'd expect that to work wouldn't I?

test=# WITH RECURSIVE t(n) AS (VALUES (1) UNION ALL SELECT n+1 FROM t 
WHERE n < 100) SELECT sum(n) FROM t;
ERROR:  syntax error at or near "WITH RECURSIVE"
LINE 1: WITH RECURSIVE t(n) AS (VALUES (1) UNION ALL SELECT n+1 FROM...       ^
test=#

Tried this with 8.4 and 9.0rc1, same result. Any help (even to tell me 
that I'm an idiot!) would be much appreciated. In the meantime my query 
will revert to Plan A, but it would be so much neater using a 'with'.

-- 

Greg Quinn

Australian Phenomics Facility
greg.quinn@anu.edu.au

(02) 61259407