Re: leaky views, yet again

* Heikki Linnakangas (heikki.linnakangas@enterprisedb.com) wrote:
> On 07.10.2010 16:10, Stephen Frost wrote:
>> Also, even if you can't create functions (due to lack of create
>> privileges on any schema), you could use DO clauses now.
>
> There's no way to shoehorn a DO clause into a SELECT, you can't do:
>
> SELECT data FROM view WHERE (DO $$ RAISE NOTICE argument; $$) = 1

Wow, I just kind of assumed you could; I'm not really sure why.  Perhaps
it'll be possible in the future though, so might be something to think
about if/when it happens.  Can't see a way to abuse the view from inside
a DO or in a function in the same way either.
Stephen