function problem

From: "geraldo" <geraldo(at)umc(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: function problem
Date: 2003-10-21 12:25:14
Message-ID: AKEMKCHOALAOGDNFIGFAEEABCAAA.geraldo@umc.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Can anybody tell me why the following code when activated
by a select only affects the first line of the table???
create or replace function increase(integer)
returns void as 'update tab set price=price*(1+$1/100.0)'
language sql;
Thanks.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jclaudio 2003-10-21 13:08:28 how to create a multi columns return function ?
Previous Message Michael Glaesmann 2003-10-21 12:09:56 Many joins: monthly summaries S-L--O--W