[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] SQL question
From:       Bolt Thrower <tyr () winter ! teiresias ! net>
Date:       2002-01-28 20:26:59
[Download RAW message or body]

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 <tyr@teiresias.net>

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html
[prev in list] [next in list] [prev in thread] [next in thread]