Re: View and function - Mailing list pgsql-general

From Thomas F. O'Connell
Subject Re: View and function
Date
Msg-id 3ADC6E71.7050804@monsterlabs.com
Whole thread Raw
In response to View and function  (DaVinci <bombadil@wanadoo.es>)
List pgsql-general
DaVinci wrote:


> create function pilpot(calle) returns integer as '

this is your problem. try this:

create function pilpot(text) returns integer as '

the syntax for creating postgres functions is to declare the types, not
the identifiers of any parameters.

-tfo




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: drastic reduction in speed of inserts as the table grows
Next
From: Tom Lane
Date:
Subject: Re: pg_dump error