X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 2CF819FB24D
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 24 Aug 2006 14:07:25 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 29452-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 24 Aug 2006 14:07:17 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174])
	by postgresql.org (Postfix) with ESMTP id 38DE39FA6B2
	for <pgsql-sql@postgresql.org>; Thu, 24 Aug 2006 14:07:16 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id m3so565840ugc
	for <pgsql-sql@postgresql.org>; Thu, 24 Aug 2006 10:07:15 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=ZCHGl4HI67HlvPZ8YKuMn3voW+Nuh5hY7W6xt8j++iFZpNz8DmtWWQ9pwGqR6nxudirzuq5kLlARwKWiwNCh9WAU3otNO7Y62I4WF/j/2aBEjIK5wgncpZeUP1nE0FhYkdHF7xLjR+TisRa+SHgaDu6KC+fZitioSeeSDNCMTz4=
Received: by 10.66.224.3 with SMTP id w3mr1195631ugg;
	Thu, 24 Aug 2006 10:07:14 -0700 (PDT)
Received: by 10.67.118.11 with HTTP; Thu, 24 Aug 2006 10:07:13 -0700 (PDT)
Message-ID: <55c095e90608241007t3d004a14w9720cd66a60772e@mail.gmail.com>
Date: Thu, 24 Aug 2006 14:07:14 -0300
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Function to retrieve the Id column
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_108884_5079256.1156439234252"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.735 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200608/181
X-Sequence-Number: 26139

------=_Part_108884_5079256.1156439234252
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_108884_5079256.1156439234252
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi list,</div>
<div>&nbsp;</div>
<div>I have Id field that is used in all my database but my more often used parameter is a column called &quot;number&quot; that I have in more than 5000 magnetic cards, my question is.</div>
<div>&nbsp;</div>
<div>How could I make a function to retrieve this Id just passing the number as parameter, just like:</div>
<div>&nbsp;</div>
<div>getCardId(number: varchar)</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>Best regards ...</div>
<div>Ezequias</div>

------=_Part_108884_5079256.1156439234252--