Re: select based on multi-column primary keys - Mailing list pgsql-sql

> SELECT * FROM iopoints WHERE systemid=123 AND enclosureid='ab' AND pointid=56

A slight variation of the syntax would be: 

select * from iopoints where (systemid, enclosureid, pointid) = (123,'ab',56);

this table and fields sounds alot like a control system be being modeled. :-)

Regards,
Richard Broersma Jr.