'stuff' and 'for xml path('')' from SQL Server in Postgresql

I’m migrating some SQL Server 2008R2 queries to Postgresql 9.0 and I have some trouble with it.
Here’s the SQL Server query:

stuff((select ', '+p.[NAME] as 'data()' 
where p.OID = aop.PROVIDER for xml path('')),1,1,'')) as pNAMES

Reading SQL Server documentation I understand that this creates a comma separated list. I think that I can change stuff function to overlay function in Postresql’. Am I correct?

  • PHP MS SQL Unix Driver - Microsoft or FreeTDS
  • How Serializable works with insert in SQL Server 2005
  • .NET API for SQL Server Service Broker
  • Change SQL Server stored procedure in C#
  • What is the mechanism for Transaction Rollback in sql server?
  • SQL Select Return Default Value If Null
  • The second problem comes with SQL Server’s for xml path with (”) as a parameter. It returns the values assigned to an attribute called pNAMES instead of create row elements. Is that correct?

    Does Postgresql Query_to_xml() function with attribute tableforest = 'true' do the same?

    Thank you.

  • Why does my DB project's .dbmdl file change even when I make no changes to the project?
  • SQL Table design assitance
  • SQL Statement With 'Totals' as Final Column
  • Should Conversation Handles be the Same at Each End of a Service Broker?
  • How to easily edit SQL XML column in SQL Management Studio
  • SQL Server Regular expressions in T-SQL
  • One Solution collect form web for “'stuff' and 'for xml path('')' from SQL Server in Postgresql”

    You can use string_agg instead.

    SQL Fiddle

    PostgreSQL 9.1.6 Schema Setup:

    create table T
      Name varchar(10)
    insert into T values('Kalle');
    insert into T values('Pelle');
    insert into T values('Urban');

    Query 1:

    select string_agg(Name, ',') as Names
    from T


    |             NAMES |
    | Kalle,Pelle,Urban |
    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.