In the query: select field, length(field) from table where length(field) < 10;
How many times is the length() function called for each row? Once or twice? Thanks, -- Steve Chadsey <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html