U++ forum: Welcome to the forum

Re: Postgres and CurrVal [message #23046 is a reply to message #23044]

Thu, 10 September 2009 14:12

mirek
Messages: 14267
Registered: November 2005

Ultimate Member

Zbych wrote on Thu, 10 September 2009 06:52

luzr wrote on Thu, 10 September 2009 12:01

which IMO is correct.

I would need a more complete testcase to investigate the issue...

Sorry, my mistake. I had to replace upp's SqlInsert with "query in string" + ExecuteX to insert many rows at once, and I've used ~CurrVal(). That's why I had this funny version of currval.

BTW. Is there a way to force SqlInsert, to create single insert with many rows:

insert into testpartner (testpartner_name, testpartner_address)
values
('qweqwe','qweqweqwe'),
('qweqwe','qweqweqwe'),
('qweqwe','qweqweqwe'),
('qweqwe','qweqweqwe')

Not yet. Maybe we could add Next() method:

Insert(TESTPARTNER)(NAME, "A").Next()(NAME, "B")

or maybe overload some operator

Insert(TESTPARTNER)(NAME, "A")/(NAME, "B")

Before we do, we should check if it is possible to do this in all supprted SQLs. E.g. this looks quite different:

http://www.techonthenet.com/sql/insert.php

Mirek

Report message to a moderator