From: | "omid omoomi" <oomoomi(at)hotmail(dot)com> |
---|---|
To: | bchie(at)opensys(dot)com(dot)hk, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Function define question |
Date: | 2001-08-18 18:23:50 |
Message-ID: | F231Y6YHkidcDjoYAPN0000a135@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
hi,
It depends on the variable type:
foo=> create function f1( int4) returns int4 as'
foo'> select $1 ;'
foo-> language 'sql';
CREATE
foo=> select f1(4);
f1
--
4
(1 row)
regards
Omid
>From: "Bill" <bchie(at)opensys(dot)com(dot)hk>
>To: pgsql-sql(at)postgresql(dot)org
>Subject: [SQL] Function define question
>Date: Sat, 18 Aug 2001 13:23:33 +0800
>
>Hello all,
>
> Is it possible to define a function to pass parameter like this?
>
>function( parameter )
>but not
>function( 'parameter' )
>
>Regards
>Bill
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
From | Date | Subject | |
---|---|---|---|
Next Message | Horst Herb | 2001-08-19 13:20:06 | Re: how to use record type |
Previous Message | Bill | 2001-08-18 05:23:33 | Function define question |