Re: Firebird and PostgreSQL at the DB Corral.

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Paul Ganainm <paulsnewsgroups(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Firebird and PostgreSQL at the DB Corral.
Date: 2003-12-16 21:28:47
Message-ID: 87wu8wjvu8.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Paul Ganainm <paulsnewsgroups(at)hotmail(dot)com> writes:

>> Rules
>
> ? I don't understand these - can somebody explain exactly what they are?

Basically like "query macros"--you can use a rule to rewrite part or
all of the user query and feed the result to the query optimizer.
They're how views are implemented, and you can create updateable views
by writing the appriopriate rules. The only reason PG views aren't
updateable by default is (AIUI) a lack of agreement on how they should
work for complex view definitions.

> -------------------
>
> -------------------
>> Views
>
> X (FB's are updateable to boot!)

See above.

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2003-12-16 21:52:18 Replication Options
Previous Message Richard Welty 2003-12-16 21:24:59 Re: Firebird and PostgreSQL at the DB Corral.