postgresql query - Mailing list pgsql-general

From Jashaswee
Subject postgresql query
Date
Msg-id 1371639103750-5759846.post@n5.nabble.com
Whole thread Raw
Responses Re: postgresql query  (AI Rumman <rummandba@gmail.com>)
Re: postgresql query  (Victor Yegorov <vyegorov@gmail.com>)
Re: postgresql query  (David Johnston <polobo@yahoo.com>)
List 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.


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pgxs question - linking c-functions to external libraries
Next
From: AI Rumman
Date:
Subject: Re: postgresql query