Received: from ns1.engrs.org (ns1.engrs.org [216.54.29.10]) by hub.org (8.10.1/8.10.1) with ESMTP id e7GDv7n85490 for ; Wed, 16 Aug 2000 09:57:07 -0400 (EDT) Received: (from uucp@localhost) by ns1.engrs.org (8.9.3/8.9.3) id KAA20036; Wed, 16 Aug 2000 10:08:49 -0400 Received: from UNKNOWN(216.54.29.80), claiming to be "greatbridge.com" via SMTP by ns1.engrs.org, id smtpdP46toa; Wed Aug 16 14:08:43 2000 Message-ID: <399A9D20.2B63A267@greatbridge.com> Date: Wed, 16 Aug 2000 09:54:40 -0400 From: Chris Ryan Organization: GreatBridge LLC X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-6.1.1 i686) X-Accept-Language: en MIME-Version: 1.0 To: Andreas Tille CC: PostgreSQL General Subject: Re: Is this the wrong list? References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/341 You'd probably be better off in pgsql-sql@postgresql.org. Also look under the programmers documention for the interfaces (Specific interface questions should probably go to pgsql-interfaces@postgresql.org) There are ways to functions in Sql, PL/PgSQL, TCL etc. etc. It all depends on what you need to do. Here is a quick example on writing an sql procedure with parameters: (create table and add some data) CREATE FUNCTION get_user_age(int4) RETURNS int4 AS 'select user_age from user_tbl where user_id = $1' LANGUAGE 'sql'; select get_user_age(2); get_user_age -------------- 13 (1 row) Chris Ryan Andreas Tille wrote: > > On Mon, 14 Aug 2000, I wrote under the subject "Any SQL-functions examples > available": > > > I tried to write my first SQL-functions with the intention to > > port some stored procedures from MS SQL server. It would make my > > task much simpler if someone could point me to some simple > > examples which demonstate the use of function parameters in > > SELECT/INSERT statements and how to get the results transformed > > into reasonable return types, for instance if SELECT was successful > > return true else false, etc. > Is there any other list where I could expect answers to those simple > questions. I could not imagine that nobody has ever written some > simple tests with SQL functions. Perhaps this problem is to simple > here. > > Or may be I have the wrong philosophy and those functions are not > ment to be used in PostgreSQL? > > Kind regards > > Andreas.