[GENERAL] Join on virtual table

2004-12-10 Thread Rory Campbell-Lange
Hi. I'd like to return a result set from a plpgsql function constructed out of a 'virtual table' joined to an actual table, and struggling to find a sane approach. I have a table 'recs' with records like this. day | nums --- 2 | 1 5 | 3 2 | 2.5 For a particu

Re: [GENERAL] Join on virtual table

2004-12-11 Thread Joe Conway
Rory Campbell-Lange wrote: Hi. I'd like to return a result set from a plpgsql function constructed out of a 'virtual table' joined to an actual table, and struggling to find a sane approach. I have a table 'recs' with records like this. day | nums --- 2 | 1 5 | 3