[SQL] count record in plpgsql

2004-11-28 Thread Nurdin
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

Re: [despammed] [SQL] update/insert data

2004-11-28 Thread Kretschmer Andreas
am Sat, dem 27.11.2004, um 12:55:40 -0500 mailte Keith Worthington folgendes: > Hi All, > > I have two tables in different schemas. The first table in the data_transfer > schema is loaded with a COPY command. I need to transfer the data to the > second schema inserting new records and updating