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