plpgsql function question - Mailing list pgsql-admin

From Karthikeyan Sundaram
Subject plpgsql function question
Date
Msg-id BAY131-W7F67EF97B4EA5FFB34746B0670@phx.gbl
Whole thread Raw
List pgsql-admin

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! Play Now!

pgsql-admin by date:

Previous
From: Alexander Vysokovskih
Date:
Subject: Re: UNIX TIME STAMP
Next
From: Karthikeyan Sundaram
Date:
Subject: exception handling in postgres plpgsql