Postgres Pro
Downloads
Home   >   mailing lists

Dynamic prepare possible in plpgsql? - Mailing list pgsql-sql

From Collin Peters
Subject Dynamic prepare possible in plpgsql?
Date
Msg-id df01c91b0704301658r71068bf1jea60b8f6d6c5769c@mail.gmail.com
Whole thread Raw
Responses Re: Dynamic prepare possible in plpgsql?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
Is it possible to have a dynamic PREPARE statement in plpgsql?

Something like
PREPARE users_plan ( || 'text, text' || ) ASINSERT INTO pp_users( || 'col1, col2' || )VALUES($1, $2);

Regards,
Collin

pgsql-sql by date:

Previous
From: David Flegl
Date:
Subject: NEW to plpythonu function?
Next
From: "Collin Peters"
Date:
Subject: "is not distinct from" syntax error?