Home > mailing lists

Re: assign the row count of a query to a variable - Mailing list pgsql-sql

From	PFC
Subject	Re: assign the row count of a query to a variable
Date	January 15, 2005 00:13:11
Msg-id	opskl2ljx4th1vuj@musicbox Whole thread Raw
In response to	assign the row count of a query to a variable ("Kevin B." <db@ke5in.com>)
List	pgsql-sql

       var := count(*) from T;

or :
       SELECT INTO var count(*) from T;

From: "Kevin B."
Date: 14 January 2005, 23:43:42
Subject: assign the row count of a query to a variable

From: Michael Fuhr
Date: 15 January 2005, 00:16:08
Subject: Re: assign the row count of a query to a variable