Insert/update

[Zdenek Janis]

Pro PG ulozenou procedurou:

create or replace function update_passwd
(varchar, /* jmeno */
  varchar) /* heslo */
returns boolean language 'plpgsql' as '
declare
	name	alias for $1;
	pass	alias for $2;
begin
	if exists(select jmeno from password where (jmeno = name)) then
		update password set heslo = pass where (jmeno = name);
	else
		insert into password (jmeno, heslo)
		values (name, pass);
	end if;
	return true;
end;
';

-- 
S pozdravem
                 Zdenek Janis