Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 659B39FB39A for ; Sat, 20 Jan 2007 00:57:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 27541-08 for ; Sat, 20 Jan 2007 00:57:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31808.mail.mud.yahoo.com (web31808.mail.mud.yahoo.com [68.142.207.71]) by postgresql.org (Postfix) with SMTP id 4566E9FB2F9 for ; Sat, 20 Jan 2007 00:57:38 -0400 (AST) Received: (qmail 78906 invoked by uid 60001); 20 Jan 2007 04:57:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=iltuOkyD7eDXKjU3X17XG/CyrMLe2KFsAdFgMc+367LWFEza/qPl9FHCN94LHdMD6lHizGDVOORVm9AYIr2Eg0z+ZeK0kcapOj0JLi5TOavHcbrFFzpv5ZSPo12z2Rso8QSMwRW98+cvLyI5edgWqAvL3e7hT8RGLk/1c9DUbfM=; X-YMail-OSG: f4Dd10oVM1lDvDOaDmF7UJBHpSNLpMV8w.NzYldDS2a0gUAUkwW2hCzqXXwGpOYTFd2Exw-- Received: from [75.84.83.178] by web31808.mail.mud.yahoo.com via HTTP; Fri, 19 Jan 2007 20:57:37 PST Date: Fri, 19 Jan 2007 20:57:37 -0800 (PST) From: Richard Broersma Jr Subject: Re: select based on multi-column primary keys To: Bruno Wolff III , mawrya Cc: pgsql-sql@postgresql.org In-Reply-To: <20070120014524.GC30390@wolff.to> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <244523.74626.qm@web31808.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.918 tagged_above=0 required=5 tests=AWL, BAYES_40, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: * X-Archive-Number: 200701/89 X-Sequence-Number: 27241 > 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.