notification-procs-postgresql.xql

DB Query file

Related Files

• packages/notifications/tcl/notification-procs.xql
• packages/notifications/tcl/notification-procs.tcl
• packages/notifications/tcl/notification-procs-postgresql.xql
• packages/notifications/tcl/notification-procs-oracle.xql

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>

    <fullquery name="notification::delete.delete_notification">
        <querytext>
            select notification__delete(:notification_id)
        </querytext>
    </fullquery>

    <fullquery name="notification::new.update_message">
        <querytext>
                update notifications
                set notif_html = :notif_html,
                notif_text = :notif_text
                where notification_id = :notification_id
        </querytext>
    </fullquery>

</queryset>