Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 947C42E00FA for ; Thu, 27 Dec 2007 00:54:09 -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 01950-08 for ; Thu, 27 Dec 2007 00:53:56 -0400 (AST) Received: from hu-out-0506.google.com (hu-out-0506.google.com [72.14.214.236]) by postgresql.org (Postfix) with ESMTP id 5D3512E00F9 for ; Thu, 27 Dec 2007 00:54:05 -0400 (AST) Received: by hu-out-0506.google.com with SMTP id 22so1950995hug.23 for ; Wed, 26 Dec 2007 20:54:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=/9SAjp2Y1a2QRpu7yHg7dMikBefu3Rio0TKg9hHX7Xg=; b=B0KLMwNO5LV6Woxnp5JrGyt3pfSkeM/UsPJOf+5m+CWkq5TRDR45GYwpQq5M0ueo4Znt8q+AgIxeyopQ/ORW8obfhtpi81JU4L3IQhY+dSMCGBk53TcR69J8Z+lH0GAv1mCzWKh7GlxCCaoPMqBUmG8VOeILiEGf0t6MDFIs65s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=FdyO9xyzQlLzhP06vOJqq/CiaO8S17g7aGKnPHCysClyC7vcQ5slg+MBUbdcxaglD9FBApkZ9fzy+ZRx4PYwKQN1QXqzEH/ghu0D1dwSojyrGTEzXI73rF5wb8vgCIdKlv+Q+2gf2llLlkgAVwrVs9ufS0rYCn90zlZbXKrdmF8= Received: by 10.78.142.14 with SMTP id p14mr8981456hud.75.1198731243781; Wed, 26 Dec 2007 20:54:03 -0800 (PST) Received: by 10.78.35.10 with HTTP; Wed, 26 Dec 2007 20:54:03 -0800 (PST) Message-ID: <162867790712262054l19481519icf55948220399598@mail.gmail.com> Date: Thu, 27 Dec 2007 05:54:03 +0100 From: "Pavel Stehule" To: "Richard Broersma Jr" Subject: Re: how to use pgsql like mssql Cc: "pgsql-sql@postgresql.org" , liuzg2@21cn.com In-Reply-To: <536502.37602.qm@web31812.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <30781358.9441198721119056.JavaMail.root@webmail5> <536502.37602.qm@web31812.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/142 X-Sequence-Number: 29834 On 27/12/2007, Richard Broersma Jr wrote: > --- 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? > You can use outside procedure in T-SQL. Pavel > Regards, > Richard Broersma Jr. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >