[GENERAL] How to generate XML output from a Store Procedure

Hello List I hope all of you are ok I would like to know if exist a manner to obtain a output on xml format from a store procedure It may lead me to improve my current develop practices when I have to send a Xml ouput which I want to transform by XSLT scripts. I'll be waiting for your commments

Re: [GENERAL] details locks

I understood 2009/8/28 paulo matadr > Im work with postgres > my questions is,its possible on postgres: > for example > procpidLocker object_locked user_lockedtypeof lock comand > 1 admin fooadmin2 > exclusive update... > > > thnks

Re: [GENERAL] Select data for current week only

you need to group dates per number week 2009/8/27 Edwin Plauchu > Postgresql has these functions > http://www.postgresql.org/docs/8.1/static/functions-formatting.html for > formatting data time > > > 2009/8/27 BlackMage > > >> Hey all, >> >> I'

Re: [GENERAL] Select data for current week only

Postgresql has these functions http://www.postgresql.org/docs/8.1/static/functions-formatting.html for formatting data time 2009/8/27 BlackMage > > Hey all, > > I've been trying to figure this problem out with just using sql but I'm not > sure how too. I have a table that holds events for each

Re: [GENERAL] Import data from XML file

I think.. you'll need to parse that one... Where do you have your data types to xml document ? 2009/8/26 Erwin Brandstetter > Hi! > > How do you import data from an xml-file? > For instance, if I have a file like this: > > > > > > Sonstiges > 5 > > > Buehne