Re: storing binary data

Quick question - I couldn't find this in the docs:

What exactly is the advantage in using VIEWs? I get the impression that the
SELECT query it is based on is cached (ie. a cached query plan).

But, is this cached between db restarts, between connections, etc. Is it
cached upon the first use of the view for a db instance for a particular
connection, etc?

Chris

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
> Sent: Thursday, 25 October 2001 1:00 AM
> To: Joe Conway
> Cc: Jason Orendorff; pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] storing binary data
>
>
> Joe Conway <joseph(dot)conway(at)home(dot)com> writes:
> > I'll take a shot at improving the documentation for bytea. I'm hoping
> > documentation patches are accepted during beta though ;-)
>
> Of course. The only limitation we place during beta is "no new features
> added". I plan to spend a good deal of time on the docs during beta
> myself.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>