SQL question

From: Bolt Thrower <tyr(at)teiresias(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: SQL question
Date: 2002-01-26 01:27:16
Message-ID: 3C5205F4.DB54E6C@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>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joel Mc Graw 2002-01-26 03:15:48 pg_dumpall won't work?
Previous Message Tom Lane 2002-01-25 19:50:24 Re: Maximum Performance Follow-up Question