| From: | Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | plpgsql function question |
| Date: | 2007-04-03 17:42:22 |
| Message-ID: | BAY131-W7F67EF97B4EA5FFB34746B0670@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
Hi,
I am having a requirement here.
1) I need to write a plpgsql function where it takes the input parameter of a structure of a table.
2) The table has 15 columns
3) It does lots of validation based on the parameter and finally returns an integer as output parameters
Q) How will I passe the table structure as as parameter
2) Do I need to create a type?
Please help me.
Regards
skarthi
_________________________________________________________________
Take a break and play crossword puzzles - FREE!
http://games.msn.com/en/flexicon/default.htm?icid=flexicon_ wlmemailtaglinemarch07
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2007-04-03 18:18:43 | Re: plpgsql function question |
| Previous Message | Alexander Vysokovskih | 2007-04-03 14:58:15 | Re: UNIX TIME STAMP |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2007-04-03 18:18:43 | Re: plpgsql function question |
| Previous Message | Wilkinson, Jim | 2007-04-03 17:18:02 | Re: Using a variable as a view name in a select |