Re: [BUGS] 8.0.0beta1 small inconsistency in pg_aggregate listing

2004-08-20 Thread Fabien COELHO
> > Maybe something wrong with the regproc type? > > regprocout doesn't schema-qualify if the function name is unique without > it. Ok. Maybe too clever, as I couldn't guess by looking at it. > Of course, the function name isn't necessarily unique *with* it, either, > but regproc can't do anythi

Re: [BUGS] 8.0.0beta1 small inconsistency in pg_aggregate listing

2004-08-20 Thread Tom Lane
Fabien COELHO <[EMAIL PROTECTED]> writes: > Maybe something wrong with the regproc type? regprocout doesn't schema-qualify if the function name is unique without it. Of course, the function name isn't necessarily unique *with* it, either, but regproc can't do anything about that. Cast to regproc

[BUGS] 8.0.0beta1 small inconsistency in pg_aggregate listing

2004-08-20 Thread Fabien COELHO
I've noticed a minor inconsistency when listing pg_aggregate in current 8.0.0beta1 version. psql> SELECT aggfnoid FROM pg_aggregate; 4 functions are not schema qualified: count bool_and bool_or every although all others are shown with a schema name: pg_catalog.avg pg_catalog.sum pg_catal