כתב:
On Mon, 20 Aug 2018 at 09:22, Nick Dro <postgre...@walla.co.il> wrote:
This incorrect.
SELECT position(substring('https://www.webexample.com/s/help?' FROM '/(s|b|t)/') IN 'https://www.webexample.com/s/help?');
Gives 5. It's wrong.On Mon, 20 Aug 2018 at 09:22, Nick Dro &l
g(URL FROM '/(s|b|t)/') IN URL);Cheers,KenOn Sun, Aug 19, 2018 at 11:27 PM Nick Dro <postgre...@walla.co.il> wrote:Position function allows only string as pattern parameter:
select position(sub-string in string)
If you are looking for more than one sub-string you can't do it with a single
Position function allows only string as pattern parameter:
select position(sub-string in string)
If you are looking for more than one sub-string you can't do it with a single call to position.
More info:
make sence to have it in it's base code - ready for use rather than ask each one to implment his own.
ב דצמ׳ 19, 2017 17:51, Melvin Davidson כתב:
On Tue, Dec 19, 2017 at 4:54 AM, Pavel Stehule <pavel.steh...@gmail.com > wrote:
2017-12-19 10:13 GMT+01:00 Nick Dro <pos
is that postgresql should have build in function for percentage calculation it doesn't have to me the exact example I gave. Any thing will be better than none.
ב דצמ׳ 18, 2017 18:28, Michael Nolan כתב:
On Mon, Dec 18, 2017 at 6:23 AM, Nick Dro <postgre...@walla.co.il > wrote:
Hi,
Why Post
mathematical operations.
Can you give a good reason why absolute value has a build in function while percentage is not?
ב דצמ׳ 18, 2017 17:44, hubert depesz lubaczewski כתב:On Mon, Dec 18, 2017 at 02:23:38PM +0200, Nick Dro wrote:
>Hi,
>Why PostgreSQL doesn't have build-in function to cal