Re: [GENERAL] STABLE marker on functions with single select

2013-09-02 Thread David Johnston
Laszlo Hornyak-3 wrote > hi, > > We have some plpgsql functions that return a setof rows from some tables > by a single query, they are quite simple. Only the application invokes > these functions to query the database, one at a time. e.g. select > getFooById(1) > Do I correctly assume that markin

[GENERAL] STABLE marker on functions with single select

2013-09-02 Thread Laszlo Hornyak
hi, We have some plpgsql functions that return a setof rows from some tables by a single query, they are quite simple. Only the application invokes these functions to query the database, one at a time. e.g. select getFooById(1) Do I correctly assume that marking the functions as STABLE will not