From: | Chris Ryan <chris(at)greatbridge(dot)com> |
---|---|
To: | Andreas Tille <tillea(at)rki(dot)de> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Is this the wrong list? |
Date: | 2000-08-16 13:54:40 |
Message-ID: | 399A9D20.2B63A267@greatbridge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
You'd probably be better off in pgsql-sql(at)postgresql(dot)org(dot) Also look
under the programmers documention for the interfaces (Specific interface
questions should probably go to pgsql-interfaces(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ned Lilly | 2000-08-16 14:33:27 | Re: Great Bridge benchmark results for Postgres, 4 others |
Previous Message | Robert D. Nelson | 2000-08-16 13:50:00 | RE: List of Large sites using Postgres |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard E Nairn | 2000-08-16 16:16:55 | Trigger vs rule |
Previous Message | Andreas Tille | 2000-08-16 13:36:42 | Is this the wrong list? |