Thread: SET idiom in insert statement

SET idiom in insert statement

From
Kenneth Gonsalves
Date:
hi,
does any version of postgresql support the 'SET' idiom in an insert 
statement? Need this to generate an insert statement from a python dictionary
-- 
regards
kg
-- 
http://www.ootygolfclub.org


type conversions

From
sad
Date:
hi

SELECT 'tbl'::regclass;
works fine

SELECT 'tbl'::text::regclass;
says cannot convert type text to regclass

what to do ?