Re: ERROR: invalid value "????" for "YYYY"

From: Rowan Collins <rowan(dot)collins(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: invalid value "????" for "YYYY"
Date: 2013-10-10 20:34:28
Message-ID: 52570F54.8060906@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2013-10-10 21:22:02 Re: ERROR: invalid value "????" for "YYYY"
Previous Message David Johnston 2013-10-10 20:31:51 Re: Can a view represent a schedule for all days into the future?