Question about stored procedures - Mailing list pgsql-novice

From Greg
Subject Question about stored procedures
Date
Msg-id 000801c68dfe$50e3bdf0$f2ab39d0$@co.za
Whole thread Raw
Responses Re: Question about stored procedures  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List 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…

 

pgsql-novice by date:

Previous
From: Philip Hallstrom
Date:
Subject: Re: uh-oh
Next
From: "Greg"
Date:
Subject: Easy SQL Question