Binding parameter in SELECT query for PostgreSQL [duplicate]

Question

select (CURRENT_TIMESTAMP - '60 days'::interval);

This shows me a current time stamp with an interval of 60 days getting subtracted.

SELECT VALUE
    FROM schema_name.some_parameter
    WHERE some_parameter.NAME LIKE 'some_reference_name'

I want to add the above query in SELECT so that I don't need to add the hardcoded data for 60 days. I want to get it through the parameter variable.

Basically i need to use nested queries where the second query gets me the 60 days value i.e. hardcoded in first query.

Is there a possible solution for my problem?

@GHostGambler : Kindly check my doubt and then mark it as duplicate. It was not about declaring a query but merging two queries as one. — champ.exe
– champ.exe, Commented Mar 6, 2019 at 5:16

Kaushik Nayak · Accepted Answer · 2019-03-05 09:26:39Z

1

Maybe something like this?

with v(val)
as
(
  VALUES(  CURRENT_TIMESTAMP - '60 days'::interval)
)
SELECT v.val  from
     schema_name.some_parameter cross join v
    WHERE some_parameter.NAME LIKE 'some_reference_name'

answered Mar 5, 2019 at 9:26

Kaushik Nayak

32k6 gold badges36 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

champ.exe Over a year ago

I do not want to use the hard coded data of 60 days. That is passed by the some_paramter file.

Kaushik Nayak Over a year ago

@Ankit : Ask a new question explaining clearly what you want, your description in the question is not clear. We can't read what's in your mind when you say "some_paramter file" etc?

champ.exe Over a year ago

In my first case I'm adding a hard coded value of 60 days which is already available in my parameter file. The second query has the 60 days parameter in it. I want to merge it with the first query and not use the hard coded 60 days mentioned in he first query.

champ.exe Over a year ago

Basically i need to use nested queries where the second query gets me the 60 days value i.e. hardcoded in first query.

Collectives™ on Stack Overflow

Binding parameter in SELECT query for PostgreSQL [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related