Function to retrieve the Id column

From: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Function to retrieve the Id column
Date: 2006-08-24 17:07:14
Message-ID: 55c095e90608241007t3d004a14w9720cd66a60772e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi list,

I have Id field that is used in all my database but my more often used
parameter is a column called "number" that I have in more than 5000 magnetic
cards, my question is.

How could I make a function to retrieve this Id just passing the number as
parameter, just like:

getCardId(number: varchar)

Best regards ...
Ezequias

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2006-08-24 17:24:16 Re: double precision vs. numeric
Previous Message Peter Eisentraut 2006-08-24 16:51:33 Re: double precision vs. numeric