Vernon,
> >> One field of a table stores an array of characters in a string fromat as
> >> "a,b,c,d". Is anyway to apply a select statement without using stored
> >> procedure?
> The reason I use this format for an array is that the array is dynamic. I
have quite few cases of this type of situa
Hi, Richard,
Thanks for your response and see below.
10/21/2002 3:13:57 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
>On Friday 18 Oct 2002 1:58 pm, Vernon Wu wrote:
>> One field of a table stores an array of characters in a string fromat as
>> "a,b,c,d". Is anyway to apply a select stateme
I have a long running process that performs outside actions on the content of a table.
The actions could all be done in parallel (if I had n processors), but I need to
ensure that the process is attempted exactly one time per applicable row.
My current design for one thread is the following (si
Tom,
> > INSERT INTO order_spec ( job_type, order_usq, no_needed, start_time,
> > end_time, pay_rate, bill_rate )
> > VALUES ( current_type, new_usq, numbers[spec_loop],
>sttimes[spec_loop],
> > endtimes[spec_loop],
> > pays[spec_loop], bills[spec_loo
Josh Berkus <[EMAIL PROTECTED]> writes:
> ones. Here's the relevant code:
> IF v_usq > 0 THEN -- Note: v_usq is > 0 for all existing records
> DELETE FROM order_spec WHERE order_usq = v_usq;
> END IF;
> ...
> INSERT INTO order_spec ( job_type, order_usq, no
Folks,
I seem to be experiencing a rather elusive bug in 7.2.3, and I wanted to talk
it over before submitting it to pgsql-bugs, to see if anyone else has
experienced anything similar.
1. I have a function (fn_save_order) which is a long and complex data
verification and dependant data updati
On Mon, Oct 21, 2002 at 11:54:53AM +0100, Tiago Moitinho wrote:
> Hi,
>
> I would like to know if this is possible:
>
> I have a database A, with a table X.
> Is it possible, being logged in another database (B, for instance), to make
> queries using table X from database A?
> (something like "S
John,
> > > Do any existing drivers / database version combinations support
> the
> > > isAutoIncrement method?
> >
> > What programming language are you referring to? VB? Delphi?
> >
>
> Java / JDBC
In that case, post your question on [EMAIL PROTECTED] You
are unlikely to get an answer on
