Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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>

pgsql-admin by date

Next:From: Tom LaneDate: 2002-01-28 20:34:59
Subject: Re: performance tuning on inserts
Previous:From: Peter T. BrownDate: 2002-01-28 20:22:55
Subject: Re: performance tuning on inserts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group