Re: function side effects - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: function side effects
Date
Msg-id 1267525706.20952.7.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: function side effects  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On mån, 2010-03-01 at 16:29 -0500, Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > SQL standard:
> 
> > <SQL-data access indication> ::=
> > NO SQL
> > | CONTAINS SQL
> > | READS SQL DATA
> > | MODIFIES SQL DATA
> 
> Huh.  I understand three of those, but what is the use of CONTAINS SQL?

My reading is that CONTAINS SQL allows/indicates the use of non-data
statements such as CREATE or ALTER, whereas READS SQL DATA and MODIFIES
SQL DATA specifically refer to reading or writing table data.



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: function side effects
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: dedebugging and a functions that just don't work on debian flavour