Dnia 2003-12-02 05:51, Użytkownik Kumar napisał:
Thanks for your reply.
But how to use this comma_aggregate( ) function to concatenate the fetched
columns values from a select statement. In my example my select stmt fetches
the following 3 rows. How can I use this function to concatenate them.
Sel
t;[EMAIL PROTECTED]>
Cc: "psql" <[EMAIL PROTECTED]>
Sent: Tuesday, December 02, 2003 1:31 AM
Subject: Re: [SQL] Concatenating multiple fetches into a single string
> Dnia 2003-12-01 13:01, Użytkownik Kumar napisał:
> > Dear Friends,
> >
> > I am doing a m
Dnia 2003-12-01 13:01, Użytkownik Kumar napisał:
Dear Friends,
I am doing a migration from SQL server to Postgres SQL. A simple select
fetches the following names.
select full_name FROM project_members where
project_members.project_role_id in (' + @p_res_ids + ') ;
Let us say if the results
Dear Friends,
I am doing a migration from SQL server to Postgres SQL. A
simple select fetches the following names.
select full_name FROM project_members where
project_members.project_role_id in (' + @p_res_ids + ') ;
Let us say if the results are
full_name
---
David
Postg
