Adding flexibilty to queries - Mailing list pgsql-general

From Alan Carbutt
Subject Adding flexibilty to queries
Date
Msg-id 1080170412.2444.18.camel@x.adams.edu
Whole thread Raw
Responses Re: Adding flexibilty to queries
List pgsql-general
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

Attachment

pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Transaction Isolation Level
Next
From: Shelby Cain
Date:
Subject: Re: pg_dump "what if?"