Thread: CREATE FUNCTION

Hello:

I found that when I use CREATE FUNCTION in postgresql, the maximum number of
arguments is 16 only. How I config so that the CREATE FUNCTION allows
unlimited number of arguments?

Thanks a lot!
Carmen




_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

"Carmen Wai" <wai_carmen@hotmail.com> writes:
> I found that when I use CREATE FUNCTION in postgresql, the maximum
> number of arguments is 16 only. How I config so that the CREATE
> FUNCTION allows unlimited number of arguments?

Change FUNC_MAX_ARGS in src/include/pg_config.h, 'make clean',
recompile, re-install, and re-initdb.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

On Wednesday 07 Aug 2002 4:41 pm, Carmen Wai wrote:
> Hello:
>
> I found that when I use CREATE FUNCTION in postgresql, the maximum number
> of arguments is 16 only. How I config so that the CREATE FUNCTION allows
> unlimited number of arguments?

Check the mailing archives - there's a constant in pg_config.h you'll need to
increase and then recompile. Don't forget to dump your database first for
backup.

- Richard Huxton

Neil Conway sez:
} "Carmen Wai" <wai_carmen@hotmail.com> writes:
} > I found that when I use CREATE FUNCTION in postgresql, the maximum
} > number of arguments is 16 only. How I config so that the CREATE
} > FUNCTION allows unlimited number of arguments?
}
} Change FUNC_MAX_ARGS in src/include/pg_config.h, 'make clean',
} recompile, re-install, and re-initdb.

Is the initdb really necessary? Will the modified postmaster not work on
the existing data directory?

} Cheers,
} Neil
--Greg

Gregory Seidman <gss+pg@cs.brown.edu> writes:
> Neil Conway sez:
> } Change FUNC_MAX_ARGS in src/include/pg_config.h, 'make clean',
> } recompile, re-install, and re-initdb.

> Is the initdb really necessary?

Yes.

            regards, tom lane