Re: [GENERAL] Fetching from psql procedures

2015-11-20 Thread Pavel Stehule
2015-11-20 9:14 GMT+01:00 Marc Mamin : > >> Hi, > >> > >> I'm looking for a way to build large xml documents based on a set of > tables, hence using recursive queries. > >> > >> > >> something like: > >> > >> FOR rec1 IN ... > >> FOR rec2 IN ... > >> > >> RETURN QUERY select '> > >>

Re: [GENERAL] Fetching from psql procedures

2015-11-20 Thread Marc Mamin
>> Hi, >> >> I'm looking for a way to build large xml documents based on a set of tables, >> hence using recursive queries. >> >> >> something like: >> >> FOR rec1 IN ... >> FOR rec2 IN ... >> >> RETURN QUERY select '> >> FOR rec3 IN ... >> >> RETURN QUERY select

Re: [GENERAL] Fetching from psql procedures

2015-11-19 Thread Pavel Stehule
Hi 2015-11-19 14:51 GMT+01:00 Marc Mamin : > Hi, > > I'm looking for a way to build large xml documents based on a set of > tables, hence using recursive queries. > > > something like: > > FOR rec1 IN ... > FOR rec2 IN ... > > RETURN QUERY select ' > FOR rec3 IN ... > >