On Thu, Aug 20, 2009 at 2:43 PM, Jasen Betts<jasen@xxxxxxxxxx> wrote: > On 2009-08-19, Stephen Cook <sclists@xxxxxxxxx> wrote: > >> Let's say I have a function that needs to collect some data from various >> tables and process and sort them to be returned to the user. > > plpgsql functions don't play well with temp tables IME. > there are work-arounds and they are ugly. if you caus use a different > language it could work. it does on 8.3, prior versions have known flow. It makes a lot of sense to use TT if you pass a lot of data back and forth. It makes sense to open transaction, stick data into temp table, and pass that around. Or even, in some cases, for duration of connection - instead of storing data in client app. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
