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

[Edwin Plauchu]

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

[Edwin Plauchu]

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 for all
>
>
>
>
> --
> Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 
> 10-
> Celebridades-
> Música-
> Esportes
>

Re: [GENERAL] Select data for current week only

[Edwin Plauchu]

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'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 week but I only
>> want
>> to select events happening for the current week(Mon-Sun). So can anyone
>> help
>> me out with this just using sql? I've accomplished it sorta using php but
>> only within the current 7 day range(example Thursday-Thursday) but not by
>> the week.
>>
>> The field I am using for sorting is a Date type with the format -mm-dd
>> hh:mm:ss .
>> --
>> View this message in context:
>> http://www.nabble.com/Select-data-for-current-week-only-tp25177178p25177178.html
>> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>

Re: [GENERAL] Select data for current week only

[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'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 week but I only
> want
> to select events happening for the current week(Mon-Sun). So can anyone
> help
> me out with this just using sql? I've accomplished it sorta using php but
> only within the current 7 day range(example Thursday-Thursday) but not by
> the week.
>
> The field I am using for sorting is a Date type with the format -mm-dd
> hh:mm:ss .
> --
> View this message in context:
> http://www.nabble.com/Select-data-for-current-week-only-tp25177178p25177178.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: [GENERAL] Import data from XML file

[Edwin Plauchu]

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
>  2
>
>
>  Konzerte
>  1
>
>  
>  
>
>  Reggae
>  1
>  45
>
>
>  sonstige
>  5
>  44
>
> 
> 
>
>
> ... and I want a CSV file like this:
>
> main_category_namemain_category_id
> Sonstiges5
> Buehne2
>
> category_namemain_category_id   category_id
> Reggae145
> sonstige544
>
>
> Or is there a way to import directly into tables in a postgres
> database?
>
>
> Your help would be appreciated!
> Regards
> Erwin
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>