On 02/10/2017 01:51 PM, Roberto Balarezo wrote:
>
>> Hi,
>>
>> The parameter defaultDueDate is a java.sql.Date object, an actual Date.
>> When I run the query with the value in it, it works:
>> ```sql
>> db=> select COALESCE(duedate, date '2017
this and I would
like to know why it happens and if I can make it work changing the query
and not the code.
2017-02-10 15:38 GMT-05:00 rob stone <floripa...@gmail.com>:
> Hello Roberto,
> On Fri, 2017-02-10 at 10:17 -0500, Roberto Balarezo wrote:
> > Hi, I would like to know why
an.kla...@aklaver.com>:
> On 02/10/2017 07:17 AM, Roberto Balarezo wrote:
>
>> Hi, I would like to know why this is happening and some advice if there
>> is a way to solve this problem:
>>
>> I have a query like this:
>>
>> |select COALESCE(duedate, ? +
a date with one day added. So the query is correct.
2017-02-10 16:33 GMT-05:00 Arjen Nienhuis <a.g.nienh...@gmail.com>:
>
>
> On Feb 10, 2017 8:11 PM, "Roberto Balarezo" <rober...@gmail.com> wrote:
>
> Hi, I would like to know why this is happening and som
Hi, I would like to know why this is happening and some advice if there is
a way to solve this problem:
I have a query like this:
select COALESCE(duedate, ? + 1) from invoices order by duedate desc limit 10;
where ? is a query parameter. I’m using JDBC to connect to the database,
and sending
Hi,
I was trying to clean a database by deleting records of some of its tables.
But in our model we have a table that is heavily referenced, that is, many
tables reference this particular table by foreign key constraints. We don't
have foreign key indexes, so executing a delete from mytable takes