Re: Firebird and PostgreSQL at the DB Corral. - Mailing list pgsql-general

From Doug McNaught
Subject Re: Firebird and PostgreSQL at the DB Corral.
Date
Msg-id 87wu8wjvu8.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Firebird and PostgreSQL at the DB Corral.  (Paul Ganainm <paulsnewsgroups@hotmail.com>)
Responses Re: Firebird and PostgreSQL at the DB Corral.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Paul Ganainm <paulsnewsgroups@hotmail.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

pgsql-general by date:

Previous
From: Richard Welty
Date:
Subject: Re: Firebird and PostgreSQL at the DB Corral.
Next
From: "John Sidney-Woollett"
Date:
Subject: Replication Options