"Phil Cairns" <p...@pagaros.com.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.
> 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.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
