but  i do not   want use function  or  procedure 

wish this features




>From pgsql-sql-owner@postgresql.org Wed Dec 26 22:35:24 2007 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2C2792E0153 for ; Wed, 26 Dec 2007 22:35:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 54870-04 for ; Wed, 26 Dec 2007 22:35:05 -0400 (AST) Received: from web31812.mail.mud.yahoo.com (web31812.mail.mud.yahoo.com [68.142.207.75]) by postgresql.org (Postfix) with SMTP id 0433C2E0174 for ; Wed, 26 Dec 2007 22:35:13 -0400 (AST) Received: (qmail 38447 invoked by uid 60001); 27 Dec 2007 02:35:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=llmjoOS7WCYllBvh7vjZS3PpUl08v/fuO2xjer5gtW/V02S9FhloDMcVJIS0gUZj7iyJ4ZRXWhTdXLwy7LtJJS5dT6C5r5oAYsWAMSg6MAFYZU8nSoSZl6JfS2FZxJqdNJ6i9USOQUy5hx1PVi8yirdFev/g4brdiqU8MWY2P0Y=; X-YMail-OSG: IQ4D6YsVM1mz6ArfuSqYGKWc9DWpzOzS3PhHC3LK0GNHuSvLgcbEcniubb49_iv0JzmmMsRfZQ-- Received: from [75.84.89.248] by web31812.mail.mud.yahoo.com via HTTP; Wed, 26 Dec 2007 18:35:12 PST X-Mailer: YahooMailWebService/0.7.162 Date: Wed, 26 Dec 2007 18:35:12 -0800 (PST) From: Richard Broersma Jr Subject: Re: how to use pgsql like mssql To: "pgsql-sql@postgresql.org" , liuzg2@21cn.com In-Reply-To: <30781358.9441198721119056.JavaMail.root@webmail5> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <536502.37602.qm@web31812.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/141 X-Sequence-Number: 29833 --- On Wed, 12/26/07, liuzg2@21cn.com wrote: > but i do not want use function or procedure Are you sure? I thought that: DECLARE IF --control structures @@rowcount where only usable in a store procedure. Am I incorrect, or are these keywords accessible from the SQL prompt? Regards, Richard Broersma Jr.