Hello This patch contains info about EXECUTE .. INTO statement.
Regards Pavel Stehule
*** pgsql.old/doc/src/sgml/func.sgml 2005-05-23 03:50:01.000000000 +0200 --- pgsql.new/doc/src/sgml/func.sgml 2005-06-01 19:17:08.000000000 +0200 *************** *** 279,284 **** --- 279,300 ---- <synopsis> <replaceable>a</replaceable> < <replaceable>x</replaceable> OR <replaceable>a</replaceable> > <replaceable>y</replaceable> </synopsis> + There is special variant of this operator <indexterm><primary>BETWEEN SYMMETRIC</primary></indexterm>. + In this case isn't important <replaceable>x</replaceable> <= <replaceable>y</replaceable> and + <replaceable>a</replaceable> BETWEEN SYMMETRIC <replaceable>x</replaceable> AND <replaceable>y</replaceable> + is equivalent to + <synopsis> + (<replaceable>a</replaceable> >= <replaceable>x</replaceable> AND <replaceable>a</replaceable> <= <replaceable>y</replaceable>) OR (<replaceable>a</replaceable> >= <replaceable>y</replaceable> AND <replaceable>a</replaceable> <= <replaceable>x</replaceable>) + </synopsis> + Similarly, + <synopsis> + <replaceable>a</replaceable> NOT BETWEEN SYMMETRIC <replaceable>x</replaceable> AND <replaceable>y</replaceable> + </synopsis> + is equivalent to + <synopsis> + (<replaceable>a</replaceable> < <replaceable>x</replaceable> OR <replaceable>a</replaceable> > <replaceable>y</replaceable>) OR (<replaceable>a</replaceable> < <replaceable>y</replaceable> OR <replaceable>a</replaceable> > <replaceable>x</replaceable>) + </synopsis> + There is no difference between the two respective forms apart from the <acronym>CPU</acronym> cycles required to rewrite the first one into the second one internally.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend