On Oct 14, 2008, at 14:50, Hannu Krosing wrote:
> Was current_setting('server_version') available in 8.1 ?
Yes. In 8.0, too.
>> There must be a way to get string_to_array() to evaluate only once,
>> yes?
>
> SELECT s.a[1]::int * 10000 + s.a[2]::int * 100 + s.a[3]::int
> FROM
> (SELECT string_to_array(current_setting('server_version'), '.') AS a)
> AS s;
Oh, duh. Even better!
Best,
David