postgresql query

From: Jashaswee <sweet(dot)rinky72(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgresql query
Date: 2013-06-19 10:51:43
Message-ID: 1371639103750-5759846.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have numeric values in a numeric column.the column has two parts.i want to
split in 2 differnet column .
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 can i get this in a select statement ?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-query-tp5759846.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2013-06-19 11:18:54 Re: Migration from DB2 to PostgreSQL-ROLLUP()
Previous Message Albe Laurenz 2013-06-19 09:00:52 Re: Migration from DB2 to PostgreSQL