****************** FETCH test ****************** # Connected Databases List (C: current database is '*') C | connect_name | user_name | target_name(db@host:port) | client_encoding ---+--------------+-----------+---------------------------+----------------- * | db1 | pgbash | pgbash_db1:5432 | (1 row) code | name | address ------+----------+---------- 1 | sakaida | osaka 2 | postgres | -NULL- 11 | mywife | kobe 11 | child1 | hirosima 11 | child2 | akasi (5 rows) # fetch case no.1 code=1 :0, name=sakaida :0, address=osaka :0 code=2 :0, name=postgres :0, address= :-1 code=11 :0, name=mywife :0, address=kobe :0 code=11 :0, name=child1 :0, address=hirosima :0 code=11 :0, name=child2 :0, address=akasi :0 # fetch case no.2 code=1 :0, name=sakaida :0, address=osaka :0 code=2 :0, name=postgres :0, address= :-1 code=11 :0, name=mywife :0, address=kobe :0 ------------- Error Test ---------------- Error SQL : fetch in cur INTO :CODE indicator :IND_C, :NAME/:IND_N, :ADDRESS :IND_A; (-403)ERROR: parser: parse error at or near "INTO" (-201)Error: too many arguments. (-202)Error: too few arguments.