This works:
CREATE TEMP TABLE temp_medical_summary AS (SELECT * from
bov.medical_summary)

This gives an error:
CREATE TEMP TABLE IF NOT EXISTS temp_medical_summary AS (SELECT * from
bov.medical_summary)

It would seem that CREATE TABLE AS does not support IF NOT EXISTS. Is this
true?

David Waddy

Reply via email to