Gerard,
No this isn't a bug, it's just the way buffering works. You can run a scan loop over the view instead of going through the effort of a COPY TO.
>Eric, I also ran into this problem !!!!
>It seems that a SQL select does NOT work on a modified view BUT a COPY TO
>does.... I would argue that this must be a bug surely.
>
>As a work around, if you COPY TO another file and then do a SQL SELECT from
>the copied file..... with large files there will be a performance consideration