> -----Original Message----- > From: Viktor Rosenfeld [mailto:rosenfel@xxxxxxxxxxxxxxxxxxxxxxx] > Sent: Monday, April 28, 2008 4:52 PM > To: Roberts, Jon > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] passing a temporary table with more than one column > to a stored procedure > > Hi Jon, > > Am 28.04.2008 um 19:23 schrieb Roberts, Jon: > >> What does the signature of graphovertokens look like? Three > >> parmaters > > and it doesn't return a setof? > > This is my problem. The return type is setof something (doesn't > really matter), but I don't know what to put into the argument list. > > Any ideas? > You could pass in arrays to the function. A less efficient way would be to create a temp table, loop through the main result set and call your function one record at a time. Take the results from each execution of the function and insert that into the temp table. Then return the values from the temp table. Jon
