Skip site navigation (1) Skip section navigation (2)

Adding flexibilty to queries

From: Alan Carbutt <arcarbut(at)adams(dot)edu>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Adding flexibilty to queries
Date: 2004-03-24 23:20:13
Message-ID: 1080170412.2444.18.camel@x.adams.edu (view raw or flat)
Thread:
Lists: 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(at)adams(dot)edu

Responses

pgsql-general by date

Next:From: Shelby CainDate: 2004-03-24 23:29:51
Subject: Re: pg_dump "what if?"
Previous:From: Dustin SallingsDate: 2004-03-24 23:03:06
Subject: Re: subversion vs cvs (Was: Re: linked list rewrite)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group