[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