Re: [SQL] Result set granularity..

2003-10-03 Thread Rasmus Aveskogh
) 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. On Sat, 27 Sep 2003, Rasmus Aveskogh wrote: Since I went from Oracle to PostgreSQL I've been missing the invisable column 'rownum'. I

[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