Build an statement
От | Alexander Burbello |
---|---|
Тема | Build an statement |
Дата | |
Msg-id | 452BDA4B.5030706@yahoo.com.br обсуждение исходный текст |
Список | pgsql-admin |
Hi people, I am begginer on Postgres, and I would like to build a report this way: 1 - Central 101 - Base Rio 1001 - Sing X 1002 - Sing Y 1003 - Sing Z 102 - Base Sao Paulo 1004 - Sing A 1004 - Sing A 1004 - Sing A In my table, I have the following data: coo_cod_cooperative coo_cooperative_up coo_type coo_name ---------------------- --------------------------- ----------- -------------------- 1001 100 3 Singular X 1002 100 3 Singular Y 1003 100 3 Singular Z 100 1 2 Base Sao Paulo 101 1 2 Base Rio de Janeiro 1004 101 3 Singular A 1005 101 3 Singular B 1006 101 3 Singular C 1 (null) 1 Central COO_TYPE means: 1 master; 2 - regional; 3 - offices I would like to do this statement independent the code, based on type. Is it possible to do on Postgres? Thanks in advance. Alexander
В списке pgsql-admin по дате отправления: