Thread: SPI hacking
Hi all I started with the contrib/spi/*.c stuff and am working toward a function to be used by a trigger to update a datetime field upon doing an UPDATE to a record. It is about ready to test, except one thing :) Is there a function like GetCurrentAbsoluteTime() that will get the current time in a form suitable for inserting into a datetime field? GetCurrentDatetimeTime() maybe??? or a convertion function? Thanks Terry Mackintosh <terry@terrym.com> http://www.terrym.com sysadmin/owner Please! No MIME encoded or HTML mail, unless needed. Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3 ------------------------------------------------------------------- Success Is A Choice ... book by Rick Patino, get it, read it!
>
> Hi all
>
> I started with the contrib/spi/*.c stuff and am working toward a function
> to be used by a trigger to update a datetime field upon doing an UPDATE to
> a record.
>
> It is about ready to test, except one thing :)
>
> Is there a function like GetCurrentAbsoluteTime() that will get the
> current time in a form suitable for inserting into a datetime field?
>
> GetCurrentDatetimeTime() maybe???
> or a convertion function?
What about datetime_in("now") ?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck@debis.com (Jan Wieck) #
On Fri, 6 Nov 1998, Jan Wieck wrote:
> >
> > Hi all
> >
> > I started with the contrib/spi/*.c stuff and am working toward a function
> > to be used by a trigger to update a datetime field upon doing an UPDATE to
> > a record.
...
> What about datetime_in("now") ?
> Jan
Yes, that's it!
(Where is this documented at?)
Well, here it is, seems to work.
The attached file is intended to be uppacked in
/usr/src/pgsql/contrib/spi/ (on my box any way)
and has a diff file for Makefile and the rest are new files.
I'm in a hurry, got to go, so have not tested it but a little bit.
Hope it is usefull.
Terry Mackintosh <terry@terrym.com> http://www.terrym.com
sysadmin/owner Please! No MIME encoded or HTML mail, unless needed.
Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!
Patch applied to developers tree.
> On Fri, 6 Nov 1998, Jan Wieck wrote:
>
> > >
> > > Hi all
> > >
> > > I started with the contrib/spi/*.c stuff and am working toward a function
> > > to be used by a trigger to update a datetime field upon doing an UPDATE to
> > > a record.
> ...
> > What about datetime_in("now") ?
> > Jan
>
> Yes, that's it!
> (Where is this documented at?)
>
> Well, here it is, seems to work.
> The attached file is intended to be uppacked in
> /usr/src/pgsql/contrib/spi/ (on my box any way)
> and has a diff file for Makefile and the rest are new files.
>
> I'm in a hurry, got to go, so have not tested it but a little bit.
>
> Hope it is usefull.
> Terry Mackintosh <terry@terrym.com> http://www.terrym.com
> sysadmin/owner Please! No MIME encoded or HTML mail, unless needed.
>
> Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
> -------------------------------------------------------------------
> Success Is A Choice ... book by Rick Patino, get it, read it!
Content-Description:
[application/octet-stream is not supported, skipping...]
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026