I've ran an update statement like this (obviously wrong, I know!):
update my_table
set boolean_field = true AND
my_notes = 'something'
where id in
(select id from my_table order by random() limit 4000);
in my psql client and I had a "UPDATE 4000" result but, correctly, anything
was changed
-- Forwarded message --
From: Mirko Pace
Date: Mon, Sep 28, 2009 at 2:59 PM
Subject: Re: [GENERAL] UPDATE statement with syntax error doesn't raise a
warning?
To: David W Noon
> I presume you meant "nothing" rather than "anything".
>
sorry
ines (then
supervisioned classification) and I'm using PgSQL extensively, mainly the
FTS functionalities, of course ;)
My method is a little bit unstable and "rough" in categorization, so I'm
looking for a "trigger" to improve it.
Thank you!
Mirko Pace
Why not call a function that make an insert as "insert into dummy values
('Start',now())" ?
Mirko
On Thu, Feb 19, 2009 at 5:37 PM, SHARMILA JOTHIRAJAH wrote:
> Hi,
> I want to find the time taken by this process ...retrieving data from
> oracle database using java and copying that to postgres
