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?

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, Pennsylvania 19026