citydb=> \d districts
               Table "districts"
  Column  |          Type          | Modifiers
----------+------------------------+-----------
district | integer                | not null
street   | character varying(25)  | not null
house    | character varying(5)[] | not null
Check constraints: "checkdistrictvalue" ((district > 0) AND (district <= 43))

citydb=> \d deputies
                                                     Table "deputies"
      Column      |          Type          |                                   Modifiers                                  
------------------+------------------------+-------------------------------------------------------------------------------
id               | integer                | not null default nextval('"deputies_id_seq"'::text)
year_of_assembly | smallint               | default date_part('YEAR'::text, '2002-12-20 22:52:44.643858+02'::timestamptz)
district         | integer                | not null
commission       | character varying(150) |
lastname         | character varying(50)  | not null
firstname        | character varying(50)  | not null
middlename       | character varying(50)  | not null
date_of_birth    | date                   | not null
work_phone       | integer                |
party_membership | character varying(250) |
education        | character varying(500) |
Primary key: deputies_pkey
Unique keys: deputies_district_key
Triggers: in_districts

citydb=> SELECT id,lastname,firstname,middlename,street FROM deputies,districts USING (district);
ERROR:  parser: parse error at or near "USING"

SELECT id,lastname,firstname,middlename,street FROM deputies NATURAL JOIN districts;
и
SELECT id,lastname,firstname,middlename,street FROM deputies,districts WHERE deputies.district=districts.district;
РАБОТАЮТ!

что я делаю не так? почему не работает USING?

• RE: не выходит USING (field) в Postgres, konst, 14:42 , 23-Дек-02, (1)