Guys, sometimes I make stupid things...
I t was the END IF as all of you said...
Thanks for your exists.
Cheers,
Rodrigo
Tom Lane wrote:
Rodrigo Carvalhaes <[EMAIL PROTECTED]> writes:
I am trying to make an IF / ELSE / END IF inside of a FOR ... LOOP but I
am g
ES (82,
'Fulano', 3484, true);
INSERT INTO table1 (code, name, old_code, is_customer) VALUES (1,
'Beltrano', 3454, false);
INSERT INTO table1 (code, name, old_code, is_customer) VALUES (4,
'Madicon', 23, false);
Cheers,
Rodrigo Carvalhaes
--
Esta mensa
Thanksyou and Franz for your help. Simple and efficient... I was
blind The plpgsql "for" is the perfect solution
It was great. Have a nice week!!!
Cheers,
Rodrigo Carvalhaes
Christoph Haller wrote:
Rodrigo Carvalhaes wrote:
Hi Guys!
I need to make an UPDATE o
SQL" is UPDATE table SET code
= nextval('sequence') ORDER BY description
I searched a lot on the NET without ant "tip" for my case.
It's a very simple need but I am not able to solve it...
Anyone knows how I can do it?
Cheers,
--
Rodrigo Carvalhaes
--
Dear Jeff,
Thank you for your help.
I tried : select max((id::text)::integer) from test;
and works perfectly!
Greetings from Brazil!
Rodrigo Carvalhaes
Jeff Eckermann wrote:
--- Rodrigo Carvalhaes <[EMAIL PROTECTED]> wrote:
Hi !
I am quite confused of the results on a SELECT
max
Hi !
I am quite confused of the results on a SELECT max...
My environment:
Conectiva Linux 10, PostgreSQL 7.4.6 (compiled from the sources)
My problem is the "select max(id) FROM test" the result is 20 but the
right is 1020. Is this a BUG or I am crazy ??
Cheers,
Rodrigo Carvalha
