Re: [Fwd: Re: [osdldbt-general] questions about OSDL-DBT1]

[Jenny Z. <je...@os...>]

Hi,

You are right on both of them.  I will fix them.

Thanks,
Jenny
On Thu, 2004-03-18 at 11:33, Shuqing Wu wrote:
> Hi Jenny:
> 
> Thank you.
> 
> > Can you be more specific about the problem?  We have some tools to test
> > the stored procedure.  Maybe I can help you test it.
> 
> In buy_confirm.sql:
>    SELECT addr_id, co_id 
>    INTO _ship_addr_id, _co_id 
>    FROM address, country
>    WHERE co_name = _country 
>     AND addr_co_id = _co_id                        <--
>     AND addr_zip = _addr_zip 
>     AND addr_state = _addr_state 
>     AND addr_city = _addr_city 
>     AND addr_street1 = _addr_street1 
>     AND addr_street2 = _addr_street2;
> 
> Maybe that is correct. I do not know PL/SQL very well.
> _co_id is a local variable, can you use it before before it is assigned
> a value? (I think co_id is an attribute of country.)
> 
> Then after this SELECT statement:
>    IF FOUND THEN
> Should that be NOT FOUND?
> 
> > Also if you do not mind, can you tell me the goal of your project?
> 
> Sure. I am working on postgres-r project. My part of work is to add
> synchronous and update-everywhere replication to postgresql. The 
> project was based on v7.2.
> 
> And I found mix.log. I will check if I can get the statistics result again.
> Thank you very much.
> 
> Regards
> 
> Shuqing