[EMAIL PROTECTED] (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'; http://www.ntlug.org/~cbbrowne/linuxxian.html "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 posting) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
