Small question.
> This query (with all the defaults made explicit):
>
> SELECT s.company, s.tdate, s.price,
> FIRST_VALUE(s.tdate) OVER w,
> LAST_VALUE(s.tdate) OVER w,
> lowest OVER w
> FROM stock AS s
> WINDOW w AS (
> PARTITION BY s.company
> ORDER BY s.tdate
> ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING
> EXCLUDE NO OTHERS
> MEASURES
> LAST(DOWN) AS lowest
> AFTER MATCH SKIP PAST LAST ROW
> INITIAL PATTERN (START DOWN+ UP+)
> DEFINE
> START AS TRUE,
> UP AS price > PREV(price),
> DOWN AS price < PREV(price)
> );
> LAST(DOWN) AS lowest
should be "LAST(DOWN.price) AS lowest"?
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp