postgresql function

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • artistlikeu
    New Member
    • Nov 2006
    • 38

    #1

    postgresql function

    i am writing a function. my function gives multiple redords as result.
    when i add a check (bool) constraint and call this function in check, error mess comes that sql query gives multiple records.Yes logically it should extrract one record for boolean check. Any hint ... or i have to add a loop in function so that my sql query must return single record.

    thnx....
  • ahammond
    New Member
    • Jan 2007
    • 7

    #2
    Originally posted by artistlikeu
    i am writing a function. my function gives multiple redords as result.
    when i add a check (bool) constraint and call this function in check, error mess comes that sql query gives multiple records.Yes logically it should extrract one record for boolean check. Any hint ... or i have to add a loop in function so that my sql query must return single record.

    thnx....
    Your question is incoherent. If you actually want to solve your problem, you might try posting the code, along with a description of what it's supposed to do, and what it's doing that's wrong.

    Comment

    Working...