Re: Rewriting select statements

["Phil Cairns" <phil(at)pagaros(dot)com(dot)au>]

Tom Lane wrote:
> "Phil Cairns" <phil(at)pagaros(dot)com(dot)au> writes:
> > I want to have the server do this:
> > If the query has no where clause, use a where clause of "where 1=0".
> 
> > Is this possible?
> 
> It's doubtless *possible*, but if you're asking for it to actually
> happen in any supported version of Postgres, the answer is no way.
> It's directly contrary to the SQL standard.

Yeah. Not asking for a feature to be added, just asking if something already
existed, some sort of rule that could be created that would rewrite the
query.

> > Why would I want to do this? Because a third party library (ArcGIS) has
a
> > "feature" such that when a relation name is registered with it, it does
a
> > "select * from <relation>" and then does nothing with the results.
> 
> Tell the library authors to fix their broken code.  This is blithering
> stupidity in *any* SQL database, not only Postgres.

Tried that, and got no response. I fully agree that it's broken, but my
users just see the delay. I might have to try some sort of proxy
arrangement.

Thanks for your response,
Phil.