Re: ERROR: invalid value "????" for "YYYY" - Mailing list pgsql-general

From Rowan Collins
Subject Re: ERROR: invalid value "????" for "YYYY"
Date
Msg-id 52570F54.8060906@gmail.com
Whole thread Raw
In response to Re: ERROR: invalid value "????" for "YYYY"  (Brian Wong <bwong@imageworks.com>)
List pgsql-general
On 10/10/2013 01:57, Brian Wong wrote:
> And the extra data that's showing up is being added to the resultset
> cuz without the additional where clause, the result set did not
> contain any of those rows like pg_statistics/etc.

To add to what Brain said on this already, the key thing is that
Postgres doesn't know (or care) which where clause is "additional". The
only "original" result set is the one with no where clause at all, which
contains rows for 'pg_statistics' etc.

--
Rowan Collins
[IMSoP]



pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Can a view represent a schedule for all days into the future?
Next
From: Adam Mackler
Date:
Subject: A view representing a schedule for all days into the future