On Tue, Dec 16, 2008 at 12:41 AM, jakot05
<jakot05@gmail.com> wrote:
On Mon, Dec 15, 2008 at 11:32 PM, Klint Gore
<kgore4@une.edu.au> wrote:
jakot05 wrote:
postgres=# CREATE LANGUAGE pgpsql
postgres-# ;
ERROR: unsupported language «pgpsql»
HINT: The supported languages are listed in the pg_pltemplate
... don't know what im doing wrong :-S
You have to put the "pl" on the front of it.
CREATE LANGUAGE plpgsql;
klint.
Thanks a lot Adrian and Klint!, its works :-)
--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350
Ph: 02 6773 3789 Fax: 02 6773 3266
EMail: kgore4@une.edu.au