Skip site navigation (1) Skip section navigation (2)

Argument variables for select

From: Andreas Tille <tillea(at)rki(dot)de>
To: PostgreSQL SQL <pgsql-sql(at)hub(dot)org>
Subject: Argument variables for select
Date: 2000-08-28 08:06:13
Message-ID: (view raw or whole thread)
Lists: pgsql-sql

I want to use the following construct in a stored function:

Create Function VarSelect ( varchar, varchar )
   returns int
   As '
     Declare num int ;
       Select Into num Count(*) From $1 Where $2 ;
       return num;
     End ;
   ' language 'plpgsql' ;

Could someone please explain who to type the exact syntax so that
I can ship the table to select from as $1 and the condition to select
what as $2?  Or do I have to concatenate a string with the whole
select statement and how to call this string?  In MS SQL server this
could be done with 
   Exec ( query )

Kind regards



pgsql-sql by date

Next:From: Yury DonDate: 2000-08-28 09:21:32
Subject: Re: Argument variables for select
Previous:From: Richard RowellDate: 2000-08-28 07:56:05
Subject: Can I get this all in one query?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group