On 01/27/2010 08:27 AM, Aycock, Jeff R. wrote:
Pavel, Per your suggestion I modified one line below BEGIN to look like this: EXECUTE 'SELECT *, $1, now() INTO "schema_1".'||"whoami"||' FROM "schema_2".'||"whoami"||' where created_dt between $2 and $3;' However, it is still giving me the same syntax error as before. I must be missing something here though.
On a hunch try CURRENT_TIMESTAMP instead of now().
Thanks for the suggestion, however. Regards, Jeff Aycock
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
