Re: short ciruit logic of plpgsql in 8.2

hello,

it depends on SQL. plpgsql hasn't own arithmetic unit. You can test it simply:



postgres=# create or replace function a() returns bool as $$ begin
raise notice 'a'; return true; end$$ language plpgsql;
CREATE FUNCTION
postgres=# create or replace function b() returns bool as $$ begin
raise notice 'a'; return true; end$$ language plpgsql;
CREATE FUNCTION
postgres=# select a() or b();
NOTICE:  a
 ?column?
----------
 t
(1 row)

result: statements are short circuited.

2007/5/17, Richard Broersma Jr <rabroersma@yahoo.com>:
> Does anyone know if logic operations in plpgsql are short circuited in 8.2?
>
> Regards,
> Richard Broersma Jr.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org/
>