Postgres类型的无效输入语法：

SELECT persistenceid, process_id, process_id AS case_id, completed_date_time,
       created_date_time::timestamp AT TIME ZONE 'EST' AS created_date_time,
       status, customer_id, request_type AS ticket_type, user_id, requestor_id,
       requester, customer_id, jira_ticket, feedback_type, priority,
       public_request, request_method, title,
       convert_from(lo_get(description::oid),'UTF8') AS description
FROM supportrequest
WHERE (user_id=5 OR requestor_id=5)
  AND customer_id='346361'
ORDER BY created_date_time DESC;

SELECT persistenceid, process_id, process_id AS case_id, completed_date_time,
       created_date_time::timestamp AT TIME ZONE 'EST' AS created_date_time,
       status, customer_id, request_type AS ticket_type, user_id, requestor_id,
       requester, customer_id, jira_ticket, feedback_type, priority,
       public_request, request_method, title,
            WHEN TRUE = description ~ '^[0-9\.]+$' THEN convert_from(lo_get(description::oid),'UTF8')
            WHEN FALSE = description ~ '^[0-9\.]+$' THEN description::varchar

Postgres类型的无效输入语法：

1 个回答