Nicolae Mihalache <mache(at)abcpages(dot)com> writes:
> I've created a function timevalue(text) that returns a timestamp as
> result. The function works just fine.
> However, when I do a query like:
> "select * from mytable where time<timevalue('something')" I see that my
> function is evaluated once for each row in mytable.
See the "isCachable" attribute in CREATE FUNCTION.
regards, tom lane