Re: Call sql function in psql

Thanks

On Thu, Jan 18, 2018 at 10:01 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Thu, Jan 18, 2018 at 9:22 AM, Abhra Kar <abhra(dot)kar(at)gmail(dot)com> wrote:
>
>>
>> I tried to modify like
>>
>>
>>
>> sess.createSQLQuery("select reset_all()")
>>
>
> ​This part is correct​
>
>
>
>> .executeUpdate();
>>
>>
>>
>> getting error -- org.postgresql.util.PSQLException: A result was
>> returned when none was expected.
>>
>>
>>
> ​You need execute the above the same way you would execute "SELECT * FROM
> tbl"; then just ignore the result set that is returned.
>
> David J.
> ​
>