Re: Using the extract() function in plpgsql

From: "Kristis Makris" <kristis.makris@datasoft.com>

> Hi Peter,
>
> Thanks for looking into this. I tried the CREATE TABLE AS syntax within
> an EXECUTE command but I still get the same error message. The CREATE
> TABLE AS docs mention that this syntax is "functionalily equivalent" to
> the SELECT INTO, so it's no surprise that I get the same error message:
>
> NOTICE:  The execStmt is: CREATE TEMPORARY TABLE test AS SELECT
> extract(epoch from interval '62 days 22:30:48')
> ERROR:  EXECUTE of SELECT ... INTO is not implemented yet

In the example above you can just CREATE the table then INSERT into it -
avoids the whole issue. Is the example accurate?

- Richard Huxton