Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA20479; Mon, 27 Apr 92 08:07:22 -0700
Message-Id: <9204271507.AA20479@postgres.Berkeley.EDU>
From: Stuart Pook <stuart@genethon.genethon.fr>
Subject: no operator > for types float8 and int4
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Organization: Genethon, 13 Place de Rungis, 75013 Paris, France
 tel +33 1 45.65.13.00, fax +33 1 45.88.52.20
X-Face: "6o}6kk")qjUnYYq-`3_.vGq;@xj`3>#I/>4>E>DldCv:X#2%Rm+dr9HVN`g'#QgZFgsYsY
 .Q)bH:AoaW(n~=2B4aY?Q?{)1]&J+:LRX,qB>k{=6`K#2tRitzHKmi_9`}Lx0xdI*r!?MVNj7za"pZ
 *_QEm})y`y=vyyy~^0GY"HTvSCnv}eP*?{%zJ<r'BRk[r|J#;Im"Vp]!L
Date: Mon, 27 Apr 92 16:59:06 +0200
From: Stuart Pook <stuart@genethon.genethon.fr>

I have just built and installed postgres v3r1 on my Sun Sparc running
SunOS 4.1.2.  The build had one problem in that it tried to run
"/usr/local/src/postgres/bin/initdb" which does not exist:

	Compiling demo files...
	cc   -I../src/lib/H -c circle.c
	cc   -I../src/lib/H -c boxarea.c
	cc   -I../src/lib/H -c overpaid.c
	producing the setup script set-up-1.pq
	Creating video demo objects...
	producing the setup script set-up-1.pq
	done

	Initializing template database...
	install.sh: /usr/local/src/postgres/bin/initdb: not found

	Cleaning up...
	Installation complete.
	done

When I ran "/usr/postgres/bin/createdb postgres" I got the warnings
"InitStdio: !ValidPgVersion" & "Did you run initdb yet??" and so I ran
/usr/postgres/bin/initdb by hand.

However when I create a database added "foo" and run through the examples
in "The POSTGRES User Manual" I get lots of "no operator" error messages,
some of which I have listed at the end.  Does this have anything to do with
the bug "Some builtin functions cannot be called due to argument type mismatch"
as listed in postgres-v3r1.bugs?  If so could someone please indicate how
to apply the workaround?

Thanks for any help
Stuart Pook (stuart@genethon.fr)

Query sent to backend is
	"retrieve (result=EMP.salary/EMP.age) where EMP.name="Bill" "
NOTICE:Apr 27 16:59:08:there is no operator / for types float8 and int4 
NOTICE:Apr 27 16:59:08:You will either have to retype this query using an
NOTICE:Apr 27 16:59:08:explicit cast, or you will have to define the operator
WARN:Apr 27 16:59:08:/ for float8 and int4 using DEFINE OPERATOR

Query sent to backend is
	"retrieve into temp (EMP.name) where EMP.age<35 and EMP.salary>1000 "
NOTICE:Apr 27 16:48:41:there is no operator > for types float8 and int4
NOTICE:Apr 27 16:48:41:You will either have to retype this query using an
NOTICE:Apr 27 16:48:41:explicit cast, or you will have to define the operator
WARN:Apr 27 16:48:41:> for float8 and int4 using DEFINE OPERATOR

Query sent to backend is
	"retrieve (E1.name, E2.name)
	from E1 in EMP, E2 in EMP
	where E1.age=E2.age
	and E1.name != E2.name "
NOTICE:Apr 27 16:14:11:there is no operator != for types _char and _char
NOTICE:Apr 27 16:14:11:You will either have to retype this query using an
NOTICE:Apr 27 16:14:11:explicit cast, or you will have to define the operator
WARN:Apr 27 16:14:11:!= for _char and _char using DEFINE OPERATOR