Question about stored procedures

From: "Greg" <greg(at)officium(dot)co(dot)za>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Question about stored procedures
Date: 2006-06-12 08:58:04
Message-ID: 000801c68dfe$50e3bdf0$f2ab39d0$@co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

From what I understand, a stored procedure in pgSQL is actually a function
that returns rows? Am I correct?

Can somebody show me the syntax for a basic stored procedure that takes an
argument?

i.e I would like the query to be "select name, email from users where userid
= @userid"

Sorry for the easy question but I looked at the docs and just can't seem to
find what I'm looking for.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Greg 2006-06-12 08:58:22 Easy SQL Question
Previous Message Christopher Browne 2006-06-12 05:29:34 Re: uh-oh