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.
In response to
pgsql-sql by date
|Next:||From: Olivier Hubaut||Date: 2004-03-31 12:28:10|
|Subject: Is it normal that functions are so much faster than inline queries|
|Previous:||From: Ivan Sergio Borgonovo||Date: 2004-03-31 11:07:56|
|Subject: Re: plpgsql vs. SQL in stored procedures|