Re: Function define question - Mailing list pgsql-sql

From omid omoomi
Subject Re: Function define question
Date
Msg-id F231Y6YHkidcDjoYAPN0000a135@hotmail.com
Whole thread Raw
In response to Function define question  ("Bill" <bchie@opensys.com.hk>)
List 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@opensys.com.hk>
>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



pgsql-sql by date:

Previous
From: "Bill"
Date:
Subject: Function define question
Next
From: Horst Herb
Date:
Subject: Re: how to use record type