Re: [HACKERS] regression: select_views.sql - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] regression: select_views.sql
Date
Msg-id 34F2410C.8ED7A4FB@sable.krasnoyarsk.su
Whole thread Raw
In response to regression: select_views.sql  ("Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>)
List 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

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh'
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Re: [HACKERS] Here it is - view permissions