Difference in columns

------=_Part_9148_30830788.1210527475753
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi All,

I have a view that generates output similar to this.

select * from foo.view;

       ts          | size
-------------------+-----
 2002-03-16        | 11
 2002-03-17        | 16
 2002-03-18        | 18
 2002-03-19        | 12

I am trying to find the difference between the size column. So the desired
output would be

       ts          | size| Diff
-------------------+-----+------
 2002-03-16        | 11  | 0
 2002-03-17        | 15  | 4
 2002-03-18        | 18  | 3
 2002-03-19        | 12  | -6


I need the first column to be 0, since it will be 11-11. The second colum
is
15-11. The third column is 18-15. The fourth column is 12-18.

Any thoughts about this?

TIA

------=_Part_9148_30830788.1210527475753
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi All,<br><br>I have a view that generates output similar to
this.<br><br>select * from foo.view;<br><br><pre class="PROGRAMLISTING">  
    ts          | size<br>-------------------+-----<br> 2002-03-16        |
11 <br> 2002-03-17        | 16 <br>
 2002-03-18        | 18<br>&nbsp;2002-03-19        | 12 
<br></pre>I am trying to find the difference between the size column. So
the desired output would be<br><br><pre class="PROGRAMLISTING">       ts  
       | size| Diff<br>-------------------+-----+------<br> 2002-03-16     
  | 11  | 0<br>
 2002-03-17        | 15  | 4<br> 2002-03-18        | 18  |
3<br>&nbsp;2002-03-19        | 12  | -6<br></pre>
<br>I need the first column to be 0, since it will be 11-11. The second
colum is 15-11. The third column is 18-15. The fourth column is 12-18.
<br><br>Any thoughts about this?<br><br>TIA<br> 

------=_Part_9148_30830788.1210527475753--