Re: Using the extract() function in plpgsql - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Using the extract() function in plpgsql
Date
Msg-id 003701c0fa5e$722570a0$1001a8c0@archonet.com
Whole thread Raw
In response to Re: Using the extract() function in plpgsql  (Kristis Makris <kristis.makris@datasoft.com>)
Responses Re: Using the extract() function in plpgsql
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Extracting date from epoche
Next
From: Jeff Eckermann
Date:
Subject: RE: arguments for query files