Postgres Pro
Downloads
Home   >   mailing lists

Function to retrieve the Id column - Mailing list pgsql-sql

From Ezequias Rodrigues da Rocha
Subject Function to retrieve the Id column
Date
Msg-id 55c095e90608241007t3d004a14w9720cd66a60772e@mail.gmail.com
Whole thread Raw
Responses Re: Function to retrieve the Id column  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: double precision vs. numeric
Next
From: Michael Fuhr
Date:
Subject: Re: double precision vs. numeric