agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Paul M. Aoki <aoki@postgres.Berkeley.EDU>
To: Tom Wye <tjw00@spg.amdahl.com>
Cc: postgres@postgres.Berkeley.EDU
Cc: jimbo@crseo.ucsb.edu
Subject: Re: Question about PGBROWSE and postgres 4.2
Date: Mon, 25 Apr 94 15:48:05 -0700
Message-ID: <199404252248.PAA08480@faerie.CS.Berkeley.EDU> (raw)
In-Reply-To: <9404252238.AA00704@petal.spg.amdahl.com>

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: aoki@postgres.Berkeley.EDU, tjw00@spg.amdahl.com, jimbo@crseo.ucsb.edu
  Subject: Re: Question about PGBROWSE and postgres 4.2
  In-Reply-To: <199404252248.PAA08480@faerie.CS.Berkeley.EDU>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox