On 2017-01-27 10:05 AM, David Fetter wrote:
On Fri, Jan 27, 2017 at 02:27:37PM +0100, Christoph Berg wrote:
I frequently find myself in the situation that I want the "\x"
expanded output mode activated just for one query. There's little
wrong with typing "\x" and re-executing the query in that
On 12-06-23 12:17 AM, Tom Lane wrote:
D'Arcy Cain da...@druid.net writes:
On 12-06-22 07:09 PM, Robert Haas wrote:
I think DirectionFunctionCall2 is what you want.
Can you elaborate? I could not find a single hit in Google or the
documentation search on the PG site and it does not appear
On 12-06-23 08:21 AM, Dickson S. Guedes wrote:
Still nothing in the documentation. At least the search box doesn't
find it.
Try in the search box of postgres doxygen documentation [1]..
That's source, not documentation. I already found it in the actual
source files but that's not the same
On 12-06-22 07:11 AM, Florian Pflug wrote:
On Jun22, 2012, at 06:32 , D'Arcy Cain wrote:
So I have my type working now but I had to create a new C function
that take the opposite argument order. Seems redundant but I could
not see a better way.
There isn't. Postgres itself contains a huge
On 12-06-22 11:36 AM, Tom Lane wrote:
D'Arcy Cainda...@druid.net writes:
The thing is that either of those approaches is hugely more expensive
than just providing a second C function. It costs probably thousands
of cycles to inline that SQL function, each time it's used in a query.
I assumed
On 12-06-22 07:09 PM, Robert Haas wrote:
I think DirectionFunctionCall2 is what you want.
Can you elaborate? I could not find a single hit in Google or the
documentation search on the PG site and it does not appear anywhere
in the source distribution.
--
D'Arcy J.M. Cain da...@druid.net
Maybe I am using it wrong but I get no error message when I use it. I
have a type called chkpass (a version is in the additional supplied
modules) and I create the equality operator like this:
CREATE OPERATOR = (
PROCEDURE = eq,
LEFTARG = chkpass,
RIGHTARG = text,
On 12-06-21 12:18 PM, Tom Lane wrote:
Did you actually create a text = chkpass function and operator?
This declaration merely promises that you will provide one eventually.
The system does not have the ability to make one for you.
I guess I am missing the point of COMMUTATOR then. The docs
On 12-06-22 12:22 AM, Tom Lane wrote:
Um, an operator with different types on left and right cannot be its own
commutator.
Understood. I completely misunderstood the purpose of COMMUTATOR. I
thought that it was telling the system that the procedure could be
called with the arguments reversed