Re: assign the row count of a query to a variable

From: PFC <lists(at)boutiquenumerique(dot)com>
To: db(at)ke5in(dot)com, pgsql-sql(at)postgresql(dot)org
Subject: Re: assign the row count of a query to a variable
Date: 2005-01-14 21:13:57
Message-ID: opskl2ljx4th1vuj@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


var := count(*) from T;

or :

SELECT INTO var count(*) from T;

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joel Fradkin 2005-01-14 21:15:02 I am writing a MS SQL server conversion utility and am having an issue with timestamp
Previous Message Kevin B. 2005-01-14 20:43:04 assign the row count of a query to a variable