Re: storing binary data - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: storing binary data
Date
Msg-id ECEHIKNFIMMECLEBJFIGEEFHCCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: storing binary data  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: storing binary data
List pgsql-hackers
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@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Tom Lane
> Sent: Thursday, 25 October 2001 1:00 AM
> To: Joe Conway
> Cc: Jason Orendorff; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] storing binary data
>
>
> Joe Conway <joseph.conway@home.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>



pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: Can't cast bigint to smallint?
Next
From: Tom Lane
Date:
Subject: Re: storing binary data