Thread

1. RE: to pass a parameter

   Michael Ansley <michael.ansley@intecsystems.co.uk> — 2000-06-09T08:38:49Z

   I'm under the impression that this substitution is performed by SQLPlus
   (somebody please correct me otherwise).  Hence, it's not the database server
   that needs to do this, but the client (i.e. shell, or psql).  This should be
   achievable using shell script, and psql.
   
   MikeA
   
   
   >>   -----Original Message-----
   >>   From: jprem [mailto:jprem@srmsoft.co.in]
   >>   Sent: 09 June 2000 07:39
   >>   To: pgsql-general@postgresql.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.
   >>   
   >>   
   >>   
   

2. Re: to pass a parameter

   NRonayette <r97m10@socotec.fr> — 2000-06-09T10:05:53Z

   Michael Ansley wrote:
   > 
   > I'm under the impression that this substitution is performed by
   > SQLPlus (somebody please correct me otherwise).
   
   it's true ! It's only available for SQLPlus.
   
   I'm a beginner with postgres, but i saw in the User's documentation that
   we can create a SQL function to pass parameter
   
   (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
   
   
     Hence, it's not the
   > database server that needs to do this, but the client (i.e. shell, or
   > psql).  This should be achievable using shell script, and psql.
   > 
   > MikeA
   > 
   > >>   -----Original Message-----
   > >>   From: jprem [mailto:jprem@srmsoft.co.in]
   > >>   Sent: 09 June 2000 07:39
   > >>   To: pgsql-general@postgresql.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.
   > >>
   > >>
   > >>
   
   

3. Re: to pass a parameter

   NRonayette <r97m10@socotec.fr> — 2000-06-09T17:03:25Z

   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@srmsoft.co.in]
   > > >>   Sent: 09 June 2000 07:39
   > > >>   To: pgsql-general@postgresql.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.
   > > >>
   > > >>
   > > >>