How to writ function in postgres?

annielucinda

Plz can any one help me to write function in postgres

i have a table with two columns
for example student class and student name

the table Data is like this
STU_class Name
1 Ann
2 JAck
3 Dickson
1 Donald

but the report i need is in the following format

Class Name
1 Ann,Donald
2 JacK
3 Dickson

can anyone help me to generate this report

Thanks in advance

rski

Quote:

Originally Posted by annielucinda

Plz can any one help me to write function in postgres

i have a table with two columns
for example student class and student name

the table Data is like this
STU_class Name
1 Ann
2 JAck
3 Dickson
1 Donald

but the report i need is in the following format

Class Name
1 Ann,Donald
2 JacK
3 Dickson

can anyone help me to generate this report

Thanks in advance

Suppose table name is test, i think it is the solution

Expand|Select|Wrap|Line Numbers

 
select distinct  i as class, array_to_string((array(select j from test where i=k.i)),',') as name from test k;

How to writ function in postgres?

re: How to writ function in postgres?

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about