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
--
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
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?
thnx
best and regard
nurdin
