On Wed, Apr 28, 1999 at 01:12:47PM -0400, Margarita Barvinok wrote:
>
> This is from the Tutorial for version 6.4 of PostgreSQL.
>
> FETCH [ selector ] [ count ]
> { IN | FROM } cursor
> FETCH [ RELATIVE ] [ { [ # | ALL | NEXT | PRIOR ] } ]
> FROM ] cursor
>
> I think ' { IN | FROM }
This is from the Tutorial for version 6.4 of PostgreSQL.
FETCH [ selector ] [ count ]
{ IN | FROM } cursor
FETCH [ RELATIVE ] [ { [ # | ALL | NEXT | PRIOR ] } ]
FROM ] cursor
I think ' { IN | FROM } ' means that you must type IN or FROM
-Margarita
On Wed, 28 Apr 1999, Artur Pietruk
On Wed, Apr 28, 1999 at 10:11:21AM -0400, Margarita Barvinok wrote:
>
> This work for me:
>
> EXEC SQL FETCH 1 IN exam_cur INTO :ex_id, :wday;
>
> I think it must work without '1' also.
Thank's a lot! I didn't expect it... It works with 'exec sql fetch
FROM...' too..
This work for me:
EXEC SQL FETCH 1 IN exam_cur INTO :ex_id, :wday;
I think it must work without '1' also.
-Margarita
On Wed, 28 Apr 1999, Artur Pietruk wrote:
> Hi! I'm new on this mailing-list.
>
> I have problems with ecpg and postgres6.4, it fails when i tr
Hi! I'm new on this mailing-list.
I have problems with ecpg and postgres6.4, it fails when i try to
fetch cursor, example code:
---
EXEC SQL DECLARE M_KURSOR CURSOR FOR
SELECT te_lo, te_hi
FROM www_temp
WHERE te_mias = :t_mias;
EXEC SQL OP
