Postgres Pro
Downloads
Home   >   mailing lists

STABLE marker on functions with single select - Mailing list pgsql-general

From Laszlo Hornyak
Subject STABLE marker on functions with single select
Date
Msg-id 1028130796.8334160.1378134720003.JavaMail.root@redhat.com
Whole thread Raw
Responses Re: STABLE marker on functions with single select  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view 
hi,

We have some plpgsql functions that return a setof rows from some tables by a single query, they are quite simple. Only
theapplication 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 have any effect on the performance in this case?

Thank you,
Laszlo

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: psql --command option ignores --variable's
Next
From: David Johnston
Date:
Subject: Re: STABLE marker on functions with single select