maxvalue in select statement not allowed

Select statement is:
select max("parameter_id") as maxvalue from "APP"."parameter"

McKoi does not allow "maxvalue" in statement.
Following statement is ok:
select max("parameter_id") as _maxvalue from "APP"."parameter"

The documentation says:
=>
7. CREATE SEQUENCE syntax

CREATE SEQUENCE name
  [ INCREMENT increment_value ]
  [ MINVALUE minimum_value ]
  [ MAXVALUE maximum_value ]
  [ START start_value ]
  [ CACHE cache_value ]
  [ CYCLE ]

Creates a new sequence generator that can be used to generate an iterative 
sequence of values. Sequence generators have a number of uses including the 
creation of primary keys for a table. The INCREMENT, MINVALUE, MAXVALUE, 
START, and CACHE values are all optional.
=>

Does this mean that maxvalue is a reserved word ?

-- 
John Zoetebier
Web site: http://www.transparent.co.nz



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]