[GENERAL] help for xml create in postgresql

nt limit 1) AS doc_name))); Result: *BUT IF i want result in following format then?* -- Thanks & Regards, Jignesh Ramavat Software Engineer Yosa Technology Solutions Pvt. Ltd 09924407751

[GENERAL] declare variable in postgresql

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