Question about function

From: Robert Stachurski <zloty(at)home(dot)altech(dot)com(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about function
Date: 2000-11-16 14:20:47
Message-ID: Pine.BSF.4.21.0011161513220.12733-100000@home.altech.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to write any function which returns chars or few columns from
table but it dosn't work.

This my sample function and it dosn't work meybe sombady can help me and
tell what I'm doing wrong.
CREATE FUNCTION one(int4) RETURNS int4 AS 'select id from s_url where
id_url=$1;' LANGUAGE 'sql'

id is int4 and primary key
id is int4

and second question:
did I in good way sending parameters to the function.

Maybe sombady have few sample function which could send me, or same manual
files(but other than that which are in pgman).
Thanks
Robert

Browse pgsql-general by date

  From Date Subject
Next Message turing2000 2000-11-16 16:27:03
Previous Message Adam Lang 2000-11-16 13:47:42 Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL