Postgres Pro
Downloads
Home   >   mailing lists

SQL question - Mailing list pgsql-admin

From Bolt Thrower
Subject SQL question
Date
Msg-id 3C5205F4.DB54E6C@teiresias.net
Whole thread Raw
Responses Re: SQL question  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: SQL question  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-admin
Tree view 
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: "Eduardo Caillava"
Date:
Subject: Re: postgresql under Windows is slow
Next
From: Andy Ruhl
Date:
Subject: Sample database for testing?