| From: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Problem in getting Output |
| Date: | 2010-09-01 10:13:21 |
| Message-ID: | 4C7E2741.8090609@orkash.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dear all,
First of all Sorry If i break any rule while posting this problem.
I have a table named *naxalite_entity1(source_id integer,obj_type_id
integer,obj_text character varying).
*It has the following form of data
45454545 1 Adarsh
45454545 1 Rahul
45454545 1 Yahoo
45454545 3 College
45454545 3 Organization
45454545 9 attracts
45454545 9 dissatisfied
and so on and think U guessed the form of data . It has 11000 rows with
sourc_id repeating with 1,3,9 . Now I want
to display the obj_text in column form for respective source_ids
accordind obj_type_id
as
source_id person event organization
e.g
45454545 Adarsh attracts Yahoo.
and when there is no value for person or event there is Null enetered.
Thanks in Advance
*
*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Newman | 2010-09-01 10:20:30 | Running Total with a Set Maximum |
| Previous Message | Rob Gansevles | 2010-09-01 08:05:19 | Configure default for sorting of null-values? |