Blog

PostgreSQL – Elapsed Years

One of the things that I had to do recently was develop an example iReport which would exemplify how to achieve optional variables solely through the Java code within the JRXML file. My example consisted of creating a query that could serve as an example table named people which contained Read more…

By Chris West, ago
Blog

PostgreSQL – String To Rows

Working Solution – Custom Function I have to say that using PostgreSQL has been great compared to MySQL. Recently, though, I ran into an issue while working with iReports designer. I needed to be able to accept a string of comma-delimited integers and then JOIN on those ID’s. Therefore, I Read more…

By Chris West, ago