SQL question

From: Bolt Thrower <tyr(at)winter(dot)teiresias(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: SQL question
Date: 2002-01-28 20:26:59
Message-ID: 200201282026.g0SKQxJ07267@winter.teiresias.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)teiresias(dot)net>

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-01-28 20:34:59 Re: performance tuning on inserts
Previous Message Peter T. Brown 2002-01-28 20:22:55 Re: performance tuning on inserts