Hi,
I would be grateful, if any one could help me to write Stored Procedures in PostgreSQL. I am familiar with SQL Server procedures. A reply with one sample procedure is greatly appriciated.
Thanks in Advance
John
Dear All,
When I try to configure Postgres on Windows using CYGWIN, the followin errors occurs.
"no acceptable cc found in $PATH"
"no accpetable gcc found in $PATH"
Thanks in advance...
Sunu
Can I use cursors inside plpgsql functions?.
CREATE FUNCTION test() RETURNS text AS '
BEGIN
BEGIN WORK;
DECLARE emp_cur CURSOR FOR SELECT * FROM hpemployee;
FETCH FORWARD 2 FROM emp_cur;
CLOSE emp_cur;
COMMIT WORK;
END;
'language 'plpgsql';
The above code gives me error "parse...
I am working on crystal report 8.0 connected to PostgreSQL running on Linux Server. I had succesfully created a report using the PostgreSQL database. But when I am trying to view the report through web browser it is prompting for user id and password. I had given my PostgreSQL datsbase userid...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.