Re: Command Line option misunderstanding - Mailing list pgsql-novice

From Laurenz Albe
Subject Re: Command Line option misunderstanding
Date
Msg-id 30948e6771500c0e9d8b587f4e34165aadb1cc0b.camel@cybertec.at
Whole thread Raw
In response to Command Line option misunderstanding  (punch-hassle-guise@duck.com)
List pgsql-novice
On Mon, 2024-12-02 at 16:21 -0500, punch-hassle-guise@duck.com wrote:
> I am not trying to be contentious, but a simple search shows that every
> major implementation of SQL allows variables and there are hundreds if
> not thousands of pages dedicated to the idea of using variables in SQL
> and how they are fundamental.
>
>
> There are certainly reasons this doesn't work, but saying variables are
> psql specific......

You *are* trying to be contentious.

In PostgreSQL, there are psql variables, but no SQL variables.
You may not like that, that's okay. But that's how it currently
is, and it is documented like that.

If you want that to change, your best option is to review
https://commitfest.postgresql.org/51/1608/
which tries to introduce variables into SQL.

As far as I can tell, the SQL standard knows variables only
as host variables in embedded SQL.

Yours,
Laurenz Albe



pgsql-novice by date:

Previous
From: Ken Dibble
Date:
Subject: Re: Command Line option misunderstanding
Next
From: "David G. Johnston"
Date:
Subject: Re: Command Line option misunderstanding