Thread
-
SPI hacking
Terry Mackintosh <terry@terrym.com> — 1998-11-06T19:39:30Z
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!
-
Re: [HACKERS] SPI hacking
Jan Wieck <jwieck@debis.com> — 1998-11-06T20:41:17Z
> > 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) # -
New SPI contrib stuff, was Re: [HACKERS] SPI hacking
Terry Mackintosh <terry@terrym.com> — 1998-11-06T21:27:53Z
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! -
Re: New SPI contrib stuff, was Re: [HACKERS] SPI hacking
Bruce Momjian <maillist@candle.pha.pa.us> — 1998-12-12T20:21:15Z
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