Received: from hotmail.com (f231.law14.hotmail.com [64.4.21.231]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7IINrP85446 for ; Sat, 18 Aug 2001 14:23:53 -0400 (EDT) (envelope-from oomoomi@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sat, 18 Aug 2001 11:23:52 -0700 Received: from 213.29.16.6 by lw14fd.law14.hotmail.msn.com with HTTP; Sat, 18 Aug 2001 18:23:50 GMT X-Originating-IP: [213.29.16.6] From: "omid omoomi" To: bchie@opensys.com.hk, pgsql-sql@postgresql.org Subject: Re: Function define question Date: Sat, 18 Aug 2001 18:23:50 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 18 Aug 2001 18:23:52.0261 (UTC) FILETIME=[EEB77F50:01C12812] X-Archive-Number: 200108/233 X-Sequence-Number: 4465 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" >To: pgsql-sql@postgresql.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