| From: | Victor Yegorov <vyegorov(at)gmail(dot)com> |
|---|---|
| To: | Jashaswee <sweet(dot)rinky72(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postgresql query |
| Date: | 2013-06-19 18:56:32 |
| Message-ID: | CAGnEboi-pB+hQM8MYNS0u+HVFgCeL7JnaWRfz=GeZuRPVVETOQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2013/6/19 Jashaswee <sweet(dot)rinky72(at)gmail(dot)com>
> The column value looks like this:
>
> Quantity
> 2000
> -1000
>
> both the quantity values are of a same product.but i want these in a
> single
> line.
> so what i want is a result set that looks like:
> In quantity Out quantity
> ----------- ------------
> 2000 -1000
>
How do we decide wether 2000 or -1000 refers to the “In quantity”?
Can you show a complete table's structure, please?
--
Victor Y. Yegorov
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2013-06-19 18:59:11 | Re: Migration from DB2 to PostgreSQL-ROLLUP() |
| Previous Message | AI Rumman | 2013-06-19 18:43:54 | Re: postgresql query |