Re: [HACKERS] Re: [GENERAL] Proposed Changes to PostgreSQL

Hannu Krosing <hannu@tm.ee>

From: Hannu Krosing <hannu@tm.ee>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: chris@bitmead.com, "pgsql-hackers@postgreSQL.org" <pgsql-hackers@postgreSQL.org>, pgsql-sql@postgreSQL.org, pgsql-general@postgreSQL.org
Date: 2000-02-03T10:06:09Z
Lists: pgsql-hackers
Bruce Momjian wrote:
> 
> > Bruce Momjian wrote:
> >
> > > So the field is created on the fly to show what table it came from.
> > > Seems like a good idea, though implementing another usually-invisible
> > > column will be tough.
> >
> > What problems do you forsee?
> 
> Well, it is usually pretty strange to carry around a column that doesn't
> exist through all the code and finally contruct it at the end.  I would
> suspect something in the rewrite system could do that pretty easily,
> though.  That is the direction I would go with that.
> 

Oracle has a ROWNR (IIRC) pseudo-column that is added in th every end of 
query and is a convienient way to put numbers on report rows (among other 
things).

------------
Hannu