Return-Path: owner-postman Delivery-Date: Mon, 25 Apr 94 18:43:07 -0700 Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id PAA08534 for postgres-redist; Mon, 25 Apr 1994 15:48:13 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199404252248.PAA08534@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id PAA08525 for ; Mon, 25 Apr 1994 15:48:12 -0700 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id PAA08480; Mon, 25 Apr 1994 15:48:05 -0700 Message-Id: <199404252248.PAA08480@faerie.CS.Berkeley.EDU> X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: tjw00@spg.amdahl.com (Tom Wye) Cc: postgres@postgres.Berkeley.EDU, jimbo@crseo.ucsb.edu Subject: Re: Question about PGBROWSE and postgres 4.2 Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki) In-reply-to: Your message of Mon, 25 Apr 94 15:38:19 PDT <9404252238.AA00704@petal.spg.amdahl.com> Date: Mon, 25 Apr 94 15:48:05 -0700 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-redist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Mon, 25 Apr 94 15:48:13 -0700 Resent-XMts: smtp tjw00@spg.amdahl.com (Tom Wye) writes: > Looks like the ::field name gets appended when it should not. > replace sic (name="the firt record" > ) where sic.oid = "161504::oid" the correct syntax is where sic.oid = "161504"::oid if the quoted part above is what pgbrowse is actually putting together as its query, this will confuse any version of postgres.. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki