Re: [HACKERS] Aggregates with context - a question - Mailing list pgsql-hackers

From Philip Warner
Subject Re: [HACKERS] Aggregates with context - a question
Date
Msg-id 3.0.5.32.19990610173509.00970100@mail.rhyme.com.au
Whole thread Raw
In response to Re: [HACKERS] Aggregates with context - a question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I have attached the latest attempt at my stats functions. They are defined for int4, float4 and float8, and now use a
'text'type to store context information. This gets rid of the need to pass pointers as int4, but brings me to the next
question:

is it OK to store 'binary' data (possibly containing \0) in a text field, so long as that field is never displayed?

If it is, then I presume text fields are the best approach to preserving context in complex aggregate functions. Is
thisreasonable? 

Any further (polite) suggestions would be welcome.

If all is OK, my final question is: would people be happy to incorporate such code into PG for general use once all
relevanttypes are supported? 




----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: +61-03-5367 7422            |                 _________  \
Fax: +61-03-5367 7430            |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/
Attachment

pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Index corruption under PostgreSQL 6.5beta3
Next
From: "Pedro J. Lobo"
Date:
Subject: Postgres dies in the rules regression test (64-bit problem)