pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: geraldo <geraldo@umc.br>
To: pgsql-sql@postgresql.org
Subject: function problem
Date: Tue, 21 Oct 2003 10:25:14 -0200
Message-ID: <AKEMKCHOALAOGDNFIGFAEEABCAAA.geraldo@umc.br> (raw)

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.




view thread (13+ messages)  latest in thread

Message-ID: <AKEMKCHOALAOGDNFIGFAEEABCAAA.geraldo@umc.br>
Permalink:  ../AKEMKCHOALAOGDNFIGFAEEABCAAA.geraldo@umc.br/
Also on:    postgresql.org/message-id/AKEMKCHOALAOGDNFIGFAEEABCAAA.geraldo@umc.br

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: geraldo@umc.br
  Subject: Re: function problem
  In-Reply-To: <AKEMKCHOALAOGDNFIGFAEEABCAAA.geraldo@umc.br>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox