Re: [SQL] Result set granularity..

2003-10-03 Thread Rasmus Aveskogh
gt; 77455960 > 77474124 > 77480067 > 77501568 > 77503239 > 77507326 > (10 rows) > > the oid is 32 unsigned int that is incremented for each object in the > database. it is the postgres version of Oracle's rownum. > > search the docs for more info. > > >

[SQL] Result set granularity..

2003-09-29 Thread Rasmus Aveskogh
Hi, Since I went from Oracle to PostgreSQL I've been missing the "invisable" column 'rownum'. I often used it to lower the granularity of my data. For example, say I have a large table containing some sort of statistical data and want to plot a graph using it. If the graph is 600 pixels wide I mi