Glen Eustace <geustace@godzone.net.nz> writes:
> The view is defined to be;
> CREATE VIEW domain_registry AS
> SELECT *
> FROM domain_registry_history
> WHERE tstamp > 'now';
Offhand I'd expect the 'now' to be reduced to a timestamp constant
at the time the view is created.
Perhaps you were expecting something like
CREATE VIEW domain_registry AS
SELECT *
FROM domain_registry_history
WHERE tstamp > now();
although personally I'd not feel very comfortable with the idea of a
view whose contents change over time even when you weren't actually
doing anything to the database. Maybe you should rethink this idea
altogether...
regards, tom lane