X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 25E8FD1E934 for ; Wed, 31 Mar 2004 07:07:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75163-05 for ; Wed, 31 Mar 2004 03:07:30 -0400 (AST) Received: from vsmtp14.tin.it (vsmtp14.tin.it [212.216.176.118]) by svr1.postgresql.org (Postfix) with ESMTP id 45D62D1E932 for ; Wed, 31 Mar 2004 03:07:28 -0400 (AST) Received: from caronte.webthatworks.it (80.180.154.149) by vsmtp14.tin.it (7.0.027) id 40571CC3002A0C7B for pgsql-sql@postgresql.org; Wed, 31 Mar 2004 09:07:28 +0200 Received: from stige.webthatworks.it (stige.webthatworks.it [192.168.1.5]) by caronte.webthatworks.it (Postfix) with ESMTP id F233C2300C0 for ; Wed, 31 Mar 2004 00:07:51 +0200 (CEST) Received: from stige.webthatworks.it (localhost [127.0.0.1]) by stige.webthatworks.it (Postfix) with SMTP id D9A52294068 for ; Wed, 31 Mar 2004 00:08:08 +0200 (CEST) Date: Wed, 31 Mar 2004 00:08:08 +0200 From: Ivan Sergio Borgonovo To: pgsql-sql@postgresql.org Subject: plpgsql vs. SQL in stored procedures Message-Id: <20040331000808.7aaedc33@stige.webthatworks.it> Organization: WebThatWorks.it X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i686-suse-linux) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/267 X-Sequence-Number: 17366 Is there a way to declare variables and use IF in plain SQL, not in plpgsql inside stored procedures?