[SQL] Evaluation of if conditions

2006-09-06 Thread Daniel CAUNE
Hi, How does the IF statement evaluate conditions? Does it evaluate conditions following their declaration order from left to right? In case of or-conditions, does the IF statement stop evaluating conditions whenever a first or-condition is true? The following snippet seems to be invalid, which

Re: [SQL] Evaluation of if conditions

2006-09-06 Thread Oisin Glynn
Daniel CAUNE wrote: Hi, How does the IF statement evaluate conditions? Does it evaluate conditions following their declaration order from left to right? In case of or-conditions, does the IF statement stop evaluating conditions whenever a first or-condition is true? The following snippet seem

Re: [SQL] Evaluation of if conditions

2006-09-06 Thread Gregory S. Williamson
Greg Williamson DBA GlobeXplorer LLC -Original Message- From: [EMAIL PROTECTED] on behalf of Daniel CAUNE Sent: Wed 9/6/2006 3:32 PM To: pgsql-sql@postgresql.org Cc: Subject: [SQL] Evaluation of if conditions Hi, How does the IF statement evaluate conditions? Do

Re: [SQL] Evaluation of if conditions

2006-09-06 Thread Joe
Daniel CAUNE wrote: Hi, How does the IF statement evaluate conditions? Does it evaluate conditions following their declaration order from left to right? In case of or-conditions, does the IF statement stop evaluating conditions whenever a first or-condition is true? Please see 4.2.12. Expr

Re: [SQL] Evaluation of if conditions

2006-09-06 Thread Tom Lane
Daniel CAUNE <[EMAIL PROTECTED]> writes: > How does the IF statement evaluate conditions? Does it evaluate conditions > following their declaration order from left to right? In case of > or-conditions, does the IF statement stop evaluating conditions whenever a > first or-condition is true? > Th