Re: Adding flexibilty to queries

> > 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?

It doesn't work interactively, but you can assign variables like this:

    select name from name_table where person_id = :id;

I have to admit there are some sqlplus features I miss too (like the break
and compute features), and maybe one of these days I'll miss them enough
to add them to psql. :-)
--
Mike Nolan