Postgres Pro
Downloads
Home   >   mailing lists

question on passing parameter in sql query - Mailing list pgsql-sql

From Karthikeyan Sundaram
Subject question on passing parameter in sql query
Date
Msg-id BAY131-F28E2CC1D1B622B218CD5C3B09D0@phx.gbl
Whole thread Raw
Responses Re: question on passing parameter in sql query  ("Chad Wagner" <chad.wagner@gmail.com>)
system tables inquiry & db Link inquiry  ("Karthikeyan Sundaram" <skarthi98@hotmail.com>)
List pgsql-sql
Tree view 
Hi,

   I don't want to compare with Oracle and postgres. But I have a situation.
  I am using psql command line tool supplied by postgres.

   In Oracle I can say

    select * from emp where emp_id = &1

   Oracle will ask:
   Enter a value for 1:

   If I enter 10, then Oracle will get the empid=10

  What is the equal command in postgres ?

Regards
skarthi

_________________________________________________________________
Invite your Hotmail contacts to join your friends list with Windows Live
Spaces

http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us

pgsql-sql by date:

Previous
From: Philip Hallstrom
Date:
Subject: Re: Seeking quick way to clone a row, but give it a new pk.
Next
From: "Chad Wagner"
Date:
Subject: Re: question on passing parameter in sql query