Re: View and function - Mailing list pgsql-general

From Stephan Szabo
Subject Re: View and function
Date
Msg-id Pine.BSF.4.21.0104171138160.77539-100000@megazone23.bigpanda.com
Whole thread Raw
In response to View and function  (DaVinci <bombadil@wanadoo.es>)
List pgsql-general
> create function pilpot(calle) returns integer as '
> declare
>     c alias for $1;
>     n integer;
> begin
>     insert into v_direcci�n(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.


pgsql-general by date:

Previous
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: gzip and bzip2 (distributing postgresql)
Next
From: Kevin L
Date:
Subject: how to change table owner?