Function Question

From: Moore <rlmoore_at_purdue.edu>
Date: Mon, 13 Mar 2000 12:30:25 -0500
Message-ID: <Pine.SOL.4.10.10003131226280.23835-100000@herald.cc.purdue.edu>

Greetings!

In the following will function foo be called twice per tupple?

Select Distinct ID_Field, Date_Field, FOO(ID_Field, Date_Field) From Table
Where Date_Field > To_Date('01-JAN-99', 'DD-MON-YY') AND FOO(ID_Field, Date_Field) > 0;

By the way I already attempted:

Select Distinct ID_Field, Date_Field, FOO(ID_Field, Date_Field) Foo_Field From Table
Where Date_Field > To_Date('01-JAN-99', 'DD-MON-YY') AND Foo_Field > 0;

Also attempted AS Foo_Field and "Foo Field".

TIA Received on Mon Mar 13 2000 - 11:30:25 CST