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:[EMAIL PROTECTED]] > > >> Sent: 09 June 2000 07:39 > > >> To: [EMAIL PROTECTED] > > >> 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. > > >> > > >> > > >>
