This is not a stored process. This is a vendor provided database so I do not have write access to the database in order to store new processes/functions.<div><br></div><div>I would normally do this in PHP however I am trying to get this query to run from our monitoring toolset (NimSoft's NimBUS) which cannot pass in the required variable.</div>
<div><br clear="all"><b>Richard Maloley II</b><div><i>Rick and Richard Computer Consulting</i></div><div>p: 616-745-6914</div><div>e: <a href="mailto:richard@rrcomputerconsulting.com" target="_blank">richard@rrcomputerconsulting.com</a></div>
<div>w: <a href="http://www.rrcomputerconsulting.com" target="_blank">http://www.rrcomputerconsulting.com</a></div><div><br></div><br>
<br><br><div class="gmail_quote">On Tue, Apr 12, 2011 at 2:23 PM, Roger Roelofs <span dir="ltr"><<a href="mailto:roger.roelofs@gmail.com">roger.roelofs@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Richard,<br>
<br>
Is this a stored proc? We hormally handle stuff like this by<br>
dynamically constructing the sql in php.<br>
<div><div></div><div class="h5"><br>
On Tue, Apr 12, 2011 at 2:10 PM, Richard Maloley II<br>
<<a href="mailto:richard@rrcomputerconsulting.com">richard@rrcomputerconsulting.com</a>> wrote:<br>
> Hello,<br>
> I'm trying to create a really simple query against a Postgresql database.<br>
> This database creates a new table every single day for daily statistics,<br>
> therefore all tables are named the same except for the different date<br>
> appended to the name.<br>
> My query right now is simple: Execute a single SQL statement that will<br>
> gather data from the correct daily table depending on the day. For example:<br>
> SELECT * FROM tnt_audit.summaryreport_login_stats_20110412;<br>
> The above query will select all of the data for today. The date piece,<br>
> 20110412, needs to be dynamically changed. Here is what I thought of:<br>
> SELECT<br>
> *<br>
> FROM<br>
> tnt_audit.summaryreport_login_stats_(CURRENT_DATE)<br>
> ;<br>
> However this results in the following error message:<br>
> ERROR: function tnt_audit.summaryreport_login_stats_(date) does not exist<br>
> LINE 4: tnt_audit.summaryreport_login_stats_(CURRENT_DATE)<br>
> ^<br>
> HINT: No function matches the given name and argument types. You might need<br>
> to add explicit type casts.<br>
> ********** Error **********<br>
> ERROR: function tnt_audit.summaryreport_login_stats_(date) does not exist<br>
> SQL state: 42883<br>
> Hint: No function matches the given name and argument types. You might need<br>
> to add explicit type casts.<br>
> Character: 17<br>
> I'm no SQL expert and I've been unable to find any direction on how to<br>
> accomplish this. I feel as though it should be simple to append this data to<br>
> the table name but the answer eludes me. For reference we are using version<br>
> 8.x of the database.<br>
> Thanks,<br>
> Richard Maloley II<br>
> Rick and Richard Computer Consulting<br>
> p: <a href="tel:616-745-6914" value="+16167456914">616-745-6914</a><br>
> e: <a href="mailto:richard@rrcomputerconsulting.com">richard@rrcomputerconsulting.com</a><br>
> w: <a href="http://www.rrcomputerconsulting.com" target="_blank">http://www.rrcomputerconsulting.com</a><br>
><br>
><br>
</div></div>> --<br>
> This message has been scanned for viruses and<br>
> dangerous content by MailScanner, and is<br>
> believed to be clean.<br>
> _______________________________________________<br>
> grlug mailing list<br>
> <a href="mailto:grlug@grlug.org">grlug@grlug.org</a><br>
> <a href="http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug" target="_blank">http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug</a><br>
><br>
<br>
<br>
<br>
--<br>
Roger<br>
<br>
Roger Roelofs<br>
Know what you value.<br>
<br>
--<br>
This message has been scanned for viruses and<br>
dangerous content by MailScanner, and is<br>
believed to be clean.<br>
<br>
_______________________________________________<br>
grlug mailing list<br>
<a href="mailto:grlug@grlug.org">grlug@grlug.org</a><br>
<a href="http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug" target="_blank">http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug</a><br>
</blockquote></div><br></div>
<br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.