Re: to pass a parameter

Sorry, but i made a mistake here !
the function dept or is equivalente coud not solve this problem (pass a
table name as a parameter)

In Oracle exist Dynamic SQL, is there something like that in postgres ?
Is it possible to execute a query built in a plpgsql function or do we
need to use Perl and the Pg module for exemple ?

Nicolas.

NRonayette wrote:

> (i copy/paste)
> Parameters
>
> A parameter is used to indicate a parameter in a SQL function. Typically
> this is used in SQL function definition statement. The
> form of a parameter is:
>
> $number
>
> For example, consider the definition of a function, dept, as
>
> CREATE FUNCTION dept (name)
> RETURNS dept
> AS 'select * from
> dept where name=$1'
> LANGUAGE 'sql';
>
> (i guess there's something more simple)
> Nicolas
>

> >
> > >> -----Original Message-----
> > >> From: jprem [mailto:jprem(at)srmsoft(dot)co(dot)in]
> > >> Sent: 09 June 2000 07:39
> > >> To: pgsql-general(at)postgresql(dot)org
> > >> Subject: [GENERAL] to pass a parameter
> > >>
> > >>
> > >> hello,
> > >> how can i pass a table name dynamically to a query ?
> > >>
> > >> in oracle we do
> > >> select * from &x
> > >>
> > >> how is it here ?
> > >> please help.
> > >>
> > >>
> > >>