Re: create query with date values - Mailing list pgsql-general

From David G. Johnston
Subject Re: create query with date values
Date
Msg-id CAKFQuwat+nTdtzYNG9peShburiZBLtUSqrV-eW1B+N8DV-xzzg@mail.gmail.com
Whole thread Raw
In response to create query with date values  (ourdiaspora <ourdiaspora@protonmail.com>)
List pgsql-general

On Friday, December 31, 2021, ourdiaspora <ourdiaspora@protonmail.com> wrote:
Recipients,

How to create a query such that when a date value is entered, the date may be associated with the result of another query.

The scenario is that a date value is entered (the plan is these dates should be a separate table), then a query result is joined with the date value.

Please advise the correct terminology for appropriate review of the manual.

You have normal queries, functions, and procedures.  I suppose a “prepared query” might also fit the bill.  Read up on those and, along with whatever application-level abstractions you choose to create, have tools for building queries.

David J.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: create query with date values
Next
From: Martin Mueller
Date:
Subject: a very naive question about table names in Postgres