Re: cost variable into function - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: cost variable into function
Date
Msg-id 20081019141942.GA13492@depesz.com
Whole thread Raw
In response to cost variable into function  ("Alain Roger" <raf.news@gmail.com>)
List pgsql-general
On Sun, Oct 19, 2008 at 04:03:47PM +0200, Alain Roger wrote:
> i created a stored procedure (function) under postgreSQL and when i checked
> deeper into my DB, this is what i get:
> ....
>     END;
> $BODY$
>   LANGUAGE 'plpgsql' VOLATILE
>   COST 100;
> ALTER FUNCTION myschema.get_count_languages(character varying) OWNER TO
> myuser;
> to what corresponds the parameter COST 100 ?

check the explanation here:
http://www.postgresql.org/docs/current/interactive/sql-createfunction.html

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: cost variable into function
Next
From: "That Fat Guy"
Date:
Subject: Problem removing Sequence in Postgresql 8.0.3