Thread: Information schema tweak?

Information schema tweak?

From
Christopher Kings-Lynne
Date:
The current _pg_keypositions function generates the numbers from 1 to 32 
using a massive union, shouldn't it just use generate_series instead (to 
make it faster/simpler)?

Chris


Re: Information schema tweak?

From
Tom Lane
Date:
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> The current _pg_keypositions function generates the numbers from 1 to 32 
> using a massive union,

Only for very small values of "current" ...
        regards, tom lane


Re: Information schema tweak?

From
Christopher Kings-Lynne
Date:
> Only for very small values of "current" ...

Argh! Forgot it was a 7.4 server :)  Oops.