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: 200403311306.04634.dev@archonet.com (view raw or flat)
Thread:
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
[snip]
> 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-2014 The PostgreSQL Global Development Group