From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Jan Wieck <jwieck(at)debis(dot)com> |
Cc: | chris(dot)bitmead(at)bigfoot(dot)com, pgsql-hackers(at)hub(dot)org |
Subject: | Re: [HACKERS] It would be nice if this could be fixed... |
Date: | 1999-04-26 16:39:44 |
Message-ID: | Pine.BSF.4.05.9904261339070.47191-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 26 Apr 1999, Jan Wieck wrote:
> Marc G. Fournier wrote:
>
> >
> > On Sat, 17 Apr 1999, Chris Bitmead wrote:
> >
> > >
> > > I'm not sure what you're getting at. Yep, you can include the oid field
> > > if you rename it, but it would be nice if you could leave it alone.
> > >
> > > A typical scenario is that you create some table and start using it.
> > > Then you find you need some derived field (like quantity*price AS total)
> > > or something. So you may rename say product table to productold, and
> > > create a product view that is SELECT *, quantity*price AS total from
> > > productold.
> > >
> > > The problem then arises if your code uses oid, because a view can't have
> > > a field called oid. I'm advocating that you be allowed to create views
> > > that have a field called oid to avoid this problem.
> >
> > As D'Arcy did ask...which oid would you want used? The one from table a,
> > or from Table b? They are two distinctly different numbers...the VIEW
> > itself doesn't have an OID assigned to its rows, only the physical tables
> > themselves...
>
> Not exactly, because in his example there is only one table
> used in the view. But I wonder what an OID from a view might
Wait, I thought his SELECT had a 'FROM a,b' clause in it...no? *raised
eyebrow* If not, I misread, apologies...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Taral | 1999-04-26 18:06:37 | Re: CORBA again. (was: light dawns: serious bug in FE/BE protocol handling) |
Previous Message | Clayton Cottingham | 1999-04-26 16:16:24 | [Fwd: 6.5beta] |