Re: Function define question

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

Browse pgsql-sql by date

  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