Re: How to define + operator for strings - Mailing list pgsql-general

From Andrus
Subject Re: How to define + operator for strings
Date
Msg-id e2tgdv$2c8m$1@news.hub.org
Whole thread Raw
In response to How to define + operator for strings  ("Andrus" <eetasoft@online.ee>)
Responses Re: How to define + operator for strings  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
> text + text will tend to capture ambiguous cases,
> and thus possibly break queries that used to work (date + integer is a
> case that comes to mind as being at risk).

How to add + operator for strings so that  date+integer   expression is not
broken ?

> Refusing to deal with databases that can't handle the 14-year-old SQL
> standard spelling of concatenation would be a better plan IMHO --- if
> they can't get this right, it's unlikely that they are much better on
> a lot of other points that will be harder to work around.

I have huge amount of code written for this. Refusing is difficult.

Andrus.



pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Alternative for vacuuming queue-like tables
Next
From: Bruno Wolff III
Date:
Subject: Re: A few things on intervals