Re: [GENERAL] sp: error message not coherent with actual code

2008-05-15 Thread Ivan Sergio Borgonovo
On Thu, 15 May 2008 20:36:21 +0200 Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote: > I've this line in a sp: > > select into _OrderGroupID b2c._OrderGroupID from > Basket2Order(_BasketID) as b2c; > > but I get this error: > > SELECT query has no destination for result data HINT: If you want to

[GENERAL] sp: error message not coherent with actual code

2008-05-15 Thread Ivan Sergio Borgonovo
I've this line in a sp: select into _OrderGroupID b2c._OrderGroupID from Basket2Order(_BasketID) as b2c; but I get this error: SELECT query has no destination for result data HINT: If you want to discard the results, use PERFORM instead. CONTEXT: PL/pgSQL function "basket2order" line 71 at SQL s