| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> | 
|---|---|
| To: | DaVinci <bombadil(at)wanadoo(dot)es> | 
| Cc: | Lista PostgreSql <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Re: View and function | 
| Date: | 2001-04-17 18:39:15 | 
| Message-ID: | Pine.BSF.4.21.0104171138160.77539-100000@megazone23.bigpanda.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
> create function pilpot(calle) returns integer as '
> declare
>     c alias for $1;
> 	n integer;
> begin
>     insert into v_direccin(calle) values (c);
>     get diagnostics n = result_oid;
>     return n;
> end;
> ' language 'plpgsql';
> 
> ------------------------------------------------------------------
> 
>  I get an error when creating function of type:
> 
>  	ERROR:  ProcedureCreate: arg type 'calle' is not defined
calle is a field name right?  It's probably complaining at
pilpot(calle) since calle in that case is supposed to be a 
type name.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Limin Liu | 2001-04-17 18:56:36 | scan.c:900: warning: ... postgresql-7.1 | 
| Previous Message | Kevin L | 2001-04-17 18:19:49 | how to change table owner? |