Обсуждение: Function define question

Поиск
Список
Период
Сортировка

Function define question

От
"Bill"
Дата:
Hello all,
 Is it possible to define a function to pass parameter like this?

function(  parameter )
but not
function(  'parameter' )

Regards
Bill




Re: Function define question

От
"omid omoomi"
Дата:
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