-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi,
On Tue, 19 Oct 2004, Hicham G. Elmongui wrote:
I tried creating the function (from sec 19.3.1). But it gives me the following error: "ERROR: type tablename does not exist". Any ideas of what i might be doing wrong?
You have to write the data type while defining the function parameters. For example,
CREATE FUNCTION use_many_fields(varchar) RETURNS TEXT AS '
...and then declare it as you've done below:
DECLARE in_t ALIAS FOR $1;
Regards,
- --
Devrim GUNDUZ devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBdTIVtl86P3SPfQ4RAj5vAKC2ugU2wcXHDgMMybyMqm14L4+9UwCfUd7m 7WQxt0yl0PHuezSucptNLtE= =Z94K -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html