From: | NRonayette <r97m10(at)socotec(dot)fr> |
---|---|
To: | Michael Ansley <Michael(dot)Ansley(at)intecsystems(dot)co(dot)uk> |
Cc: | "'jprem'" <jprem(at)srmsoft(dot)co(dot)in>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: to pass a parameter |
Date: | 2000-06-09 10:05:53 |
Message-ID: | 3940C181.6F08F759@socotec.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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.
> >>
> >>
> >>
From | Date | Subject | |
---|---|---|---|
Next Message | lampe | 2000-06-09 10:17:03 | Cannot INDEX an Access97 ODBC export? |
Previous Message | lampe | 2000-06-09 10:01:56 | Cannot INDEX an Access97 ODBC export? |