> how can i know the count of record in plpgsql.example if i'm query
> with query komponent from delphi i will know the record count of
> record.but how with plpgsql.
GET DIAGNOSTICS integer_var = ROW_COUNT;
See the manual for details (plpgsql section, "Obtaining the result status").
In response to
pgsql-sql by date
|Next:||From: Christoph Haller||Date: 2004-11-29 09:47:21|
|Subject: version 7.4 autocommit removed|
|Previous:||From: Tomasz Myrta||Date: 2004-11-29 09:30:33|
|Subject: Re: count record in plpgsql|