Re: [GENERAL] user defined function

2006-01-24 Thread Yl Zhou
Can anyone tell me whether 7.3 supports unspecified record types or not? On 1/24/06, Tom Lane <[EMAIL PROTECTED]> wrote: Yl Zhou <[EMAIL PROTECTED]> writes:> Do you mean this function? Seems I cannot get much information from it...That would appear to be Postgres 7.3 :-( You need

Re: [GENERAL] user defined function

2006-01-24 Thread Yl Zhou
But I have to use 7.3 due to some limitations. Can I do it in 7.3? On 1/24/06, Tom Lane <[EMAIL PROTECTED]> wrote: Yl Zhou <[EMAIL PROTECTED]> writes: > Do you mean this function? Seems I cannot get much information from it...That would appear to be Postgres 7.3 :-(You need a con

Re: [GENERAL] user defined function

2006-01-24 Thread Yl Zhou
Do you mean this function? Seems I cannot get much information from it.../* * record_out        - output routine for pseudo-type RECORD. */Datumrecord_out(PG_FUNCTION_ARGS){    elog(ERROR, "Cannot display a value of type %s", "RECORD");     PG_RETURN_VOID();            /* keep compiler quiet */}On

[GENERAL] user defined function

2006-01-24 Thread Yl Zhou
I want to implement a UDF that can accept a parameter which is a tuple of any table, and returns the number of NULL attributes in this tuple. Different tables may have different schemas. How can I implement this function?  Thanks. andrew