Re: Proposal for updatable views

Jaime Casanova <systemguards@gmail.com>

From: "Jaime Casanova" <systemguards@gmail.com>
To: "Bernd Helmle" <mailings@oopsware.de>
Cc: "Neil Conway" <neilc@samurai.com>, pgsql-hackers@postgresql.org
Date: 2006-03-14T05:06:52Z
Lists: pgsql-hackers
On 3/13/06, Bernd Helmle <mailings@oopsware.de> wrote:
>
>
> --On Sonntag, März 12, 2006 23:52:12 -0500 Neil Conway <neilc@samurai.com>
> wrote:
>
> > On Fri, 2006-03-10 at 11:21 +0100, Bernd Helmle wrote:
> >> Please find attached a patch that implements SQL92-compatible updatable
> >> views.
> >
> > I'm currently reviewing this. Comments later...
> >
>
> ok....
>
> >> Please note that the patch isn't complete yet
> >
> > Do you have a list of known TODO items?
> >

There's a problem with CASTed expressions because it thinks (and with
reason) that they are functions expressions (and those are not
allowed) but with CAST you have to be flexible...

i was working on that but at the time i am very busy...

--
regards,
Jaime Casanova

"What they (MySQL) lose in usability, they gain back in benchmarks, and that's
all that matters: getting the wrong answer really fast."
                           Randal L. Schwartz