Tom Lane wrote: > "Phil Cairns" <phil@xxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
