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

Re: plpgsql vs. SQL in stored procedures

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: plpgsql vs. SQL in stored procedures
Date: 2004-03-31 08:31:01
Message-ID: (view raw or whole thread)
Lists: pgsql-sql
mail(at)webthatworks(dot)it (Ivan Sergio Borgonovo) wrote:
> Is there a way to declare variables and use IF in plain SQL, not in
> plpgsql inside stored procedures?

The forthcoming support for recursive queries using a WITH clause
might provide, after a fashion, a way to declare variables.

As for IF, there is a functional equivalent to it in the form of the
SQL standard CASE statement.
select 'cbbrowne' || '@' || '';
"How should I know if it  works?  That's what beta testers are for.  I
only  coded  it."   (Attributed  to  Linus Torvalds,  somewhere  in  a

In response to


pgsql-sql by date

Next:From: Stephen QuinneyDate: 2004-03-31 10:41:27
Subject: Timestamp manipulation
Previous:From: Josh BerkusDate: 2004-03-31 06:14:46
Subject: Re: [SQL] SQL Spec Compliance Questions

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