Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5LEXIa99662 for ; Thu, 21 Jun 2001 10:33:18 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-32.mail.demon.net with esmtp (Exim 2.12 #1) id 15D5Wm-000H0a-0W; Thu, 21 Jun 2001 15:33:49 +0100 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id A0187136BB; Thu, 21 Jun 2001 15:28:32 +0100 (BST) Message-ID: <003701c0fa5e$722570a0$1001a8c0@archonet.com> From: "Richard Huxton" To: "Kristis Makris" Cc: References: <200106202233.f5KMXSa91452@postgresql.org> Subject: Re: Using the extract() function in plpgsql Date: Thu, 21 Jun 2001 15:28:29 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200106/329 X-Sequence-Number: 3616 From: "Kristis Makris" > 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