Postgres Pro
Downloads
Home   >   mailing lists

Pass age function to extract function - Mailing list pgsql-general

From Adam Bruss
Subject Pass age function to extract function
Date
Msg-id D81DB5ADDC5C3B4484C581AF3D8EFF9D1A3848FE@ex2a.awr.local
Whole thread Raw
Responses Re: Pass age function to extract function  (Rick Genter <rick.genter@gmail.com>)
List pgsql-general
Tree view

Hello,

 

How can one pass a non string literal interval to the extract function?

 

For example:

 

SELECT starttime, extract(minute from interval testruntime) as runtime from ( select age(endtime, starttime) as testruntime, ref_testnames_serial, starttime, endtime, dense_rank() over (order by starttime desc) dr from dtprfrm764.orion_tests where ref_testnames_serial = 389 and pass = true) x WHERE dr <= 20 ORDER BY starttime asc

 

Does ‘minute from interval’ only accept string literals?

 

Thanks,

Adam

 

Adam Bruss

Development Engineer

AWR Corporation/Simulation Technology & Applied Research

11520 N. Port Washington Rd., Suite 201

Mequon, WI  53092  USA

P: 1.262.240.0291 x104

F: 1.262.240.0294

E: abruss@awrcorp.com

W: http://www.awrcorp.com

 

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: pervasiveness of surrogate (also called synthetic) keys
Next
From: Rick Genter
Date:
Subject: Re: Pass age function to extract function