Re: [SQL] PostgreSQL Function: how to know the number of the returned results of the Query

2009-09-02 Thread Harun Bolat
--- Original Message - From: "bilal ghayyad" To: Sent: Tuesday, September 01, 2009 3:53 AM Subject: [SQL] PostgreSQL Function: how to know the number of the returned results of the Query Hi List; I am building a function in the SQL (PostgreSQL), so I will be able to call this

Re: [SQL] PostgreSQL Function: how to know the number of the returned results of the Query

2009-08-31 Thread Pavel Stehule
Hello look on PERFORM and GET DIAGNOSTICS statements http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-NORESULT http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS regards Pavel Stehule 2009/9/1 bilal ghayyad :

[SQL] PostgreSQL Function: how to know the number of the returned results of the Query

2009-08-31 Thread bilal ghayyad
Hi List; I am building a function in the SQL (PostgreSQL), so I will be able to call this function using a SELECT query. Inside the body of this function, I was need to do the following but not able to know how: I have a SELECT statement (inside the function script itself), and I need to know