I am trying the below code to execute the Queries based on If condition in PostgreSQL. But the code throwing the error "ERROR: unexpected end of function definition at end of input Position: 1282". Can someone help what is the wrong I am doing here.
do $$ BEGIN IF ("public"."m_Users"."userName" = 'Bhargavi' AND "public"."m_Users"."userTypeId"!=1) THEN SELECT "public"."m_Users"."userName", "public"."m_Users"."userTypeId", "public"."m_school"."name" AS SchoolName, "public"."m_school"."mediumId", "public"."m_school"."city", "public"."m_teacher"."firstName" AS TeacherName FROM "public"."m_school" INNER JOIN "public"."m_Users" ON "public"."m_school"."id" = "public"."m_Users"."schoolId" INNER JOIN "public"."m_teacher" ON "public"."m_school"."id" = "public"."m_teacher"."schoolId" where "public"."m_Users"."userName" = 'Bhargavi' ORDER BY "public"."m_Users"."userName" asc ELSE SELECT "public"."m_Users"."userName", "public"."m_Users"."userTypeId", "public"."m_school"."name" AS SchoolName, "public"."m_school"."mediumId", "public"."m_school"."city", "public"."m_teacher"."firstName" AS TeacherName FROM "public"."m_school" INNER JOIN "public"."m_Users" ON "public"."m_school"."id" = "public"."m_Users"."schoolId" INNER JOIN "public"."m_teacher" ON "public"."m_school"."id" = "public"."m_teacher"."schoolId" ORDER BY "public"."m_Users"."userName" asc END if end $$
Aucun commentaire:
Enregistrer un commentaire