Nurdin wrote:
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").

HTH
--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to