[GENERAL] help for xml create in postgresql

[Jignesh Ramavat]

i need to create xml by using xml function in postgresql.

i can create following xml by using this query
Query:
SELECT  XMLELEMENT(name chapter,
XMLATTRIBUTES(
'1' AS number,
CURRENT_DATE as current_date),
XMLELEMENT(name document, XMLATTRIBUTES((select typeaccountcode from
typeaccount limit 1) AS doc_name)));

Result:

chapter number=1 current_date=2011-07-11
document doc_name=Billing/
/chapter

*BUT IF i want result in following format then?*

chapter number=1 current_date=2011-07-11
document doc_name=Billing/
document doc_name=EManager/
document doc_name=Immunization/
document doc_name=NueMD/
document doc_name=NueMDSched/
document doc_name=SuperAccount/
document doc_name=UnivScheduler/
/chapter

-- 
Thanks  Regards,
Jignesh Ramavat
Software Engineer
Yosa Technology Solutions Pvt. Ltd
09924407751

[GENERAL] declare variable in postgresql

[Jignesh Ramavat]

Hello,

need help,

Declare @TypeTransactionID As int;

Select @TypeTransactionID=ID from TypeTransaction Where TypeTransactionCode
= 'TxnBackupInc' ;

these is in sqlserver. If i want to do same in postgresql then ???

-- 
Thanks  Regards,
Jignesh Ramavat
Software Engineer