| From: | Carmen Wai <carmen_wai(at)yahoo(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Problem on PostgreSQL (error code, store procedures) |
| Date: | 2002-07-06 06:45:12 |
| Message-ID: | 20020706064512.37016.qmail@web13401.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general pgsql-sql |
Hello,
I would like to know if there are any global variables
storing the error code or the number of rows affected
after each execution of the SQL statement.
Also, for Postgresql function, I have checked that I
can only call the function by: select function(parms)
or by EXECUTE PROCEDURE function(parms) in the trigger
action. I wonder whether there is any other method for
calling the function which is similar to the stored
procedures in the MS SQL server?
Thank a lot!
Carmen
__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2002-07-07 10:37:35 | Re: [pgadmin-support] HELP FOR POSTGRESQL NEEDED... |
| Previous Message | ozric tentacle | 2002-07-05 16:19:14 | HELP FOR POSTGRESQL NEEDED... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2002-07-06 10:07:03 | Re: I am being interviewed by OReilly |
| Previous Message | Marc G. Fournier | 2002-07-06 04:17:34 | Re: I am being interviewed by OReilly |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2002-07-07 10:59:13 | Re: bit field changes in 7.2.1 |
| Previous Message | Rajesh Kumar Mallah. | 2002-07-06 05:03:16 | Re: Is Dropping a column "CHECK" constraint possible? |