Re: [HACKERS] regression: select_views.sql
Vadim Mikheev <vadim@sable.krasnoyarsk.su>
From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Cc: hackers@postgresql.org
Date: 1998-02-24T03:39:57Z
Lists: pgsql-hackers
Thomas G. Lockhart wrote: > > > DATA(insert OID = 793 ( "<" PGUID 0 b t f 602 602 701 ... path_n_lt ... > > ^^^ > > this is float8 but path_n_lt() returns bool... > > > > The same for all path_n_* funcs (may be others too)... > > I'll fix this... Nice. There are other invalids: vac=> select oprname, oprcode from pg_operator where oprcanhash and oprname <> '='; oprname|oprcode -------+------------ ~= |intervalsame ^^^^^^^^^^^^^^^^^^^^ ok, but others are not! <> |intervalne < |intervallt > |intervalgt <= |intervalle >= |intervalge (6 rows) (BTW, oprcanhash can be used to let know does operator mean EQUALity... I'd like to use this for subselects) Vadim