Hi,

When I run this:

SELECT DISTINCT(EXTRACT(QUARTER FROM o_orderdate)) FROM orders;

I get following error:

Error: syntax error, unexpected IDENT in: "select distinct(extract(quarter"

SQLState: 42000

ErrorCode: 0

Is Quarter not supported or is this a bug? Extract Year, month, day are all working fine.

Environment: RHEL (Amazon Linux), Latest version of MonetDB compiled from source code.

Thanks,

Diethard