Adding flexibilty to queries

Поиск
Список
Период
Сортировка
Искать
От
Alan Carbutt
Тема
Adding flexibilty to queries
Дата
Msg-id
1080170412.2444.18.camel@x.adams.edu
Список
Дерево обсуждения
Re: Adding flexibilty to queries Mike Nolan <nolan@gw.tssi.com>
Re: Adding flexibilty to queries James Thompson <jamest@math.ksu.edu>
Hi all,

I have a question regarding psql.  As I am more familiar with oracle I
can write the following select and make it rather flexible:
select name
from name_table
where person_id = &id;
The &id portion is what I am looking for in PostgreSQL.  Basically when
running this query, the person running the query is prompted to supply a
value.  What is the equivalent in postgres?

TIA,
-- 
Alan Carbutt
Systems Administrator/Programmer
Adams State College
719-587-7741
arcarbut@adams.edu
В списке pgsql-general по дате отправления
От: Kris Jurka
Дата:
От: Shelby Cain
Дата:
Сообщение: Re: pg_dump "what if?"
FAQ