Postgres Pro
Downloads
Home   >   mailing lists

Re: count record in plpgsql - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: count record in plpgsql
Date
Msg-id 41AAEC39.3060600@klaster.net
Whole thread Raw
In response to count record in plpgsql  ("Nurdin" <dja.mnurdin@cma-cgm.com>)
List pgsql-sql
Tree view 
> 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.
>  
> any ideas?

Is it what you need:

GET DIAGNOSTICS n = ROW_COUNT;

after executing query ?

Regards,
Tomasz Myrta

pgsql-sql by date:

Previous
From: "Nurdin"
Date:
Subject: count record in plpgsql
Next
From: Richard Huxton
Date:
Subject: Re: count record in plpgsql