Hi,
I’m encountering some weird problem on Update.
I have a program that updates a table and it updates more
than 1 column at a single query.
Like this one:
Update table1 set column1 = ‘a’, column2 = ‘b’,
column3 = time ’08:00 AM’ where column1 = ‘c’
Sometimes only column1
> > how can i exclude true values for this query?
> >
> > http://www.rafb.net/paste/results/obtkGz26.html
> >
> > if i uncomment out
> >
> > --AND t_inspect_result.inspect_result_pass = 'f'
> >
> > it looks for prior falses within an inspect_id and
> > returns it. i want the original res
> > hi all,
> >
> > how can i exclude true values for this query?
> >
> > http://www.rafb.net/paste/results/obtkGz26.html
> >
> > if i uncomment out
> >
> > --AND t_inspect_result.inspect_result_pass =
> 'f'
> >
> > it looks for prior falses within an inspect_id and
> > returns it. i wan
> hi all,
>
> how can i exclude true values for this query?
>
> http://www.rafb.net/paste/results/obtkGz26.html
>
> if i uncomment out
>
> --AND t_inspect_result.inspect_result_pass = 'f'
>
> it looks for prior falses within an inspect_id and
> returns it. i want the original result set
hi all,
how can i exclude true values for this query?
http://www.rafb.net/paste/results/obtkGz26.html
if i uncomment out
--AND t_inspect_result.inspect_result_pass = 'f'
it looks for prior falses within an inspect_id and
returns it. i want the original result set minus the
trues, if poss
Mauro Bertoli wrote:
Hi, I've a field that contain values-comma-separated
like
A) 1;2;3;;5 -- ;2;;4;5
but also
B) 12;34;18
how I can get the max value?
For A I tried:
SELECT max(array_upper(string_to_array(answer,';'),1))
FROM values;
and work fine, but for B case I don't find a solution
like
SE
On Fri, Jun 02, 2006 at 01:06:40PM -0700, [EMAIL PROTECTED] wrote:
> hi all,
>
> SUMMARY:
>
> i want to replace
>
> AND t_inspect.inspect_pass = 'f'
>
> with a complex query that yields the same result. the
> complex query is in the form of...
[snip]
But your complex query isn't in the form
