Re: [GENERAL] Using Substitution Variables In PostgreSQL

2017-10-16 Thread Osahon Oduware
Thanks for the information. On Mon, Oct 16, 2017 at 3:27 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Mon, Oct 16, 2017 at 7:08 AM, Osahon Oduware > wrote: > >> Hi All, >> >> I wanted to find out how to use a substitution variable in an SQL >> statement that would cause the us

Re: [GENERAL] Using Substitution Variables In PostgreSQL

2017-10-16 Thread David G. Johnston
On Mon, Oct 16, 2017 at 7:08 AM, Osahon Oduware wrote: > Hi All, > > I wanted to find out how to use a substitution variable in an SQL > statement that would cause the user to be prompted for a value. Something > similar to the ampersand (&&) in ORACLE. > > For example, given the SQL statement be

Re: [GENERAL] Using Substitution Variables In PostgreSQL

2017-10-16 Thread Achilleas Mantzios
On 16/10/2017 17:08, Osahon Oduware wrote: Hi All, I wanted to find out how to use a substitution variable in an SQL statement that would cause the user to be prompted for a value. Something similar to the ampersand (&&) in ORACLE. For example, given the SQL statement below:     SELECT ,,