AW: GET DIAGNOSTICS (was Re: Open 7.1 items) - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: GET DIAGNOSTICS (was Re: Open 7.1 items)
Date
Msg-id 11C1E6749A55D411A9670001FA687963368201@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> We *do* need to support ROW_COUNT, but allowing
> 
>     GET DIAGNOSTICS Select ROW_COUNT, SQLCODE, OID Into :a,:b:,:c;
> 
> is a lot friendlier than the standard:
> 
>     GET DIAGNOSTICS :a = ROW_COUNT;
>     GET DIAGNOSTICS EXCEPTION 1 :b = SQLCODE;
>     GET DIAGNOSTICS :c = OID;
> 
> (not that we even support SQLCODE at this stage).

Informix does:GET DIAGNOSTICS :a = ROW_COUNT, EXCEPTION 1 :b = SQLCODE;

separated with comma, don't know if that is standard, but it sure looks more 
like the standard.

Andreas


pgsql-hackers by date:

Previous
From: Sascha Schumann
Date:
Subject: Re: PHP 4.0.4pl1 / Beta 5
Next
From: Larry Rosenman
Date:
Subject: Re: PHP 4.0.4pl1 / Beta 5