我发现只有在以下情况下SELECT * FROM t INTO my_data;
才有效:
DO $$
DECLARE
my_data t%ROWTYPE;
BEGIN
SELECT * FROM t INTO my_data WHERE id = ?;
END $$;
Great! How may I assist you today?
DO $$
DECLARE
my_data <WHAT HERE??>;
BEGIN
SELECT id,name,surname FROM t INTO my_data WHERE id = ?;
END $$;
my_schema.my_data
- 这在任何情况下都是安全的路线。请参见:https://dev59.com/h2ox5IYBdhLWcg3wpV3F#9067777 和 https://dev59.com/22Ij5IYBdhLWcg3wJB9-#24089729 - Erwin Brandstetter