Re: wierd AND condition evaluation for plpgsql

On Tue, 2002-05-28 at 21:52, Peter Eisentraut wrote:
> Louis-David Mitterrand writes:
>
> > Shouldn't plpgsql shortcut AND conditions when a previous one fails, as
> > perl does?
>
> Shouldn't perl evaluate all operands unconditionally, like plpgsql does?
>
> Seriously, if you want to change this you have to complain to the SQL
> standards committee.

Is plpgsl a SQL standards committee standard ?

and is the following non-standard ?

(itest is a 16k row test table with i in 1-16k)

hannu=# create sequence itest_seq;
CREATE
hannu=# select nextval('itest_seq');
nextval
---------
1
(1 row)

hannu=# select count(*) from itest where false and true;
count
-------
0
(1 row)

hannu=# select count(*) from itest where false and i =
nextval('itest_seq');
count
-------
0
(1 row)

hannu=# select nextval('itest_seq');
nextval
---------
2
(1 row)

hannu=# select count(*) from itest where i = nextval('itest_seq');
count
-------
0
(1 row)

hannu=# select nextval('itest_seq');
nextval
---------
16387
(1 row)

---------------------
Hannu