> On Thu, Dec 23, 2004 at 01:22:42PM -0800, Mike wrote:
>
> > My question is- is there anyway, since a call to sp_host('10.0.0.1')
will
> > always
> > return the same value (the primary key/sequence value from the
ip_addresses
> > table), to cache/index that value somehow, so anytime I ever call th
On Thu, Dec 23, 2004 at 01:22:42PM -0800, Mike wrote:
> My question is- is there anyway, since a call to sp_host('10.0.0.1') will
> always
> return the same value (the primary key/sequence value from the ip_addresses
> table), to cache/index that value somehow, so anytime I ever call that same
> f
Hello,
I've written several functions using the SPI_ interface, some of them are to
simply ease inserting into a few tables-
ie- I wrote a function sp_host('10.0.0.1'); which returns the id of the
given
ip address from a ip_addresses table if it exists, otherwise, it inserts it,
and
returns that
