Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW actor.usr_message_penalty
- AS SELECT
- COALESCE(ausp.id::TEXT,'') || ':' || COALESCE(aum.id::TEXT,'') AS "id",
- ausp.id AS "ausp_id",
- aum.id AS "aum_id",
- COALESCE(ausp.org_unit,aum.sending_lib) AS "org_unit",
- ausp.org_unit AS "ausp_org_unit",
- aum.sending_lib AS "aum_sending_lib",
- COALESCE(ausp.usr,aum.usr) AS "usr",
- ausp.usr as "ausp_usr",
- aum.usr as "aum_usr",
- ausp.standing_penalty AS "standing_penalty",
- ausp.staff AS "staff",
- LEAST(ausp.set_date,aum.create_date) AS "create_date",
- ausp.set_date AS "ausp_set_date",
- aum.create_date AS "aum_create_date",
- LEAST(ausp.stop_date,aum.stop_date) AS "stop_date",
- ausp.stop_date AS "ausp_stop_date",
- aum.stop_date AS "aum_stop_date",
- ausp.usr_message AS "ausp_usr_message",
- aum.title AS "title",
- aum.message AS "message",
- aum.deleted AS "deleted",
- aum.read_date AS "read_date",
- aum.pub AS "pub",
- aum.editor AS "editor",
- aum.edit_date AS "edit_date"
- FROM
- actor.usr_standing_penalty ausp
- FULL OUTER JOIN
- actor.usr_message aum
- ON (
- ausp.usr_message = aum.id
- AND ausp.usr = aum.usr
- )
- WHERE
- NOT (ausp.id IS NULL AND aum.deleted);
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement