Blog

PostgreSQL – Week Number To Date

Yesterday, I was asked if a function exists in PostgreSQL that will accept the year and the week number and will return a day in that week. Unfortunately, I was not able to find one, but perhaps one natively exists (HINT: let me know if one exists by commenting ;)). Read more…

By Chris West, ago
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