Skip site navigation (1) Skip section navigation (2)

Re: plpgsql vs. SQL in stored procedures

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>,pgsql-sql(at)postgresql(dot)org
Subject: Re: plpgsql vs. SQL in stored procedures
Date: 2004-03-31 12:06:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
On Wednesday 31 March 2004 12:07, Ivan Sergio Borgonovo wrote:
> I was used to do stuff like this with MS SQL
> create proc sp_getuid @uid uniqueidentifier
> Does it mean that to have variables in SP I'll have to use plpgsql
> in spite of plain SQL?

Yep - just like there you were using transact-sql (if I remember its name 
correctly) rather than sql.

The syntax is different (plpgsql bares a startling resemblance to the Oracle 
approach), the purpose of each is the same.
  Richard Huxton
  Archonet Ltd

In response to

pgsql-sql by date

Next:From: Olivier HubautDate: 2004-03-31 12:28:10
Subject: Is it normal that functions are so much faster than inline queries
Previous:From: Ivan Sergio BorgonovoDate: 2004-03-31 11:07:56
Subject: Re: plpgsql vs. SQL in stored procedures

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group