Re: function source code not returning from inside a pgsql function.

From: Herwig Goemans <herwig(dot)goemans(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: function source code not returning from inside a pgsql function.
Date: 2017-02-09 17:29:00
Message-ID: CAKaDz_EKJX5KP96KVqwsT2nU9eoSxXu7s9wbkm5ZV1nUniy80w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom,

You are right, that was the problem.
A reminder for me to read the function definitions I am using.

regards,

Herwig

2017-02-09 17:57 GMT+01:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Herwig Goemans <herwig(dot)goemans(at)gmail(dot)com> writes:
> > v_doc_fnc = replace(v_doc_fnc,'public.',null);
>
> I'm pretty sure that will result in NULL always. NULL is not another
> spelling for the empty string, no matter what Oracle says ;-)
>
> regards, tom lane
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message sqlQuestions 2017-02-16 22:19:57 Conditional Lookup Table with Like
Previous Message Tom Lane 2017-02-09 16:57:58 Re: function source code not returning from inside a pgsql function.