<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Forum PostgreSQL - Zwracany wynik z procedury]]></title>
		<link>https://forum.postgresql.org.pl/viewtopic.php?id=431</link>
		<description><![CDATA[Najświeższe odpowiedzi w Zwracany wynik z procedury.]]></description>
		<lastBuildDate>Wed, 21 Apr 2010 10:20:49 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Odp: Zwracany wynik z procedury]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=1984#p1984</link>
			<description><![CDATA[na szybko 
[code]
CREATE OR REPLACE FUNCTION add_activity(idik integer)
  RETURNS integer AS
$BODY$declare 
numrows int;
begin
insert into t1 select * from t2 where id between $1 and $1+2;
GET DIAGNOSTICS numrows = ROW_COUNT;
return numrows;
end;$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;
[/code]]]></description>
			<author><![CDATA[dummy@example.com (psocha)]]></author>
			<pubDate>Wed, 21 Apr 2010 10:20:49 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=1984#p1984</guid>
		</item>
		<item>
			<title><![CDATA[Odp: Zwracany wynik z procedury]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=1975#p1975</link>
			<description><![CDATA[A nie prościej napisać funkcję w plpgsql?]]></description>
			<author><![CDATA[dummy@example.com (rski)]]></author>
			<pubDate>Mon, 19 Apr 2010 16:46:35 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=1975#p1975</guid>
		</item>
		<item>
			<title><![CDATA[Zwracany wynik z procedury]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=1974#p1974</link>
			<description><![CDATA[Jak zrobić aby zwrócić z procedury ilość wstawionych/aktualizowanych wierszy?


CREATE OR REPLACE FUNCTION add_activity(date = CURRENT_DATE) 
RETURNS integer AS $$
	DELETE FROM activity as a WHERE a.date = $1;

	INSERT INTO activity 
	SELECT v.vid, v.uid, v.aid, v.pop, p.pop_total, $1 as insertDate
	FROM players as p, villages as v
	WHERE v.uid = p.uid
	RETURNING 1;

$$ LANGUAGE SQL;


zamiast zwracanej wartości 1 chciałbym aby była ilość wstawianych wierszy.]]></description>
			<author><![CDATA[dummy@example.com (akoliber)]]></author>
			<pubDate>Mon, 19 Apr 2010 15:04:06 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=1974#p1974</guid>
		</item>
	</channel>
</rss>
