Posts by Adriano Zorzi • 3 points

• 0

  votes

  2

  answers

  710

  views

  Q: Operator in postgres function returns SQL Error [42883]: ERROR: operator does not exist: integer = integer[]

  I have the following error in a function postgres SQL Error [42883]: ERROR: operator does not exist: integer = integer[] I tried to convert the data to varchar and text but still I could not return…

  sql postgresql function plpgsql

  asked 7 years, 5 months ago Adriano Zorzi 3

• 0

  votes

  1

  answer

  112

  views

  Q: Return result from a select inside a loop

  I’ve been trying for a few hours to get the result of a select that is within a pgsql function. I don’t have much experience with sql. I researched a little but I was not very successful. Follow my…

  sql plpgsql

  asked 7 years, 9 months ago Adriano Zorzi 3