Well, there is a rowid and a rownum in Oracle. I don't remember which, but
one of them is significant to the current recieved result set only.
Hence; you can use it to manipulate and restrict the result set rather
than the data you're recieving from the tables. I.e. rownum 1 will always
be the
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
On Sat, 27 Sep 2003, Rasmus Aveskogh wrote:
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