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' || '@' || 'ntlug.org';
"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 Quinney||Date: 2004-03-31 10:41:27|
|Subject: Timestamp manipulation|
|Previous:||From: Josh Berkus||Date: 2004-03-31 06:14:46|
|Subject: Re: [SQL] SQL Spec Compliance Questions|