[GENERAL] code in docs gives me an error

2004-10-19 Thread Hicham G. Elmongui
Hi 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? CREATE FUNCTION use_many_fields(tablename) RETURNS TEXT AS ' DECLARE in_t ALIAS FOR $1; BEGIN RETURN in_t.f1 || in_t.f3

Re: [GENERAL] code in docs gives me an error

2004-10-19 Thread Devrim GUNDUZ
-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

Re: [GENERAL] code in docs gives me an error

2004-10-19 Thread Tom Lane
Hicham G. Elmongui [EMAIL PROTECTED] writes: 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? CREATE FUNCTION use_many_fields(tablename) RETURNS TEXT AS ' The example assumes