SQL question - Mailing list pgsql-admin

From Bolt Thrower
Subject SQL question
Date
Msg-id 200201282026.g0SKQxJ07267@winter.teiresias.net
Whole thread Raw
List 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@teiresias.net>

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: performance tuning on inserts
Next
From: Bradley Kieser
Date:
Subject: IMporting Oracle DBs to PG