<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://wiki.isikhnas.com/index.php?action=history&amp;feed=atom&amp;title=Database_functions</id>
	<title>Database functions - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.isikhnas.com/index.php?action=history&amp;feed=atom&amp;title=Database_functions"/>
	<link rel="alternate" type="text/html" href="https://wiki.isikhnas.com/index.php?title=Database_functions&amp;action=history"/>
	<updated>2026-09-17T19:29:13Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.31.16</generator>
	<entry>
		<id>https://wiki.isikhnas.com/index.php?title=Database_functions&amp;diff=7353&amp;oldid=prev</id>
		<title>Ben at 03:20, 25 August 2014</title>
		<link rel="alternate" type="text/html" href="https://wiki.isikhnas.com/index.php?title=Database_functions&amp;diff=7353&amp;oldid=prev"/>
		<updated>2014-08-25T03:20:00Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;id&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #222; text-align: center;&quot;&gt;← Revisi sebelumnya&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #222; text-align: center;&quot;&gt;Revisi per 25 Agustus 2014 03.20&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l1&quot; &gt;Baris 1:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Baris 1:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;- test mode -&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;{{#apGetSQL:select&amp;#160; &amp;#160;&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;{{#apGetSQL:select&amp;#160; &amp;#160;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;#160;&amp;#160; format($$&amp;lt;h3&amp;gt;%1$s&amp;lt;/h3&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;#160;&amp;#160; format($$&amp;lt;h3&amp;gt;%1$s&amp;lt;/h3&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Ben</name></author>
		
	</entry>
	<entry>
		<id>https://wiki.isikhnas.com/index.php?title=Database_functions&amp;diff=826&amp;oldid=prev</id>
		<title>Catriona: Created page with &quot;{{#apGetSQL:select     format($$&lt;h3&gt;%1$s&lt;/h3&gt; &lt;dt&gt;Function call: &lt;/dt&gt;&lt;dd&gt;%1$s (%2$s) %3$s&lt;/dd&gt; &lt;dt&gt;Schema: &lt;/dt&gt;&lt;dd&gt;%4$s&lt;/dd&gt;%5$s $$,fname, string_agg(format('%s%s %s',   cas...&quot;</title>
		<link rel="alternate" type="text/html" href="https://wiki.isikhnas.com/index.php?title=Database_functions&amp;diff=826&amp;oldid=prev"/>
		<updated>2014-02-25T03:31:47Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;{{#apGetSQL:select     format($$&amp;lt;h3&amp;gt;%1$s&amp;lt;/h3&amp;gt; &amp;lt;dt&amp;gt;Function call: &amp;lt;/dt&amp;gt;&amp;lt;dd&amp;gt;%1$s (%2$s) %3$s&amp;lt;/dd&amp;gt; &amp;lt;dt&amp;gt;Schema: &amp;lt;/dt&amp;gt;&amp;lt;dd&amp;gt;%4$s&amp;lt;/dd&amp;gt;%5$s $$,fname, string_agg(format(&amp;#039;%s%s %s&amp;#039;,   cas...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Halaman baru&lt;/b&gt;&lt;/p&gt;&lt;div&gt;{{#apGetSQL:select  &lt;br /&gt;
  format($$&amp;lt;h3&amp;gt;%1$s&amp;lt;/h3&amp;gt;&lt;br /&gt;
&amp;lt;dt&amp;gt;Function call: &amp;lt;/dt&amp;gt;&amp;lt;dd&amp;gt;%1$s (%2$s) %3$s&amp;lt;/dd&amp;gt;&lt;br /&gt;
&amp;lt;dt&amp;gt;Schema: &amp;lt;/dt&amp;gt;&amp;lt;dd&amp;gt;%4$s&amp;lt;/dd&amp;gt;%5$s&lt;br /&gt;
$$,fname, string_agg(format('%s%s %s',&lt;br /&gt;
  case direction &lt;br /&gt;
    when 'o' then 'OUT ' &lt;br /&gt;
    when 'b' then 'INOUT '&lt;br /&gt;
    else '' end , argname, datatype), ', '), returntype, schema, &lt;br /&gt;
case when description is null then ''&lt;br /&gt;
else format('&amp;lt;dt&amp;gt;Description: &amp;lt;/dt&amp;gt;&amp;lt;dd&amp;gt;%s&amp;lt;/dd&amp;gt;',description) end&lt;br /&gt;
) as function &lt;br /&gt;
from&lt;br /&gt;
(select *&lt;br /&gt;
from backoffice.list_functions()&lt;br /&gt;
where not schema in ('public','pg_catalog','information_schema','report')&lt;br /&gt;
order by schema, fname, foid, direction, pos) as foo&lt;br /&gt;
group by schema, fname, foid, returntype, description&lt;br /&gt;
order by function;|}}&lt;/div&gt;</summary>
		<author><name>Catriona</name></author>
		
	</entry>
</feed>