Advertisement
Guest User

Untitled

a guest
Sep 9th, 2020
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. CREATE VIEW actor.usr_message_penalty
  2. AS SELECT
  3. COALESCE(ausp.id::TEXT,'') || ':' || COALESCE(aum.id::TEXT,'') AS "id",
  4. ausp.id AS "ausp_id",
  5. aum.id AS "aum_id",
  6. COALESCE(ausp.org_unit,aum.sending_lib) AS "org_unit",
  7. ausp.org_unit AS "ausp_org_unit",
  8. aum.sending_lib AS "aum_sending_lib",
  9. COALESCE(ausp.usr,aum.usr) AS "usr",
  10. ausp.usr as "ausp_usr",
  11. aum.usr as "aum_usr",
  12. ausp.standing_penalty AS "standing_penalty",
  13. ausp.staff AS "staff",
  14. LEAST(ausp.set_date,aum.create_date) AS "create_date",
  15. ausp.set_date AS "ausp_set_date",
  16. aum.create_date AS "aum_create_date",
  17. LEAST(ausp.stop_date,aum.stop_date) AS "stop_date",
  18. ausp.stop_date AS "ausp_stop_date",
  19. aum.stop_date AS "aum_stop_date",
  20. ausp.usr_message AS "ausp_usr_message",
  21. aum.title AS "title",
  22. aum.message AS "message",
  23. aum.deleted AS "deleted",
  24. aum.read_date AS "read_date",
  25. aum.pub AS "pub",
  26. aum.editor AS "editor",
  27. aum.edit_date AS "edit_date"
  28. FROM
  29. actor.usr_standing_penalty ausp
  30. FULL OUTER JOIN
  31. actor.usr_message aum
  32. ON (
  33. ausp.usr_message = aum.id
  34. AND ausp.usr = aum.usr
  35. )
  36. WHERE
  37. NOT (ausp.id IS NULL AND aum.deleted);
  38. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement