first try at postgres functions

From: "Kevin B(dot)" <db(at)ke5in(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: first try at postgres functions
Date: 2004-12-02 04:03:00
Message-ID: 33039.67.87.27.161.1101960180.squirrel@www.ke5in.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
I'm not sure why this does not work.

create or replace function test1() returns int as '
return 1;
' LANGUAGE 'plpgsql';

select test1();

--------------------------------------------------------

I also tried this:

create or replace function test1() returns int as '
select 1;
' LANGUAGE 'plpgsql';

select test1();

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2004-12-02 05:20:28 Re: first try at postgres functions
Previous Message Hasnul Fadhly bin Hasan 2004-12-02 01:09:01 BLOB