different results selecting from base tables or views

From: Matthias Schmitt <freak001(at)mmp(dot)lu>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: different results selecting from base tables or views
Date: 1999-01-19 14:18:57
Message-ID: v04020a01b2ca3fa67abd@[192.168.129.13]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I discovered different results when selecting data from base tables or
their views. The only thing I can image for this strange behaviour is using
the date constant 'today' when creating the view. Does 'today' in a view
use the current day time of the view creation or the time the query is made
?

magic moving pixel s.a. http://www.mmp.lu

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1999-01-19 14:35:58 Re: [HACKERS] different results selecting from base tables or views
Previous Message José Paumard 1999-01-19 14:08:42 Error using home-made functions