Answers for "insert using condition postgres"

insert using condition postgres

WITH get_cust_code_for_cust_id AS (
    SELECT cust_code FROM cust WHERE cust_id=11
)

INSERT INTO public.table_1(
    cust_code, issue, status, created_on)
    VALUES (SELECT cust_code FROM get_cust_code_for_cust_id, 'New Issue', 'Open', current_timestamp)

Posted by: Guest on November-28-2021

Code answers related to "insert using condition postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "insert using condition postgres"

Code answers related to "insert using condition postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "insert using condition postgres"

Code answers related to "insert using condition postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us