Statistical aggregates

Started by Nonameover 25 years ago8 messages
#1Noname
JanWieck@t-online.de

Hi,

while moving my development environment onto my notebook I
found a little module that needed to go into contrib. It
provides aggregates for variance and standard deviation for
float8. Can be found now under contrib/statmath.

While doing so I noticed that at least the fti Makefile has a
bug. The MODULE_PATH in the .sql.in is replaced with .sql at
the end instead of .so as it should be. Might have to do with
the contrib cleanup done lately.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

#2Karel Zak
zakkr@zf.jcu.cz
In reply to: Noname (#1)
Re: Statistical aggregates

On Tue, 4 Jul 2000, Jan Wieck wrote:

Hi,

while moving my development environment onto my notebook I
found a little module that needed to go into contrib. It
provides aggregates for variance and standard deviation for
float8. Can be found now under contrib/statmath.

While doing so I noticed that at least the fti Makefile has a
bug. The MODULE_PATH in the .sql.in is replaced with .sql at
the end instead of .so as it should be. Might have to do with
the contrib cleanup done lately.

Sorry, my faul. I fog '$@' instead '$<'. Nice on this bug is that
I copy this to more contrib Makefiles..... grrrr :-((

Well, I directly now correct it. The patch will after one hour...

Karel

#3Karel Zak
zakkr@zf.jcu.cz
In reply to: Karel Zak (#2)
Re: Statistical aggregates

On Tue, 4 Jul 2000, Karel Zak wrote:

On Tue, 4 Jul 2000, Jan Wieck wrote:

Hi,

while moving my development environment onto my notebook I
found a little module that needed to go into contrib. It
provides aggregates for variance and standard deviation for
float8. Can be found now under contrib/statmath.

While doing so I noticed that at least the fti Makefile has a
bug. The MODULE_PATH in the .sql.in is replaced with .sql at
the end instead of .so as it should be. Might have to do with
the contrib cleanup done lately.

Sorry, my faul. I fog '$@' instead '$<'. Nice on this bug is that

^^^^^^
idiotism - it must be directly .so

Show quoted text

I copy this to more contrib Makefiles..... grrrr :-((

Well, I directly now correct it. The patch will after one hour...

#4Karel Zak
zakkr@zf.jcu.cz
In reply to: Noname (#1)
1 attachment(s)
Re: [HACKERS] Statistical aggregates

On Tue, 4 Jul 2000, Jan Wieck wrote:

Hi,

while moving my development environment onto my notebook I
found a little module that needed to go into contrib. It
provides aggregates for variance and standard deviation for
float8. Can be found now under contrib/statmath.

While doing so I noticed that at least the fti Makefile has a
bug. The MODULE_PATH in the .sql.in is replaced with .sql at
the end instead of .so as it should be. Might have to do with
the contrib cleanup done lately.

Already fixed in the attache. Can anyone apply it to CVS?

Karel

Attachments:

cotrib-07042000.patch.gzapplication/x-gzip; name=cotrib-07042000.patch.gzDownload
#5Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Karel Zak (#4)
Re: [PATCHES] Re: Statistical aggregates

Applied.

On Tue, 4 Jul 2000, Jan Wieck wrote:

Hi,

while moving my development environment onto my notebook I
found a little module that needed to go into contrib. It
provides aggregates for variance and standard deviation for
float8. Can be found now under contrib/statmath.

While doing so I noticed that at least the fti Makefile has a
bug. The MODULE_PATH in the .sql.in is replaced with .sql at
the end instead of .so as it should be. Might have to do with
the contrib cleanup done lately.

Already fixed in the attache. Can anyone apply it to CVS?

Karel

Content-Description:

[ application/x-gzip is not supported, skipping... ]

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@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
#6Noname
JanWieck@t-online.de
In reply to: Karel Zak (#3)
Re: Statistical aggregates

Karel Zak wrote:

On Tue, 4 Jul 2000, Karel Zak wrote:

On Tue, 4 Jul 2000, Jan Wieck wrote:

Hi,

while moving my development environment onto my notebook I
found a little module that needed to go into contrib. It
provides aggregates for variance and standard deviation for
float8. Can be found now under contrib/statmath.

While doing so I noticed that at least the fti Makefile has a
bug. The MODULE_PATH in the .sql.in is replaced with .sql at
the end instead of .so as it should be. Might have to do with
the contrib cleanup done lately.

Sorry, my faul. I fog '$@' instead '$<'. Nice on this bug is that

^^^^^^
idiotism - it must be directly .so

I used $(NAME)$(DLSUFFIX) in my Makefile. Not all platforms
use .so for dynamic loadable objects.

I copy this to more contrib Makefiles..... grrrr :-((

Well, I directly now correct it. The patch will after one hour...

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

#7Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Noname (#6)
Re: Statistical aggregates

Shouldn't the new statistics routines go into the main tree?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@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
#8Karel Zak
zakkr@zf.jcu.cz
In reply to: Noname (#6)
Re: Statistical aggregates

On Tue, 4 Jul 2000, Jan Wieck wrote:

Sorry, my faul. I fog '$@' instead '$<'. Nice on this bug is that

^^^^^^
idiotism - it must be directly .so

I used $(NAME)$(DLSUFFIX) in my Makefile. Not all platforms
use .so for dynamic loadable objects.

Yes. In the contrib it is already fixed. I used:

$(SED) "s|MODULE_PATHNAME|$(CONTRIB_MODDIR)/$(@:.sql=$(DLSUFFIX))|" < $< >$@

I hope that it will right.

Karel