... a prepared version that is local to the backend that invokes the function, yes (i.e. it will be planned once per backend). So ISTM this is equivalent functionality to what you can get using PREPARE or the extended query protocol.

Are you sure it's only per-backend? I thought I tested it and it seemed to prepare it everywhere... oh well.


Either way, it avoids the problem with prepared queries in that you cannot know in advance if your query has already been prepared or not.

Chris

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to