Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql query - Mailing list pgsql-general

From Victor Yegorov
Subject Re: postgresql query
Date
Msg-id CAGnEboi-pB+hQM8MYNS0u+HVFgCeL7JnaWRfz=GeZuRPVVETOQ@mail.gmail.com
Whole thread Raw
In response to postgresql query  (Jashaswee <sweet.rinky72@gmail.com>)
List pgsql-general
Tree view
2013/6/19 Jashaswee <sweet.rinky72@gmail.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

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Re: postgresql query
Next
From: Merlin Moncure
Date:
Subject: Re: Migration from DB2 to PostgreSQL-ROLLUP()