Re: Research on ?? operators - Mailing list pgsql-general

From Steve Atkins
Subject Re: Research on ?? operators
Date
Msg-id 3C01A915-4C26-4803-81BD-2F68B304019F@blighty.com
Whole thread Raw
In response to Re: Research on ?? operators  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general

> On Jun 4, 2019, at 1:35 PM, Michael Lewis <mlewis@entrata.com> wrote:
>
> ":foo" named placeholders
>
> If I may, is this supported natively in Postgres prepared statements?

It's not. The only type we support are numbered $1 type placeholders.

> Can I see an example? I do not care much for the numbers of positional placeholders and would love to use names
insteadif possible. 

It'd be nice. They're supported via rewriting at the driver level in some drivers, and I've written shims to convert
themin an app a few times and it makes for much more readable - and bug-resistant - code. 

Supporting it at the protocol level would be very nice.

Cheers,
  Steve


pgsql-general by date:

Previous
From: Matteo Beccati
Date:
Subject: Re: Research on ?? operators
Next
From: Jeremy Finzel
Date:
Subject: Re: Questions about btree_gin vs btree_gist for low cardinality columns