Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] function source code not returning from inside a pgsql function. - Mailing list pgsql-sql

From Herwig Goemans
Subject Re: [SQL] function source code not returning from inside a pgsql function.
Date
Msg-id CAKaDz_EKJX5KP96KVqwsT2nU9eoSxXu7s9wbkm5ZV1nUniy80w@mail.gmail.com
Whole thread Raw
In response to Re: [SQL] function source code not returning from inside a pgsql function.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view
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@sss.pgh.pa.us>:
Herwig Goemans <herwig.goemans@gmail.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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] function source code not returning from inside a pgsql function.
Next
From: sqlQuestions
Date:
Subject: [SQL] Conditional Lookup Table with Like