Re: leaky views, yet again - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: leaky views, yet again
Date
Msg-id 4CADC853.6030805@enterprisedb.com
Whole thread Raw
In response to Re: leaky views, yet again  (Stephen Frost <sfrost@snowman.net>)
Responses Re: leaky views, yet again  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
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

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Git cvsserver serious issue
Next
From: Robert Haas
Date:
Subject: Re: leaky views, yet again