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: (view raw, whole thread or download thread mbox)
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?

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-2017 The PostgreSQL Global Development Group