[Bug-apl] SQL: problem reading from a PostgreSQL database

[Blake McBride]

$ psql arahant postgres
psql (9.1.13)
Type "help" for help.

arahant=# select * from hr_position;

   position_id    | position_name |   org_group_id   | first_active_date |
last_active_date | benefit_class_id
------------------+---------------+------------------+-------------------+------------------+------------------
 00001-0000000001 | Programmer    | 00001-0000000001 |                 0 |
               0 |
 00001-0000000002 | Sales         | 00001-0000000001 |                 0 |
               0 |
 00001-0000000003 | Manager       | 00001-0000000001 |                 0 |
               0 |
 00001-0000000004 | Bookkeeper    | 00001-0000000001 |                 0 |
               0 |
(4 rows)

arahant=#


Now in APL

      db←'postgresql' SQL∆Connect 'host=localhost user=postgres
password=postgres dbname=arahant'
      db
0
      res←'select * from hr_position' SQL∆Select[db] ⍬
DOMAIN ERROR
SQL∆Select[1]  Z←X SQL[3,db]Y
                 ^          ^

Just FYI:

arahant=# \d hr_position
                   Table "public.hr_position"
      Column       |         Type          |     Modifiers
-------------------+-----------------------+--------------------
 position_id       | character(16)         | not null
 position_name     | character varying(30) | not null
 org_group_id      | character(16)         | not null
 first_active_date | integer               | not null default 0
 last_active_date  | integer               | not null default 0
 benefit_class_id  | character(16)         |


Thanks!

Blake