Re: [GENERAL] Indexing null dates

2004-04-16 Thread John Sidney-Woollett
Tom Lane said: > "John Sidney-Woollett" <[EMAIL PROTECTED]> writes: >> [ needs to make this fast: ] >> -- locate the next order >> select WCCustOrderID into vCustOrderID >> from CUSTOMER.WCCustOrderStatusLog >> where WCOrderStatusID = pStatusID >> and Acknowledged is null >> and Process

Re: [GENERAL] Indexing null dates

2004-04-16 Thread Tom Lane
"John Sidney-Woollett" <[EMAIL PROTECTED]> writes: > [ needs to make this fast: ] > -- locate the next order > select WCCustOrderID into vCustOrderID > from CUSTOMER.WCCustOrderStatusLog > where WCOrderStatusID = pStatusID > and Acknowledged is null > and Processing is null > for upda