Re: [GENERAL] function in index expression and unnecessary function calls in select

2005-12-04 Thread Martijn van Oosterhout
On Sun, Dec 04, 2005 at 01:00:52PM +0300, Eugene Prokopiev wrote: > Hi, > > I have Linux, PostgreSQL 8.1, Python 2.3 > > test=# select name, f1(value) from t1; > name | f1 > --+ > r1 | 2 > r2 | 3 > (records: 2) > > $ cat /tmp/f1.log > log > log > log > log > log > log > > Wh

[GENERAL] function in index expression and unnecessary function calls in select

2005-12-04 Thread Eugene Prokopiev
Hi, I have Linux, PostgreSQL 8.1, Python 2.3 pgsql code: test=# create table t1(name varchar(10), value integer); CREATE TABLE test=# create or replace function f1(integer) returns integer as $$ test$# file = open('/tmp/f1.log', 'a') test$# file.write('log\n') test$# file.close test$# return ar