Re: versions

Al Bean wrote:
>
> mytestdb-# select current_timestamp;
> ERROR: parser: parse error at or near "select"

Are you sure? Try it again. I think you made a typo the first time. SQL
is not case sensitive (at least not in this case). "select
current_timestamp;" works fine for me.

> mytestdb=# create function test1() returns integer as 'begin return 1;
> end;' language 'plpgsql';
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
> Pre-installed languages are SQL, C, and internal.
> Additional languages may be installed using 'createlang'.

The error message is self-explanatory.

use from the command line:

# createlang plpgsql mytestdb

Jc