<html><head/><body><html><head><meta name="viewport" content="width=device-width" /><meta http-equiv="Content-Type" content="text/vnd.ui.secure+html;charset=utf-8" /></head><body style="overflow-wrap:break-word; word-break: break-word;"><div class="mail_android_message" style="line-height: 1; padding: 0.5em">Does anyone know why a functional website was charged into the new one? In particular the forum<br>
-- <br>
Sent from my Android phone with <a href="http://mail.com">mail.com</a> Mail. Please excuse my brevity.</div><div class="mail_android_quote" style="line-height: 1; padding: 0.3em">On 20/07/2017, 14:52 Roy Hann <specially@processed.almost.meat> wrote:<blockquote class="gmail_quote" style="margin: 0.8ex 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
If anyone was wondering what that RPP was that I was trying to post on<br />
the Actian communite site, here it is:<br />
<br />
create procedure burst_csv ( in csv varchar(250) not null )<br />
result row fields ( field varchar(25) not null )<br />
as<br />
declare field varchar(25) not null;<br />
begin<br />
while length(csv) > 0<br />
do<br />
field=left(csv,locate(csv,',')-1);<br />
csv=shift(csv,-locate(csv,','));<br />
return row (field);<br />
endwhile;<br />
end;<br />
<br />
And here's the example of running it:<br />
<br />
* select * from burst_csv('tomato,extra cheese,olives,pepperoni') \g<br />
Executing . . .<br />
<br />
<br />
+-------------------------+<br />
|field |<br />
+-------------------------+<br />
|tomato |<br />
|extra cheese |<br />
|olives |<br />
|pepperoni |<br />
+-------------------------+<br />
(4 rows)<br />
_______________________________________________<br />
Info-ingres mailing list<br />
Info-ingres@lists.planetingres.org<br />
<a href="http://lists.planetingres.org/mailman/listinfo/info-ingres" target="_blank">http://lists.planetingres.org/mailman/listinfo/info-ingres</a><br />
</blockquote></div></body></html></body></html>