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 <[EMAIL PROTECTED]>:
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/
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
