Ivan Sergio Borgonovo wrote: > I've a bunch of functions that operates on the basket (a smaller list > of products with their attributes). > > So many functions ends up in repeating over and over a select similar > to: > > select [list of columns] from baskets b > join basket_items bi on b.basket_=bi.basket_id > join items i on i.item_id=bi.item_id > join item_attributes a a.item_id=i.item_id > where b.basket_id=$1 > > It would be nice if I could avoid to execute this query over and over. > I'd have to find a way to pass this data across functions.
You could pass arrays containing the selected rows between functions. Something like: CREATE TYPE basket_row AS(id integer, name text, count integer, ...); CREATE FUNCTION sell (items basket_row[]) RETURNS boolean LANGUAGE plpgsql AS $$........$$; Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
